SQL Server Integration Services

How to fix SQL Server 2022 installation error

SQL Server 2022, Visual Studio 2022 - Microsoft VB 2022 script task interacting with Excel COM Errors

We have some SSIS packages that interact with Excel files. The SSIS packages output the data to the excel spreadsheets that include a template row so that numbers are formatted as numbers.. etc. There are also pivot tables that exist on other tabs of…

How to connect to Mysql

How can i connect to Mysql database in SSIS package？

ETL Framework In Production

Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through the Execute Process Task. I am extracting Data from E2 SQL to Azure SQL Server. The connection has already been established. I am building complete…

SQL Server Integration Package Failing with Error Code 18883190814 During Execution

System.Data.SqlClient.SqlException: Execution failed with error code <error_code_18883190814> at Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.Execute() at Microsoft.SqlServer.Dts.Runtime.TaskHost.Execute(Int32& result) at…

Problem with SSIS package

Hi everybody, Looks like I ask a lot of questions lately :) I have a SSIS package that shows the following metadata: The package looks like this: The output file is configured like this in Advanced Editor: However, in preview mode it shows: As you…

Excel Connection Manager not working on a 64-bit Client

For the life of me I cannot get an Excel Connection Manager to work in SSIS. Could not retrieve the table information for the connection manager 'Excel Connection Manager'. Failed to connect to the source using the connection manager 'Excel Connection…

SSIS Variable Naming Convention/Standard

I know this is a very loose ended question/request...But just wondering what some of you use as Variable Naming Conventions/Standards when creating and using your SSIS Variables. Just looking for some ideas of what some people and shops use for their…

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…

Reading data from ERP E2 and Push to Azure SQL.

Hello, May someone please help me how can I pull data from ERP named as E2. E2 is using SQL Server. Looking for detailed steps of connecting to E2 System. I am planning to use python scripting as it is open source. Do I need to Install any driver. what…

Local is 4.8 QA Is 4.5 Prod is 4.8 developing on local. But still on prod not works and gting error. Like cannot upgrade script component. Please help me. Tried with many options and tired. QA is Working and and same package deployed on prod fails

Local .NET is 4.8, QA Is 4.5, Prod is 4.8. changed 2 columns lengths in SSIS and not any major changes. developed on local But still on prod not works and giving error Like cannot upgrade script component. Please help me. Tried with many options and…

Connection string

Hello, I have a connection string which works on the old production server but doesn't work on the new production server. <?xml version="1.0"?> <DTSConfiguration> <DTSConfigurationHeading> <DTSConfigurationFileInfo …

SQL Server Import and Export Wizard: Can not go back after error

Hi. After finishing an import using the SQL Import and Export Wizard, and if there's an error, I can't find a way to go back and fix it, even though the wizard indicates at the top that this should be possible: It's very annoying to have to start from…

Does sqlcmd have block insertion?

First of all, Hello everyone! The problem is i started using sql server on other operative system than windows. I have followed almost all of the article in the documentation. Installed docker Installed sql cmd Installed the image Ran the commands…

Unexpected API Response Error 16464 — Need Clarification

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

how can I strip unprintable ascii characters from a flat file transformation in ssis

I am loading a flat file to another flat file with headers. the source file has rows with unprintable ascii characters. I need to strip those out. it is giving truncation errors as the characters are making it think the field is too long. what is the…

How to download SQL server 2022 license

Our legal team needs to update the SQL Server 2022 license, which is currently missing from the official product. Please refer to the attached screenshot for reference. Could you please guide me on how to download the SQL Server 2022 license? Kindly…

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…

Visual Studio 2015 / SSIS / Excel Connection Manager Issue (The requested OLE DB provider Microsoft.ACE.OLEDB.15.0 is not registered).

Hi all I have a scenario where I'm having to revisit an old SSIS Package that was developed some 4/5 years ago and I'm having a particular challenge dealing with an error / issue when trying to run the package from Visual Studio (2015). Essentially, I'm…

Big file with lots of columns doesn't output content of many of them

Good day. I have a SSIS package that selects the data using the following statement: EXECUTE im_automation.accent_changes WITH RESULT SETS ( ( [Source] VARCHAR(30), Category VARCHAR(30), ProvType VARCHAR(30), [Social…