Pass parameters from SQL Table to SSIS package using dtexec

Question

Post reply

Pass parameters from SQL Table to SSIS package using dtexec

m.vitalyte

Valued Member

Points: 69
More actions
May 19, 2011 at 3:14 am

#240624

Hello,
I have created my SSIS package with a number of different tasks.
Then, I have created some configurations and placed them in SQL Server configurations table (attached example image). Configurations will be used for: in some cases I need to execute only some of the tasks, in other cases - disable some tasks and execute other tasks.
What I need to do:
I need to execute SSIS package using command line (using DTEXEC). But I also need to pass the parameters (values) that are specified in the SQL Server configuration table.
Can anyone give me some advice on that. How should I make it?
Thank You.
Milda

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

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

Phil Parkin SSC Guru Points: 247180 More actions · Answer 1

Can you give some background on what you are doing - what method are you using to run DTEXEC?

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 2

Milda

If you have enabled package configurations in your package then those "parameters" should be passed in automatically whenever the package is loaded.

John

m.vitalyte Valued Member Points: 69 More actions · Answer 3

I'll write my problem more simplier:

I need to run DTEXEC command with parameters, that are stored in MS SQL database.

How can I do that?

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 4

If your parameters are stored in a table that looks like the [SSIS Configurations] table that is created when you enable package configurations for a SQL Server table, then you'll be able to do as I suggested.

John

Edit - I've just looked at your attachment and it seems everything is in place. If you have Package configurations enabled in your package, it should work.

m.vitalyte Valued Member Points: 69 More actions · Answer 5

Thank you, John.

But there is one more thing. You can see in that image, that there are more than one configuration filters. So in the dtexec comand i need to indicate which configuration filter to use.

Can you help me with this? How can I do it?

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 6

You can specify in your package at design time which configuration filter to use. If you want to specify a different one at run time, I don't know how you do that. What you can do instead is use a configuration file instead and point dtexec at that when you run it.

John