Blog » By Josef Richberg on Josef Richberg

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.

  1. the link is broken

Speak Your Mind

  • No HTML is allowed.