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

SQLRunner

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

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.

Comments

Leave a comment on the original post [feedproxy.google.com, opens in a new window]

Loading comments...