I had been working on a simple ETL SSIS package to simply pull data from a file, parse it, and insert it into some tables on a SQL 2005 box. In my dev and testing environment the package ran extremely fast... under a couple of seconds. But as soon as I added the package to our QA environment and schedule...

I found this neat (and free) trash destination for SSIS. It's really great as a development aid. It allows you to quickly terminate a data flow path, and does not require any configuration. It will consume the rows without any side effects, and prevents warnings or errors you may otherwise receive when...

I was working on an SSIS project to dump data from an Excel spreadsheet into a database table. However, the Excel file happened to be a beautifully formatted, colorful, presentation of charts and graphs, subtotal rows and all sorts of interesting images. The actual data I needed to dump didn't even start...

Amazon.com: Beginners Guide to SQL Server Integration Services Using Visual Studio 2005: Jayaram Krishnaswamy: Books ISBN : 1847193315 ISBN-13 : 9781847193315 The back cover of the book states that the intended audience is ..."beginners in the developer track who are looking to get an exposure to...