How do you pass a T-SQL parameter into an SSIS package at runtime to get the right data to dump into an OLEDBDestination?

Question

Post reply

How do you pass a T-SQL parameter into an SSIS package at runtime to get the right data to dump into an OLEDBDestination?

emmett-281018

Valued Member

Points: 70
More actions
January 4, 2006 at 7:21 am

#166661

How do you pass a T-SQL parameter into an SSIS package at runtime to get the right data to dump into an OLEDBDestination?
For instance. I have a query that get data out of a number of different tables depending on what a particular _id is in the parent table (they are all linked through primary and foreign keys). I need to pass this _id into a package at runtime to get the proper data to dump into an access db.
can any one give me any ideas?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Kirk Haselden SSCommitted Points: 1683 More actions · Answer 1

Try this:

http://sqljunkies.com/WebLog/knight_reign/archive/2005/10/05/17016.aspx

HTH,

K

emmett-281018 Valued Member Points: 70 More actions · Answer 2

emmett-281018

Valued Member

Points: 70

January 4, 2006 at 10:21 am

#612666

Thank you Kirk

emmett-281018 Valued Member Points: 70 More actions · Answer 3

Do you know how I can set up the pacakge variables and access the stored procedure to get the actual data? (Including "AccessMode" = 4??? and OpenRowset properties.) Cheers, Emmett