Microsoft Q&A

SQL Server Integration Services

2,030 questions

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,030 questions with SQL Server Integration Services tags

Sort by: Updated
2 answers

When SSIS job is set on schedule through SQL Server Agent and executed it fails.

I created a package and deployed it to Integration Services Catalogs. When I execute the package manually, it runs with no issues. However, I created a new schedule to run automatically and when it kicks off, it fails right away. I can't figure out the…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2023-05-03T14:51:21.4233333+00:00
Gostomski, Marcin 0 Reputation points
answered 2023-05-05T21:49:19.5433333+00:00
Gostomski, Marcin 0 Reputation points
0 answers

SSIS "Execute Package task" in a "for each file" loop failed when loading large number of small files

Hello I have a SSIS package including an "Execute Package Task" (ExecuteOutOfProcess = False) to be executed as many times as there are files in a specific folder. enter image description here enter image description here The sub package task…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2023-05-05T08:30:40.8033333+00:00
Cédric D 0 Reputation points
edited a comment 2023-05-05T15:55:08.1966667+00:00
Yitzhak Khabinsky 21,166 Reputation points
1 answer

How to generate excel sheets from SQL table using open xml script task

How to generate excel sheets from SQL tables using open xml in SSIS script task I want to generate it by querying the SQL query and using the open xml libray As Access database engine is not allowed to use it in our environment

C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
7,939 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,027 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2023-05-03T08:16:40.5866667+00:00
Avis kumar 1 Reputation point
commented 2023-05-05T08:52:45.2633333+00:00
Jack J Jun 23,101 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Dtexec.exe exit automatically after completed

I have a batch script which execute multiple commands. One of the command calls another batch script, which will execute SSIS package by dtexec. Once the packaged is executed and returns 0 as error code, the session will exit automatically and further…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,506 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2023-04-28T03:36:28.4466667+00:00
TC 61 Reputation points
accepted 2023-05-05T08:50:29.4433333+00:00
TC 61 Reputation points
1 answer

SSIS Package slow only on one of AG Instance

