-1
votes
2answers
744 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.
64
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 ...