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)
1,908 reads
Learn how to export data from SQL Server into Excel and programmatically add new columns to the spreadsheet using C#.
2021-04-13
Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.
2020-06-30
7,052 reads
In this article you will learn how to use BCP for SQL Server on Linux to export and import data using the BCP command line utility.
2020-01-30
10,976 reads
It is Friday, the queries are running, and nobody is watching the bill. That...
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Comments posted to this topic are about the item Changes, Happiness, and a Few...
Comments posted to this topic are about the item BCP on Linux
Comments posted to this topic are about the item You Probably Don't Need a...
When running bcp on Linux, what is the field terminator?
See possible answers