Post reply

DTUTIL to folder in Package Store

  • April 21, 2015 at 3:56 am

    #303200

    SQL 2014

    Currently using

    DTUTIL /FILE c:\doughnuts.dtsx /DEC Mypassword /COPY DTS;FolderName\doughnuts.dtsx

    I am getting the top level folder "FolderName" is not found.

    I do not have access through SSMS to SSIS instance so can not see the folders. I have looks at Sysssispackages and Sysssispackagefolders to find the folder where the package already exists.

    Is there something I am missing?

    Cheers

    E

  • April 21, 2015 at 4:34 am

    #1792334

    Looks like I need to add MSDB at the beginning of the target path. Now its complaining a selection of characters in the name is wrong. When placing in the package store do you include the .dtsx?

    Cheers

    E

  • April 21, 2015 at 4:35 am

    #1792335

    Phew.

    Looked like dropping the extension worked.

    Cheers

    E

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

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