We cannot import multiple packages on the SSIS server. So, loading 100 packageS from file location will be a tedious task for a DBA. We can solve this issue by making use of the DTUTIL utility. The DTUTIL utility can also import one package at a time, but we can write the batch file using the […]
2021-09-27 (first published: 2021-09-22)
520 reads
Learn how you can move data from your Data Lake to Azure SQL Database with Azure Data Factory.
2019-07-31 (first published: 2018-03-28)
2,251 reads
This tip will show eight ways to export the results of a query to a text file.
2017-10-06 (first published: 2016-10-26)
332,639 reads
Generates script to Export all tables to CSV files
2016-03-25 (first published: 2015-01-30)
2,242 reads
Takes a given table and generates a UNION ALL'd set of rows from the table. Useful for copying small amounts of data without the need for SSIS or import/export wizard
2013-11-14 (first published: 2013-10-31)
1,165 reads