2,762 questions with SQL Server Integration Services tags

Sort by: Updated
2 answers

Choosing Between SQL Server/SSIS 2022 and 2026 — Which Version Is More Stable for Enterprise Use?

Hello, We are a DWH team running our ETL processes using SSIS packages. Our ETL packages are executed on SQL Server via SQL Server Agent jobs, and all ETL development is done in Visual Studio. Our current environment consists of: Windows Server 2019 …

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2025-12-23T21:31:26.1866667+00:00
Oktay Bozdemir 41 Reputation points
answered 2025-12-23T22:26:30.6966667+00:00
Erland Sommarskog 129.7K Reputation points MVP Volunteer Moderator
1 answer

ADO.NET ignores parameter names when IsQueryStoreProcedure is set to True

ADO.NET ignores parameter names when IsQueryStoreProcedure is set to True. I use the "Execute SQL Task" to call a stored procedure with optional parameters via ADO.NET . The following situation occurs with all providers except…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2025-09-22T13:08:39.9766667+00:00
Gregory Lvov 0 Reputation points
recommended 2025-12-23T18:33:50.9333333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

The SQL Server Management studio no longer shows running SSIS packages

Hi everyone, I run a bunch of SSIS packages in a SQL Server Agent job. The packages are deployed as files in the file system. They are executed as SQL Server Agent Service Account. I used to be able to see them under Running Packages. Today, they weren't…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2025-12-19T21:51:23.88+00:00
Igor Gelin 0 Reputation points
commented 2025-12-23T15:23:14.46+00:00
Igor Gelin 0 Reputation points
2 answers One of the answers was accepted by the question author.

Data Importing from Tally ERP Prime

Hi, I have my data secured in Tally Prime and I wish to integrate that data in MSSQL Server Management on daily basis. How am I supposed to do this?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2025-12-23T04:01:54+00:00
Sunil Bahadur 20 Reputation points
answered 2025-12-23T06:30:24.3266667+00:00
Sunil Bahadur 20 Reputation points
1 answer

SQL 2022 SSIS with ACE 12 32bit error unexpected Termination

Hi We had a set of SSIS package on SQL 2016 writing the output to Excel with different tabs. In the old server we have ACE 2010 version 14 32bit. We had to upgrade our servers to Windows 2022 SQL 2022 we installed ACE 16 32bit but when running the SSIS…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2025-09-14T08:49:48.7566667+00:00
Katayoun Sarab 0 Reputation points
commented 2025-12-22T08:30:45.1966667+00:00
Lakshmi Narayana Garikapati 740 Reputation points Microsoft External Staff Moderator
3 answers

how to modify a DTSX file ?

Good morning, Weeks ago, i created a DTSX file to import data from a flat text file into a SQL table. I'm realizing that i stupidly forgot to check the "empty table before import" box. Is there a way to modify that parameter without…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2025-10-21T09:35:20.2233333+00:00
Stéphane Bergeron 0 Reputation points
commented 2025-12-17T07:19:07.0566667+00:00
Lakshmi Narayana Garikapati 740 Reputation points Microsoft External Staff Moderator
2 answers

SSIS Wizard new mapping file not found

Hi I am attempting to migrate a Sybase ASA database to SQL Server using the 'SQL Import and Export Wizard' within Visual Studio 2019. I am able to run the wizard and create a package but the datatype mappings are not correct, e.g. datetime is mapped…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2022-02-14T20:11:32.557+00:00
Marshall, Richard J 6 Reputation points
edited an answer 2025-12-15T04:50:38.0333333+00:00
Shamsuddin Dzhamalov 0 Reputation points
3 answers

SSIS won't install for VS 2022

SSIS won't install for Visual Studio 2022 Enterprise. I keep getting an error message that the help says means it found another installer running. I completely uninstall VS, rebooted, installed enterprise edition, rebooted, and then brought up task…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2024-08-02T19:30:31.07+00:00
Scott-3123 21 Reputation points
edited a comment 2025-12-12T19:29:51.36+00:00
Jairo 0 Reputation points
1 answer

Error execute a SSIS Packed with SQL Agent

Hello, we have a very strange problem when executing an SSIS package with the SQL Agent. The package has the following tasks for an Excel file: 1. Check file in the source path. 2. Copy file to the destination path. 3. Open file in the destination…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2025-07-31T11:15:48.86+00:00
Wolfgang 0 Reputation points
commented 2025-12-12T08:19:56.43+00:00
Dinesh Yadlapalli 0 Reputation points Microsoft External Staff Moderator
5 answers

SSIS Package Execution Error - The requested OLE DB provider Microsoft.ACE.OLEDB.16.0 is not registered

Hello Community, I have been getting this error message every time I run my saved SSIS package. And even though I have looked up this error message across the web, the solutions have not seemed to work. To provide the background information with the…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2025-06-24T18:20:55.04+00:00
Ryan 16 Reputation points
commented 2025-12-12T08:16:07.9+00:00
Dinesh Yadlapalli 0 Reputation points Microsoft External Staff Moderator
1 answer

Upgraded VS to version 16.11.49 but now my original SSIS package is not appearing

