SQL Server Integration Services: Difference between revisions

Revision as of 11:32, 28 October 2013

Revision as of 16:43, 12 November 2013

Line 56:

DTUTIL provides the ability to manage packages from the [[command prompt]].<ref>{{cite web|url=http://msdn.microsoft.com/en-us/library/ms162820%28v=sql.105%29.aspx|title=dtutil Utility (SSIS Tool)|accessdate=2013-03-24|publisher=Microsoft|work=Microsoft Developer Network}}</ref><ref>{{cite web|url=http://www.databasejournal.com/features/mssql/article.php/3734096/Using-dtutil-to-copy-SSIS-packages-stored-in-SQL-Server.htm|title=Using dtutil to copy SSIS packages stored in SQL Server|accessdate=2013-03-24|date=2008-03-20|publisher=Database Journal|author=Yan Pan}}</ref> The tool can copy or move a package from a file into the server store, or back out again. Among a few other sundry functions,it can be used to delete, rename, encrypt, or decrypt packages.

==Extensibility and programabilityprogrammability==

Users may write code to define their own connection objects, log providers, transforms, and tasks.<ref>{{cite web|title=Developing a Custom Data Flow Component|url=http://msdn.microsoft.com/en-us/library/ms136078.aspx|work=Microsoft Developer Network |publisher=Microsoft |accessdate=22 March 2013}}</ref><ref>{{cite web|title=Developing a Custom Task|url=http://msdn.microsoft.com/en-us/library/ms135965.aspx|work=Microsoft Developer Network |publisher=Microsoft |accessdate=22 March 2013}}</ref>