Post reply

Running SSIS Package through SP

  • October 21, 2008 at 7:51 am

    #194753

    Hello,

    I had created one SSIS package which export the mdb file to SQL server 2005 table.

    That package i successfully run using SQL Agent Job.

    This package save with the protectionlevel EncryptAllWithUserKey

    But i want to run the same package through SP for that i used the following command

    'dtsrun /S Cnergies-srv\SQL2005 /E /F "G:\inetpub\wwwroot\AMW\LMS_AMW_Details\DTS_Package\Package (1).dtsx"'

    but i got error Error string: The specified DTS Package ('Name = '[not specified]'; ID.VersionID = {[not specified]}.{[not specified]}') does not exist.

    Please help me in that.

    Thanks and Regards

  • October 21, 2008 at 11:43 am

    #887758

    Hi,

    Best way to paste the script is run dtsrunexec.exe in dos, fill all the columns and then when it displays the command, copy and paste. This would help you.

    Rajesh

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

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