Re: Executing SSIS package by passing parameters from command line



You can use a user variable, then you can just set the value of the variable
from the command line.
Here is an example:


DTEXEC /SQL "\2530\Headers" /SERVER SQL2005SERVER /SET
"\Package.Variables[User::ID].Properties[Value]";5849



cheers
Francisco A. Gonzalez
fgonzalez@xxxxxxxxxx



"Sal" <Sal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:51CF6E87-4C81-4FC7-BE56-265D7C410F30@xxxxxxxxxxxxxxxx

I want to Execute SSIS package by passing parameters from command line
just
like we could use DTSRun command in sql server 2000. Please let me know.

Thanks


.



Relevant Pages


Loading