• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 752
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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