February 9, 2009 at 6:22 am
hi all
I am new to ssis side .I m trying to execute the SSis package using the below command
dtexec /SQL "\SSIS_TEST" /SERVER %Server% /USER %User% /PASSWORD %Password% /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V /CONSOLELOG NMT >> %log%
I getting the following error
'dtexec' is not recognized as an internal or external command,
operable program or batch file.
Can any one help me in this.....
February 9, 2009 at 6:41 am
melvin.prasath (2/9/2009)
dtexec /SQL "\SSIS_TEST" /SERVER %Server% /USER %User% /PASSWORD %Password% /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V /CONSOLELOG NMT >> %log%
Try This:
dtexec /FILE "PackagePath" /CONFIGFILE "ConfigFilePath" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EI
February 9, 2009 at 6:48 am
Thanks
I deployed the SSIS in sql server .whether your soultion will still work.
February 10, 2009 at 12:29 am
Yes... If you give the correct path in command.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply