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.