Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 748
  • Last Modified:

SSIS - Using Input Paramter for OLE DB Source

Hello Experts.

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.

0
WaldaInc
Asked:
WaldaInc
  • 2
1 Solution
 
PedroCGDCommented:
To call  a package from an asp website check my blog... there is there an example.
Now, you need to create a SSIS variable to store the parameter... and inside dataflow, you need to add the SSIS parameter to the pipeline (using for example a derived column) and inside OLEDB Command just put the statment EXEC MyStoredProcedure ? and in the mappings tab set the ? to the SSIS Variable.

Helped?
regards,
Pedro

www.pedrocgd.blogspot.com
0
 
WaldaIncAuthor Commented:
Thanks Pedro.

Yes, I will read your blog and the SSIS variable sounds like the way to go.

Give me a few days to familarize myself with these items (SSIS variable and your blog, then I'll award you the points.

Thanks again.

0
 
PedroCGDCommented:
ok my friend!
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now