Great article and I am looking forward to the rest of the series. I am just starting to learn SSIS as my company is looking for faster ways to view data. I am hoping to run SSIS packages which reads data and dumps it into an excel file which can be viewed by managers.
We are finding reports from our ERP to be very slow and the time it takes to run queries which produce the same data is 10 times faster.
I just have a couple of questions for you. You mention C# as a scripting tool in conjunction with SSIS. How important is it to know C# for SSIS and what shortcomings do you face without it?
Is it difficult to take queries I have successfully run and transport them into an ssis package to be run as a job?
Thanks for the article and your reply.