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,282 reads
Learn how to export data from SQL Server into Excel and programmatically add new columns to the spreadsheet using C#.
2021-04-13
In this article we look at how we can use R and SQL Server to import lottery numbers from a PDF document into a SQL Server table.
2021-01-11
In this article we look at PowerShell code you can use to import Excel data into SQL Server.
2021-01-05
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
8,977 reads
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Comments posted to this topic are about the item Running a Service
Comments posted to this topic are about the item Creating Two Keys
Comments posted to this topic are about the item Stairway to DAX and Power...
Ask SSC