SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,567 questions
8 answers
SSIS Data Flow Task error - The version of the Flat File destination is not compatible with this version of the dataflow.
I am trying to edit an SSIS package and getting the error "The version of the Flat File destination is not compatible with this version of the dataflow." when trying to run it from a SQL Agent Job or when performing a validation on the SSIS…
![](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(41.6, 46%, 14%)' 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)
![](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(272, 9%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
1 answer
Unable to Add Multiple Inputs to Script Component in SSIS
Hello SSIS experts, I'm encountering an issue with a Script Component in my SSIS project. Here's the situation: I'm trying to create a Script Component of type Transformation that accepts two input sources. However, I'm facing a problem in the Script…
asked 2024-08-14T09:48:50.32+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(304, 59%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHF%3C/text%3E%3C/svg%3E)
Hossein Farahbakhsh
0
Reputation points
answered 2024-08-15T01:51:16.1733333+00:00
ZoeHui-MSFT
36,116
Reputation points
1 answer
SSIS MSOLEDBSQL: ConnectRetryCount, ConnectRetryInterval
Using SSISDB on server A, we have a parent package that loops through a configuration table and executes several hundred stored procedures on server B. Occasionally one of the processes fails with Failed to acquire connection…
asked 2024-08-13T14:29:21.28+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(304, 65%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
John Cary
0
Reputation points
edited a comment 2024-08-14T19:14:46.11+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(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
25,851
Reputation points
1 answer
How to read excel sheet name Dynamically in SSIS .and use it in excel source.
How to read excel sheet name Dynamically in SSIS .and use it in excel source. Earlier I was using OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFilepath + ";Extended…
asked 2024-08-13T10:19:22.03+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(153.6, 60%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
LOUIS Lini (SAFRAN ENGINEERING SERVICES)
0
Reputation points
edited a comment 2024-08-14T04:07:16.5433333+00:00
LOUIS Lini (SAFRAN ENGINEERING SERVICES)
0
Reputation points
1 answer
One of the answers was accepted by the question author.
sql agent job not reading ssis record set object variable
ignore question - found better solution for issue after reviewing logical resources
asked 2024-08-09T15:16:19.84+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, 53%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
jeffrey shumaker
20
Reputation points
accepted 2024-08-09T16:37:33.8+00:00
jeffrey shumaker
20
Reputation points
2 answers
SQL Server Integration Services Projects Installation process doesn't allow to install or uninstall
Hi, I'm trying to install and use SQL Server Integration Services, but getting this message either when I try to install or uninstall the product. I'm not able to click on the checkbox, so the Install button is disable. I have tried with several versions…
asked 2024-08-06T17:49:18.45+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(169.60000000000002, 79%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
Obregon_Rigoberto
0
Reputation points
edited a comment 2024-08-09T02:19:03.41+00:00
ZoeHui-MSFT
36,116
Reputation points
5 answers
An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536
We have moved our SQL Database to SQL Server on Azure VM. I have already ran these USE SSISDB GO EXEC sp_changedbowner 'sa' Alter database SSISDB SET Trustworthy ON I am trying to deploy the package and create a folder but I still gettign…
asked 2020-10-07T10:41:41.68+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(22.400000000000002, 52%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Nicky
116
Reputation points
commented 2024-08-08T18:15:35.9866667+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(281.6, 7.000000000000001%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Jhonatan Rico
0
Reputation points
2 answers
Can not see "new" button , only reporting server can see this function.
Further to my previous question , I want to adjust a bit my question . I just found that when the user access the reporting server at local windows server ( the server running the reporting service ) , they can see the "new" button , however ,…
asked 2024-08-07T10:13:49.8666667+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(236.8, 73%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
derek chan
1
Reputation point
answered 2024-08-08T08:10:47.7533333+00:00
derek chan
1
Reputation point
4 answers
Microsoft SQL audits don't work at all, HELP!!
I am all day trying to make Audit return logs, but always returns this error: "item has already Been added. Key in dictionary: 'mndo' Key Being added: 'mndo'" I used these commands to test with a "test" user. USE Clinica_Medica SELECT…
asked 2023-03-04T06:15:53.0566667+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(220.8, 91%, 31%)' 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)
Caio Silva
5
Reputation points
commented 2024-08-07T20:54:08.9033333+00:00
Erland Sommarskog
110.4K
Reputation points MVP
2 answers
The conection failed because of an error in initializing provider.The SQLCLI11 provider is not registered on the local machine
I am not able to see any databases or names in connection manager for SQL server destination. I have given the right server but no databases are being shown and a native server client error is coming.
asked 2024-08-03T12:40:02.2+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(48, 42%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E0%3C/text%3E%3C/svg%3E)
05517918
0
Reputation points
edited an answer 2024-08-05T06:32:56.26+00:00
ZoeHui-MSFT
36,116
Reputation points
3 answers
One of the answers was accepted by the question author.
Delete Error Dumps in SQL server 2019
Hi, We have several gb of error dump files on our servers, is it safe to delete the old files from previous years ? Is it possible to change the file location to other drive for this dumps ? ?
![](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(259.20000000000005, 57.00000000000001%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
2 answers
How to check particular File exists in Folder in SSIS without using Script Task Or Script Component?
main aim to get output without using #C and VB code... Is it possible?
asked 2024-08-03T14:21:46.4733333+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(208, 71%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Ramana Kopparapu
306
Reputation points
answered 2024-08-05T03:32:01.44+00:00
ZoeHui-MSFT
36,116
Reputation points
2 answers
sql server 2022 setup encountered a failure while running job updateresult
Summary.txtDetail_LandingPage.txt
asked 2024-03-21T20:31:59.3566667+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(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBT%3C/text%3E%3C/svg%3E)
BIPIN THAPA
0
Reputation points
answered 2024-08-05T03:20:17.9633333+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(121.6, 43%, 21%)' 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)
Link Net
0
Reputation points
2 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…
asked 2024-08-02T19:30:31.07+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(214.4, 79%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES3%3C/text%3E%3C/svg%3E)
Scott-3123
21
Reputation points
answered 2024-08-04T03:32:29.17+00:00
Scott-3123
21
Reputation points
2 answers
SQL Server Agent job not copying files with SSIS package
I have an SSIS package that successfully copies files from one directory to another when run from Visual Studio. However, when I add the package to the SSIS catalog and schedule it via a SQL Server Agent job, the files do not get copied over. The job…
asked 2024-07-31T17:17:57.3233333+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(208, 5%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
jeff
20
Reputation points
answered 2024-08-01T03:20:07.6133333+00:00
ZoeHui-MSFT
36,116
Reputation points
1 answer
When following SSIS Tutorial on microsoft learn I receive a data type error
I have following the Microsoft Learn SSIS tutorial and am currently on https://learn.microsoft.com/en-us/sql/integration-services/lesson-1-6-adding-and-configuring-the-lookup-transformations?view=sql-server-ver16 , trying to follow the below step: My…
asked 2024-07-31T10:19:36.55+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, 22%, 16%)' 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)
Adam
0
Reputation points
answered 2024-08-01T03:05:10.5666667+00:00
ZoeHui-MSFT
36,116
Reputation points
1 answer
Cannot uninstall SQL Server Integration Services Projects after VS version 16.0.0 (offline) update
Hi MS, We got a Visual Studio version 16.0.0 (Offline) and SQL Server Integration Services Projects installed. I updated VS to version 16.11.0 from an offline layout. I moved on to trying to update the SQL Server Integration Services Projects version…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,059 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,567 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
212 questions
asked 2024-07-24T06:47:23.6766667+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(76.8, 1%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Mary T
0
Reputation points
commented 2024-07-31T12:52:33.95+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' %3EAX%3C/text%3E%3C/svg%3E)
Anna Xiu-MSFT
28,661
Reputation points Microsoft Vendor
2 answers
How to preserve customizations made to views in the 'catalog' schema?
In order to suppress sensitive variables from appearing in the Integration Services Catalogs' execution reports, we have made alterations to views in the 'catalog' schema of the SSIS DB. These customizations are overwritten when SQL Server patches are…
asked 2024-07-30T14:27:25.44+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(198.4, 59%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFK%3C/text%3E%3C/svg%3E)
Fitts, Keith (EOL)
0
Reputation points
answered 2024-07-31T09:29:58.41+00:00
ZoeHui-MSFT
36,116
Reputation points
1 answer
Migrating SSIS 2016 to SSIS 2022 (Oracle Attunity to Oracle Connector v1.2) LDAP
We're upgrading from SQL Server 2016 to SQL Server 2022. Our current SSIS packages utilize Oracle Attunity drivers to extract data from an external Oracle database using the LDAP protocol. We plan to switch to the Microsoft Oracle Connector v1.2…
asked 2024-07-30T02:28:18.0033333+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(176, 35%, 27%)' 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)
windows_mss
0
Reputation points
edited the question 2024-07-31T01:53:53.99+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(140.8, 78%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tianyu Sun-MSFT
30,356
Reputation points Microsoft Vendor
3 answers
Query dtexec package executions
We have a SQL Server where several packages are executed using dtexec, and I would like to retrieve the execution information and from which machines they are executed, but I can’t figure out where to find it. In the executions view, there are only the…
asked 2024-07-29T07:11:08.7466667+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(195.2, 80%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Simone Bottani
0
Reputation points
edited an answer 2024-07-30T14:04:33.3666667+00:00
Yitzhak Khabinsky
25,851
Reputation points