Dear All, We have 2 node availability group. We have one SSIS Package that always takes less than an hour to execute on Node1 (wheneever it is primary replica) but always takes more than 4 hours on the other node (say Node2, (wheneever it is primary…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,506 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2023-05-05T05:35:42.59+00:00
Riaz 0 Reputation points
answered 2023-05-05T08:40:44.54+00:00
ZoeHui-MSFT 21,131 Reputation points
1 answer

SSIS package succeeding but Job failing (fail - converting date and/or time)

Hi, I successfully created an SSIS package and it executed perfectly in Visual Studio's development environment. However, when I scheduled this very package within a SQL Server Job Agent, it mysteriously fails: " Hresult: 0x80040E07 Description:…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,506 questions
asked 2023-05-04T13:44:36.9733333+00:00
FareedRehman-1211 0 Reputation points
commented 2023-05-05T02:12:55.03+00:00
ZoeHui-MSFT 21,131 Reputation points
2 answers

ETL with SSIS

I've created an ETL with SSIS, that contains ODBC source as source and OLEDB destination as destination, without any transformations between them, when the package is executed, ssis replace null values by blanks, in the destination.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,506 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2023-05-04T12:31:37.03+00:00
youness hamdane 0 Reputation points
answered 2023-05-05T01:38:29.5833333+00:00
ZoeHui-MSFT 21,131 Reputation points
3 answers

Unable to install SQL Server on Windows 11

Hi Team, I am trying to install SQL Server database on Windows 11 OS machine which is having 16gb Ram/512sdd. Every time i am getting error data based engine Service failed error,

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,083 questions
Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,506 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2022-03-27T09:34:15+00:00
Vishal Sanap 6 Reputation points
commented 2023-05-04T21:07:59.6466667+00:00
Erland Sommarskog 76,096 Reputation points MVP
2 answers

unable to create forlder under SSISDB to deploy package

I have created VM on Azure where SQL server is configured to deploy the SSIS packages. I did create the Integration service catalog in SSMS. I need to deploy the packages in my local system to SQL Server(SSISDB) on azure VM. When I try to create folder…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2020-11-11T20:47:07.987+00:00
heta desai 242 Reputation points
commented 2023-05-04T11:29:55.4966667+00:00
Dom 351 Reputation points
2 answers

Error code 6398 - seen after Failed configuration run

I tried the guidance below in order to resolve this issue however when trying to follow the steps I got the error message "Add member failed for databaseRole 'db_securityadmin' (An exemption occurred while executing a Transact-SQL statement or…

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
1,721 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,506 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,406 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,463 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2023-05-02T20:42:26.7866667+00:00
Tevon 25 Reputation points
answered 2023-05-04T07:44:31.56+00:00
Yanli Jiang - MSFT 9,801 Reputation points Microsoft Vendor
4 answers

Error Fix (Database engine service failed in sql server 2022 and 2019)

Hello i am having troubles installing sql server 2022. my error is sql database engine fails to starts steps taken to install the sql on my laptop, was that i changed the account name of database engine service ( i did this because i have tried…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,506 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2022-11-23T00:01:59.227+00:00
Nelson Nwachia 1 Reputation point
commented 2023-05-04T05:48:18.84+00:00
hari krishna 0 Reputation points
2 answers

How to troubleshoot 'Failed to acquire connection "Local server connection"'?

I have a maintenance plan that I keep getting the following error. Do I need to install SSIS for this to work? In my other server, I do have SSIS installed. I have searched other places for this error but none has resolved this issue for me. Executed as…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,506 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2023-05-02T14:56:42.53+00:00
CharlieLor 471 Reputation points
commented 2023-05-04T02:32:38.3833333+00:00
ZoeHui-MSFT 21,131 Reputation points
1 answer

How to read data from Oracle OTM (as source) and insert them into MS SQL using SSIS?

I need to integrate from Oracle OTM to MS SQL using SSIS. I think there is API for that part, but first of all, is it possible and how?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,506 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2023-05-03T03:07:58.7133333+00:00
Kevin El Hajj 0 Reputation points
answered 2023-05-03T06:03:10.2033333+00:00
ZoeHui-MSFT 21,131 Reputation points
4 answers

Cannot connect to SQLServer Integration Services

SQlServer version, 13.0.5893.48 and SSMS version 15.0.18424. Is the version difference causing this error message. Do I install 17.9.1?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,506 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2023-04-26T19:17:45.24+00:00
Avyayah 1,146 Reputation points
edited a comment 2023-05-02T16:03:10.6533333+00:00
Yitzhak Khabinsky 21,166 Reputation points
1 answer One of the answers was accepted by the question author.

2016 version is missing from target server version in ssis project propeties

I am using Visual studio 2022 for creating SSIS packages. Now I want to deploy my ssis package to a sql server 2016 version. However, I am not able to select it from the list. what can i do? can someone please help me? Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2023-05-02T12:25:36.4766667+00:00
Nishan Ratna 130 Reputation points
accepted 2023-05-02T14:45:12.3533333+00:00
Nishan Ratna 130 Reputation points
1 answer

Group policy settings for database service accounts

Typically, a Group Policy will limit the permissions below to Administrator or to only specific Active Directory Groups, or possibly only to the Active Directory Administrator Accounts. When SQL Server is installed in a developer environment, this is…

Windows Group Policy
Windows Group Policy
A feature of Windows that enables policy-based administration using Active Directory.
2,089 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,506 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2022-07-22T11:19:01.273+00:00
Longstreet, James [USA] 1 Reputation point
commented 2023-05-02T07:21:24.7+00:00
Litjens, RJWG (Rob) 0 Reputation points
1 answer

how to call store procedure via SSIS package

I want to trigger a store procedure via SSIS package i have one store procedure once I run a package i want directly that procedure execution some one help me thanks in advance

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
393 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2023-05-01T13:07:13.6033333+00:00
Nandhu Nand's 21 Reputation points
commented 2023-05-02T05:50:07.61+00:00
AniyaTang-MSFT 4,391 Reputation points Microsoft Vendor
2 answers

A required privilege is not held by the client

Hello, Our SSIS jobs are getting failed since last few days with below error.. Message Executed as user: Doma\user. The process could not be created for step 1 of job 0x3F5CE43317BC4F428E24D4FA072AF5AF (reason: A required privilege is not held by the…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2023-05-01T06:03:00.9233333+00:00
Bilal H. Bhatt 1 Reputation point
commented 2023-05-01T08:28:49.8566667+00:00
Erland Sommarskog 76,096 Reputation points MVP
6 answers

SQL Server Excel Import - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

I'm trying to do a simple Excel import into a local SQL Server instance installed on my machine (to do some analysis), I'm attempting to use the wizard through SSMS. This worked a few days ago and I imported a couple of thousand tabs into tables in SQL…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,506 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2021-11-19T14:32:00.537+00:00
Alex Fletcher 11 Reputation points
commented 2023-05-01T06:21:35.88+00:00
Bipin Singh 0 Reputation points
3 answers

SSIS - The task with the name "Execute SQL TASK" not registered for use on this computer

Hello, I have problem with SSIS Execute SQL Task. I get this error message when i try to open Execute SQL Task . Can someone help me? I am using Visual Studio 2022 and SQL Server 2022. Thank you, Martin

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,030 questions
asked 2023-04-18T14:06:42.8466667+00:00
Vyvadil Martin 0 Reputation points
answered 2023-04-30T15:30:22.0266667+00:00
Fridi, Dalila 0 Reputation points