_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › dtutl

Contents

1 File System to Sql Server
2 File System to File System
3 Sql Server to Sql Server
4 Sql Server to File System
5 Delete from File System
6 Delete from Sql Server



1 File System to Sql Server #

dtutil /FILE D:\Sample.dtsx /DestServer DEL1-LDL-40215\MSSQLSERVER2012 /Copy SQL;Raj\Sample /DestU sa /DestP Global@123 /Q

2 File System to File System #

dtutil /FILE D:\Sample.dtsx  /COPY FILE;D:\NewSample.dtsx /Q

3 Sql Server to Sql Server #

dtutil /SQL Raj\Sample /SourceServer DEL1-LDL-40215\MSSQLSERVER2012 /SourceU sa /SourceP Global@123 /DestServer DEL1-LDL-40215\MSSQLSERVER2012 /Copy SQL;Raj\NewSample /DestU sa /DestP Global@123 /Q

4 Sql Server to File System #

dtutil /SQL Raj\Sample /SourceServer DEL1-LDL-40215\MSSQLSERVER2012 /SourceU sa /SourceP Global@123 /COPY FILE;D:\NewSample.dtsx /Q
DTUTIL command can also be used to delete deployed SSIS package.

5 Delete from File System #

DTUTIL /FILE D:\Sample.dtsx /DELETE

6 Delete from Sql Server #

DTUTIL /SQL \Raj\H1 /DELETE /SourceServer DEL1-LDL-40215\MSSQLSERVER2012 /SourceU sa /SourceP Global@123
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2020-11-11 09:31:52

襯 蠏 襯 襷 螳讌螻 伎 讌襷 襯 覯 蠏瑚 蠍一牛螻 伎 . (れ襦)