Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in


This blog is syndicated from SSIS - SQL Server Tidbits(

SSIS Script Component Source -- Proc/Select Stmt

I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks" presentations.  I had to build one moments ago and realized I am tired of looking back through my presentations to build them.  Here is a sample script that you can use to build your own custom Script Component Source.  It shows how to use:


  • stored procedure
  • stored procedure with parameters
  • select statement


You can find the script here.


Leave a comment on the original post [, opens in a new window]

Loading comments...