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 DTUTIL utility.
This script is the batch file I used to load the multiple packages on an SSIS server. You need to execute this Batch file on the server where SSIS services are installed.
cd C:Package_loacation FOR IN (*.dtsx) DO DTUTIL /FILE C:Package_loacation /COPY SQL;Folder_location_SSIS_serverni /QUIET
In this article, I am going to explain fixing a problem related login failure error with SQL Server. The Problem One of the common error in the SQL Server error log is "Login failed for user 'DomainName\ServerName$'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]". Even though it says that […]
2020-11-24
40,149 reads
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
6,145 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
9,711 reads
Learn how to correctly fix your SSISDB without using Trustworthy.
2020-01-28
14,930 reads
Learn how you can modify an SSIS package to dynamically process SSAS cubes.
2020-01-13
9,819 reads
