_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
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

語 譯朱覦 碁朱れ 炎概蠍 覦 レ覓殊 覿豎れ 螳 讀覈 譴. 蠏碁れ 蟇磯 ろ 蠍磯ゼ 讌 蠍 覓語 豪Μ螳 . (B.C 觚)