Post reply

SSIS 2008 Package deployment into MSDB package store using DTUTIL

  • June 15, 2011 at 10:56 am

    #237912

    Hi,

    I have created package stores inside MSDB (sub folders under MSDB) and trying to deploy my packages using DTUTIL command. I am able to deploy package to MSDB using the below command but not able to do it directly to a sub fodler under MSDB. Can someone please help me out on the command?

    I am currently using the below command

    for %f in (My package.dtsx) do dtutil /File %f /DestServer MYSSISServer /copy SQL;%~nf /Q

  • October 14, 2011 at 9:50 am

    #1394732

    Same question....

  • October 14, 2011 at 11:45 am

    #1394794

    [font="Arial"]The /COPY option of the DTUTIL command itself asks for the path of the package. This path can include sub-folders as you are expecting. So, if you have created a sub folder by the name Test1 you can use the below command and it will obey you:

    for %f in (My package.dtsx) do dtutil /File %f /DestServer MYSSISServer /copy SQL;Test1\%~nf /Q [/font]

  • October 16, 2011 at 6:52 am

    #1395056

    Thank you.

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

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