SQL Server Integration Services: Difference between revisions

Content deleted Content added
{{Anchor|A-tools}}Other included tools: Failed verification ... where this was a WP:HIJACK or WP:OPINION at some point I am unsure.,
{{Anchor|A-tools}}Other included tools: Provide a decide source. I just give up and off to the junction
Line 67:
DTUTIL provides the ability to manage packages from the [[Windows command prompt|command prompt]].<ref>{{cite web | url = http://msdn.microsoft.com/en-us/library/ms162820%28v=sql.105%29.aspx | title = dtutil Utility (SSIS Tool) | access-date = 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 | access-date = 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.
 
The Bulk Copy Program (BCP), is a [[Console application|command-line tool]] used to import or export data against a [[Microsoft SQL Server]],<ref name="FIPADA">{{cite book|last1=Rankins|first1=Ray|last2=Bertucci|first2=Paul|last3=Jennsen|first3=Paul|date=December 2002|title=Microsoft SQL Server 2000 Unleashed|edition=2|publisher=Sams|___location=Indiana|isbn=9780672324673|oclc=474621100|pp=86–87}}</ref> or Sybase [[database]].<ref>{{cite web|url=http://msdn.microsoft.com/en-us/library/ms162802.aspx|title=Microsoft SQL Server bcp Utility|publisher=Microsoft|date=April 2010|ol=OL7668515M}}</ref>{{Failed verification|reason=Sybase not mentioned on source nor on archives around the claimed date of 2010 as far as I can tell}}{{better source needed|date=May 2021}}
 
==Extensibility and programmability==