Browse by Tags
All Tags »
SQL Server (
RSS)
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...
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...
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...
More Posts