The tag has no wiki summary.

learn more… | top users | synonyms

65
votes
13answers
6k views

My boss has a bad case of “Not Invented Here”

My department specializes in converting customer data into our database schema so that they can use our software. Right now, we have C# applications that take an IDataReader (99% of the time it is a ...
4
votes
5answers
2k views

SSIS: How long does it usually take to bring a new hire up to speed? [closed]

I’m a self-taught SQL developer that has worked for small to mid-sized companies. Most of my experience has been writing SQL statements for reporting, data scrubs, and never in a formalized IT ...
4
votes
6answers
4k views

What are the disadvantages of using stored procedures, SSIS, and SSRS to implement business applications? [closed]

Recently, it was suggested that many projects (where I work) should be implemented using some combination of stored procedures (on SQL Sever / T-SQL), SSIS, and SSRS. In one specific project, SSIS ...
3
votes
1answer
337 views

Using SSIS, any good tutorials [closed]

I was look for a good resource to learning SQL Server business Studio and in particular SSIS packages, any sugguestions?
-1
votes
2answers
838 views

SQL Server: When to use SSIS vs T-SQL for ETL Tasks [closed]

When should I use one versus the other? For instance, let's say I have 20 comma delimited, denormalized text files and I want to transform the data and load it into normalized SQL Server tables.