SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


This blog is syndicated from SSIS - SQL Server Tidbits(http://www.josefrichberg.com/)

Archives: November 2010

SSIS : Using variables as a source in a Data Flow Component

Currently, none of the existing Data Flow sources allow you to source variables.  Once again in my quest for performance, I look to keep as much data as possible in memory.  There are many uses for pushing data to external files (Raw Files, control files, etc), but there is a… Read more

0 comments, 762 reads

Posted in SQLRunner on 12 November 2010

SSIS: Using a Script Component as a substitute OLEDB Destination

I developed an SSIS package that loads invoices, statements, pro-formas, etc. into a SQL Server table.  The invoices are .pdf files and the business required that no identical documents were allowed to be stored.  To determine uniqueness I simply created a hash of each document and used it as the… Read more

0 comments, 587 reads

Posted in SQLRunner on 5 November 2010