Post reply

ssis from file system to msdb

  • March 8, 2010 at 12:01 pm

    #138618

    I need T-SQL to import packages from File System to MSDB with protection level - Rely on server storage and access control.

    I can able to do by GUI

    Connect to SSIS instance - MSDB - Right click-import package - Select Package location - File System , Package path - location of dtsx file , Protection Level - - Rely on server storage and access control.

    However I need T-SQL to do this....

  • March 8, 2010 at 1:05 pm

    #1130228

    I am about 99% sure you can't because SSIS will NOT store unencrypted passwords in a DTSX file in the file system.

    CEWII

  • March 8, 2010 at 3:40 pm

    #1130326

    I would look into dtutil.exe that may have what your looking for. There's a ton of options available. If the package is password protected then the sensitive data would still be there and if the destination of the copy is SQL you should be able to switch it to server storage without a loss of sensitive data.

    here is a simple example copying a package from the file system to the server:

    dtutil /FILE C:\SourceFile.dtsx /DestServer MyMSSQLServer /COPY SQL;SourceFile

    Check here for all the dtutil switches:

    http://msdn.microsoft.com/en-us/library/ms162820.aspx

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

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