SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
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
asked 2025-07-31T11:15:48.86+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 15%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
Wolfgang
0
Reputation points
commented 2025-11-18T12:54:30.0933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 79%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDY%3C/text%3E%3C/svg%3E)
Dinesh Yadlapalli
0
Reputation points Microsoft External Staff
Moderator
2 answers
When I try to install sql server express 2019 it shows the system can not find specified path
I have tried to install SQL server express 2019 for many times, but It shows the system can not find specified path. I donwload from official site And uninstall all the previous sql server, but still shows this problem
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-11-12T18:31:12.8633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 8%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Abu Saleah
0
Reputation points
commented 2025-11-17T14:19:33.9333333+00:00
Abu Saleah
0
Reputation points
1 answer
SSIS Annotation and changing font color
We have an Annotation explaining some detail in a SSIS Package. My color theme is "Dark" and I do see some rumblings about an issue with "Dark" theme when trying to change the font color of the Annotation to yellow. It will take in…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-11-04T16:37:49+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Bobby P
231
Reputation points
commented 2025-11-17T12:32:19.5966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Anjan Kumar Chippa (Quadrant Resource LLC)
0
Reputation points Microsoft External Staff
Moderator
0 answers
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 Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-10-28T16:55:24.61+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Naomi Nosonovsky
8,881
Reputation points
commented 2025-11-17T10:36:28.74+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayana Garikapati
640
Reputation points Microsoft External Staff
Moderator
1 answer
High Memory Usage in SSISDB Related to MEMORYCLERK_SQLBUFFERPOOL
We are using SQL Server 2019. On this server, several content databases (used for reporting purposes) and an active SSISDB are running. The entire system is hosted on a single server where SQL Server 2019 is installed. Occasionally, memory usage on the…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-08-07T21:59:33.9766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 97%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOB%3C/text%3E%3C/svg%3E)
Oktay Bozdemir
41
Reputation points
commented 2025-11-13T10:38:14.65+00:00
Dinesh Yadlapalli
0
Reputation points Microsoft External Staff
Moderator
2 answers
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…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-10-31T20:27:55.9566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 52%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
Guilfoy, Kristy
20
Reputation points
answered 2025-11-12T15:08:25.9733333+00:00
Guilfoy, Kristy
20
Reputation points
0 answers
WCF EndpointNotFoundException when connecting to
System.ServiceModel.EndpointNotFoundException: Could not connect to the remote endpoint 18775299031 Server stack trace: at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout) at…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-08-28T14:42:13.1433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 2%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
shreyansh raj
0
Reputation points
commented 2025-11-12T12:16:42.7133333+00:00
Anjan Kumar Chippa (Quadrant Resource LLC)
0
Reputation points Microsoft External Staff
Moderator
1 answer
SSIS package works in Visual Studio 2022 but not from command line?
I have a snippet of a workload that involves importing data from a CSV file into a MySQL database via ODBC. When I run it within Visual Studio it works just fine but when I run it via DTexec.exe (64-bit) it fails with the following errors: Description:…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-08-13T20:37:02.52+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 74%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGT%3C/text%3E%3C/svg%3E)
Greg Troyan
0
Reputation points
answered 2025-11-12T04:44:41.3266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 44%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Shruti Dhruv
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,754 questions
asked 2025-08-13T16:53:33.8466667+00:00
shreyansh raj
0
Reputation points
commented 2025-11-11T06:00:35.09+00:00
Dinesh Yadlapalli
0
Reputation points Microsoft External Staff
Moderator
2 answers
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…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-10-30T19:23:54.81+00:00
Bobby P
231
Reputation points
commented 2025-11-10T16:16:22.1+00:00
Lakshmi Narayana Garikapati
640
Reputation points Microsoft External Staff
Moderator
2 answers
Is there any ongoing issues with SQL when trying to just change the column type via SSMS
When trying to change a column config from nvarchar(10) to nvarchar(200) the SSMS throws an timeout error when saving the change. The table is not a big one, just 40k rows. I have tried to change the Transaction time from default 30 secs to 120 secs, but…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-11-07T08:32:57.2733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 8%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Aleksi
0
Reputation points
commented 2025-11-10T13:07:03.6666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 66%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Shruti Dhruv
175
Reputation points Microsoft External Staff
Moderator
1 answer
Visithttps://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=16.0.1000.6&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026 to get help on troubleshooting.
I keep getting errors p also cant find terms. I have tried to download many times i am at my braking point
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-11-08T16:51:42.1466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 66%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Mariela Lopez
0
Reputation points
commented 2025-11-08T22:14:24.33+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 12%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Mariela Lopez
0
Reputation points
2 answers
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…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-09-13T06:17:50.0066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 38%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
ram naveen
0
Reputation points
commented 2025-11-07T09:49:46.73+00:00
Lakshmi Narayana Garikapati
640
Reputation points Microsoft External Staff
Moderator
1 answer
msodbcsql RHEL 10 support
Hello, is there a release date msodbcsql17 or msodbcsql18 with RHEL 10 support? RHEL 10 repository already exist https://packages.microsoft.com/rhel/10/prod/ but there is only azure-cli, but no msodbcsql stuff.
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-08-18T15:05:44.2733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 10%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEF%3C/text%3E%3C/svg%3E)
Erben, František
10
Reputation points
answered 2025-11-07T04:47:10.5133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 28.999999999999996%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Singam shetty Sri ganesh
80
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
How to open the old SSIS packages in VS2022
Hi, I have SSIS packages perfectly opening in VS2019, but not in VS2022. It says they are incompatible. Please let me know if any workloads or components that are needed during/after installation. I have included following workloads, but no luck: Data…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-11-06T18:14:29.3966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 71%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Challagundla, Sindhura (ITS)
25
Reputation points
accepted 2025-11-06T19:37:17.5733333+00:00
Challagundla, Sindhura (ITS)
25
Reputation points
0 answers
SSIS: Create output file with specific name and a footer
Good day, I have the following requirements - create a daily file with the filename in the pipe delimited format using name like 'PDMAutomation_yyyy_mm_dd.txt. Also this file needs to have a footer, e.g. source|request_type|change_type|Other…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-08-05T15:38:32.3233333+00:00
Naomi Nosonovsky
8,881
Reputation points
commented 2025-11-06T14:46:16.9866667+00:00
Dinesh Yadlapalli
0
Reputation points Microsoft External Staff
Moderator
1 answer
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…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-09-03T17:28:17.3266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 59%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
aditi sharma
75
Reputation points
edited a comment 2025-11-05T09:36:36.22+00:00
Shruti Dhruv
175
Reputation points Microsoft External Staff
Moderator
1 answer
Problem creating file exactly as I want it
Hi everybody, I'm trying to generate a simple text file with added footer. Here is what I managed to generate now which is not what I…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-08-05T22:15:35.87+00:00
Naomi Nosonovsky
8,881
Reputation points
commented 2025-11-05T06:13:05.6133333+00:00
Dinesh Yadlapalli
0
Reputation points Microsoft External Staff
Moderator
1 answer
One of the answers was accepted by the question author.
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…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,754 questions
asked 2025-10-30T21:32:08.5966667+00:00
Naomi Nosonovsky
8,881
Reputation points
commented 2025-11-04T04:57:46.12+00:00
Lakshmi Narayana Garikapati
640
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,754 questions
asked 2025-10-21T09:35:20.2233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 46%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Stéphane Bergeron
0
Reputation points
commented 2025-11-04T04:23:26.6466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 96%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rekha
0
Reputation points Microsoft External Staff
Moderator