dtutil notes

REM copy package to server
dtutil /file my_package.dtsx /copy sql;”\the_folder\my_package” /dests my_server

REM copy and encrypt package to server
dtutil /file my_package.dtsx /encrypt sql;”\the_folder\my_package”;5 /dests my_server

REM copy encrypted pacage to file system
dtutil /sources my_server /sql “\my_package” /encrypt file;”c:\tmp\my_package”;4

REM delete page
dtutil /sql “\the_folder\my_package” /sources my_server /DEL

REM rename folders
dtutil /SourceServer my_server /FRename SQL;”\;folder_a;folder_b”

REM create folder
REM The “/” means root folder.
dtutil.exe /SourceServer mySqlServer /FCreate SQL;/;NewFolder

REM list packages including subfolders
dtutil /fdirectory SQL;S /sources my_server

REM exists
dtutil /SQL \the_folder\my_package /Exists /sources my_server

reference: http://www.eggheadcafe.com/aspnet_answers/SQLServerdts/May2006/post26745426.asp
http://www.databasejournal.com/features/mssql/print.php/3600201
http://msdn.microsoft.com/en-us/library/ms162820.aspx

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s