SSIS - Using Input Paramter for OLE DB Source
Posted on 2009-04-02
I have an SSIS Package that is going to select data with an OLE DB Source, execute a bunch of stored procs via an OLE DB Command for each row in the Source record.
The original select statement in the OLE DB Source has a hard-coded paramter (@JobID). I want to make the SSIS package to either look in a text file or even prompt me for the JobID. Eventually I will be launching this from a web page, so I guess I need to know how to pass it down that way too.
Any and all comments are welcome.