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
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
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
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 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
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
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
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
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
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
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
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
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
Developer technologies | Transact-SQL
SQL Server | Other
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
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 2022 import wizard missing MS Excel option
SQL Server 2022 import wizard missing MS Excel option
SQL Server Integration Services
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
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
SQL Server Integration Services
SQL Server | Other
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
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…