Hi I updated VS to version 16.11.49 but now my original SSIS package is not available. I can create new SSIS package but I cannot access my original one. Below are some screenshots: Message I get when I open my original SSIS package: SSIS is…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2025-07-17T04:03:25.14+00:00
Manny 151 Reputation points
commented 2025-12-12T07:37:11.19+00:00
Dinesh Yadlapalli 0 Reputation points Microsoft External Staff Moderator
2 answers

Microsoft SQL Server 2025 availability on CSP

When will Microsoft SQL Server 2025 be available on CSP and does it come with PBIRS Functionalities and Software Assurance

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2025-12-09T16:01:41.5366667+00:00
Nurudeen Adeboye 21 Reputation points
answered 2025-12-09T22:07:44.38+00:00
Erland Sommarskog 129.7K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

Convert Julian dates in Normal date

How to convert Julian date column in normal date like colum contains 12490,12492 Julian dates

Azure SQL Database
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
Developer technologies | Transact-SQL
Developer technologies | Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,713 questions
SQL Server | Other
asked 2024-09-19T18:36:21.3566667+00:00
Vineet S 1,390 Reputation points
answered 2025-12-08T10:17:23.4333333+00:00
Julian Schulz 0 Reputation points
1 answer

how to fix issue om.microsoft.sqlserver.jdbc.TDSChannel enableSSL WARNING: TDSChannel ( ConnectionID:1 TransactionID:0x0000000000000000) SSL handshake failed: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)

Previously, I used JDK 1.6.0, but due to company requirements, I had to switch to OpenJDK 8u422 in Eclipse. After making the change, I received warnings, and some functions also showed warnings when running. There are a few functions that do not display…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2025-06-24T01:07:50.8+00:00
Toan Nguyenngoc 0 Reputation points
commented 2025-12-08T04:49:48.14+00:00
Thumu Sai Pranay 75 Reputation points Microsoft External Staff Moderator
2 answers

How do I condition a task based on a parameter

I have an SSIS package that has a boolean parameter called IsProd. I want the first task in the package to only run if IsProd is true. How do I set this for the first task? How would I do this if the package only has one task and I cannot set from and…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2025-07-18T21:21:56.5733333+00:00
Martin Williams 0 Reputation points
commented 2025-12-02T10:30:58.3066667+00:00
Nithin Krishna Madadi 0 Reputation points Microsoft External Staff Moderator
1 answer

SQL Server 2022 import wizard missing MS Excel option

SQL Server 2022 import wizard missing MS Excel option

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2025-11-21T13:01:40.7333333+00:00
Shahidullah All Mahmod 0 Reputation points
commented 2025-12-01T12:57:47.2166667+00:00
Lakshmi Narayana Garikapati 740 Reputation points Microsoft External Staff Moderator
1 answer

Inquiry Regarding Migration from SQL Server 2019 to SQL Server 2022 and SSIS 2012 Migration Path

Dear Microsoft Support Team, I hope you are doing well. Our team is currently running SQL Server 2019 and using SSIS packages developed in SQL Server Integration Services (SSIS) 2012. We are planning to migrate our environment to SQL Server 2022, and we…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2025-11-28T09:12:30.29+00:00
TIPPAWAN SOMSEE 0 Reputation points
edited the question 2025-11-28T13:56:44.2+00:00
Erland Sommarskog 129.7K Reputation points MVP Volunteer Moderator
4 answers One of the answers was accepted by the question author.

SSIS Error when deploying package, the locale identifier LCID is not supported by SQL Server

Hi I am unable to deploy my project from Visual Studio to SSISDB. I have tried to change my localename and locale as well as my region. I have also made MYSQL Server login local but the below error still persists. Can anyone provide guidance TITLE: SQL…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
1,143 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
SQL Server | Other
asked 2021-05-03T11:51:51.583+00:00
Lynn Carelse 21 Reputation points
commented 2025-11-28T06:43:17.03+00:00
Muhammad Erik Rahman Mulyana 0 Reputation points
0 answers

Unexpected API Response Error 16464 — Need Clarification

System.InvalidOperationException: Operation failed with error code <error_code_164640> at MyApp.Controllers.PaymentController.ProcessRequest() in /src/Controllers/PaymentController.cs:line 668 at MyApp.Program.Main(String[] args) in…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2025-08-13T16:53:33.8466667+00:00
shreyansh raj 0 Reputation points
commented 2025-11-27T09:19:43.4333333+00:00
Dinesh Yadlapalli 0 Reputation points Microsoft External Staff Moderator
1 answer

Getting error in SSIS package, using attunity connector

Hello, I'm trying to get help on a issue I'm trying to deal with. Got a new wokstations here, with fresh installed VS, SSIS, MS Oracle connector, etc. I get to work on SSIS Packages, that intend to extract data from Oracle DBs, using an old attunity…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,762 questions
asked 2025-07-17T13:26:19.4+00:00
Mathieu Mussler 0 Reputation points
commented 2025-11-27T06:42:59.0166667+00:00
Venkata Ramanamma Uppu (Quadrant Technologies LLC) 0 Reputation points Microsoft External Staff