SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
2 answers
One of the answers was accepted by the question author.
Sql server agent job fail
The error message is An idle CPU condition has not been defined
![](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(86.4, 96%, 18%)' 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)
1 answer
How to loop through multiple Sql Server instance, database, and table/view names?
It's been a long time since I write any C# code. I'm trying to query some tables and views from different SQL Server instance, database names, and tables/views. Below is my sample code. public void Main() { // TODO: Add your code here …
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,307 questions
asked 2024-03-28T14:57:55.1266667+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(275.2, 3%, 36%)' 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)
CharlieLor
551
Reputation points
commented 2024-03-28T18:48:41.6433333+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(256, 32%, 34%)' 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)
Michael Taylor
48,826
Reputation points
1 answer
SSIS Send Mail Task Fails on Out of office
I have a simple Send Mail Task that sends an email to a list of dynamic users. If one of those users has "out of office" set, the SSIS flow fails. The next day, when it sends again, it works, because "out of office" doesnt respond…
asked 2024-03-25T13:11:29.8966667+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(57.599999999999994, 30%, 15%)' 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)
Mark Lewin
0
Reputation points
commented 2024-03-28T13:35:58.5233333+00:00
Mark Lewin
0
Reputation points
1 answer
Unexpected termination - SSIS 2019 export to excel files
I have a SSIS 2019 project, which contains a main package and a few child packages that may export data to excel files (using Excel 2007-2010). The main package calls the child packages based on criteria. The excel files are dynamically generated though…
asked 2023-04-25T20:22:35.09+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(89.60000000000001, 55.00000000000001%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ2%3C/text%3E%3C/svg%3E)
JulieYing-2010
10
Reputation points
commented 2024-03-27T01:47:04.5966667+00:00
ZoeHui-MSFT
33,296
Reputation points
2 answers
SSIS Error: ADO NET Source has failed to acquire the connection with the following error message: "Could not create a managed connection
Hello I am getting this error when trying to connect Dynamics CDS. [ADO NET Source [2]] Error: ADO NET Source has failed to acquire the connection {6F23C652-54D5-487B-AF3D-3354FD263841} with the following error message: "Could not create a managed…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,643 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
asked 2023-08-22T23:43: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(80, 11%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKN%3C/text%3E%3C/svg%3E)
Khan, Nasif
0
Reputation points
commented 2024-03-26T19:39:59.12+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(9.6, 59%, 10%)' 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)
Joanna Shen
0
Reputation points
3 answers
has inline function got any catch?
hi, I heard many people saying "functions are denounced in tsql" is there any catch? q1) need to know what are the cases where we should not use? q2) should we avoid scaler functions also? q3) should we avoid scaler functions if we have to…
asked 2024-03-11T05:57:35.8533333+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(41.6, 42%, 14%)' 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)
Rajesh Kumar Yadav
0
Reputation points
answered 2024-03-26T17:11:52.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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
56,931
Reputation points
1 answer
One of the answers was accepted by the question author.
Is it possible to move SSISDB to another
I have two machine both installed SQL SERVER2019, I want to move the SSISDB from A machine to another. Is it possible? How can i do that?
asked 2024-03-26T05:47:16.8433333+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(211.20000000000002, 2%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ4%3C/text%3E%3C/svg%3E)
Jonny-4280
80
Reputation points
accepted 2024-03-26T08:05:35.27+00:00
Jonny-4280
80
Reputation points
1 answer
Unable to add custom component in ssis toolbox
I am trying to add a custom component to ssis toolbox with help of C# class library file. I built the C# file after signing it with strong key. Then, I copied the generated .dll file onto the path ->C:\Program Files (x86)\Microsoft SQL…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,307 questions
asked 2024-03-25T12:18:42.2166667+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(294.40000000000003, 99%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
Deepak Lavate
0
Reputation points
answered 2024-03-26T01:45:36.71+00:00
ZoeHui-MSFT
33,296
Reputation points
1 answer
In SSIS (version 15, created through Visual Studio 2017), I am trying to connect to a Sharepoint list ("Deficiencies") with an HTTPS URL. I get this error:
I am trying to get the sharepoint list using oData Source service using Basic Authentication. The connection test okay and i can preview the data. Connection String https://XXXXXXXXXXXXXXXX/_vti_bin/listdata.svc/ But when i run the package, it will error…
asked 2024-03-23T21:24:40.6533333+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(6.4, 86%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERO%3C/text%3E%3C/svg%3E)
Richard O'Carroll
0
Reputation points
answered 2024-03-25T02:14:29.9633333+00:00
ZoeHui-MSFT
33,296
Reputation points
4 answers
SSIS - ODBC Destination Error with MySQL
I'm getting the following error when trying to configure my ODBC Destination for a MySQL table. Exception from HRESULT: 0xC0014020 Error at DFT - Insert into MySQL [ODBC Destination [476]]: SQLSTATE: 42S22, Message: [MySQL][ODBC 8.0(a)…
asked 2022-07-27T12:37:47.357+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, 70%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Drew Baumgartner
1
Reputation point
commented 2024-03-24T10:12:30.06+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(73.60000000000001, 86%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDV%3C/text%3E%3C/svg%3E)
Dimitris Vayenas
21
Reputation points
1 answer
Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications
I have been following the SSIS tutorials from Microsoft Learn: https://learn.microsoft.com/en-us/sql/integration-services/lesson-6-4-deploying-the-lesson-6-package?view=sql-server-ver16 I am currently stuck at step 8 of "Add the package to the…
asked 2024-03-09T15:50:00.2433333+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(57.599999999999994, 13%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Norman K. F. Chow
75
Reputation points
commented 2024-03-24T05:17:04.08+00:00
Norman K. F. Chow
75
Reputation points
2 answers
Struggling with SSIS lookup date key transformation
How do i fix the below error, i have confirmed a million times that the data type is the same. The date formats are different though. Could that be the problem
asked 2024-03-21T12:09:24.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(86.4, 64%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Susan Gatura
0
Reputation points
answered 2024-03-22T01:31:06.7566667+00:00
ZoeHui-MSFT
33,296
Reputation points
2 answers
Visual studio 2022 crash when i create SSIS package
I installed VS 2022.. and create SSIS package for project. When i create the package VS 2022 unexpectedly close several times . why this happen the error is "A previous session ended unexpectedly. Disabling the extension SQL Server Integration…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,643 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
asked 2024-03-14T05:42:23.9166667+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(240, 33%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Bakhtawar
1
Reputation point
commented 2024-03-21T13:25:14.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(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
25,891
Reputation points Microsoft Vendor
1 answer
Automate delta changes, IUD, between 2 database and push the changes to a 3rd database
We currently are using a manual, GUI, process with Redgate to generate the insert, update, and deletes statements that occurred between two databases, the same full database backup at midnight, day to day. These changes are pushed to a 3rd database used…
asked 2024-03-19T16:20:09.08+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, 75%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Philips, Garry, PED
0
Reputation points
answered 2024-03-21T02:04:29.97+00:00
ZoeHui-MSFT
33,296
Reputation points
1 answer
Connect to ADLS Gen 2 from SSIS 2019
Hello I'm trying to import files from ADLS Gen 2 container using SSIS 2019 Azure feature pack. Azure storage connection manager succeeds but when I use the Azure Blob Download Task I get the following error. https://myblob.blob.core.windows.net/,…
asked 2023-12-21T00:32:57.1633333+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, 20%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Raj D
581
Reputation points
commented 2024-03-20T17:06:22.2133333+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, 99%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Aravind Raam
0
Reputation points
3 answers
intermittent DB connection issue with SSIS Package
Dear Experts, We have an intermittent Database connectivity issue with the Data flow task in our SSIS Package. Sometime Job is working as expected but some other time it is getting failed to get the Database connection. Delay validation property is…
asked 2022-10-31T05:38:44.377+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, 73%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
sajesh k
1
Reputation point
commented 2024-03-20T09:54:26.5766667+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, 93%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Amit Verma
0
Reputation points
0 answers
SSIS Oracle destination insert commit size.
Hi, Which property in Oracle destination gives the same result as OLEDB Maximum Insert commit size functionality. right now, Script component is concatenating multiple rows together instead of one row per batch. Simply I want script component output…
![](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(115.19999999999999, 56.00000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZR%3C/text%3E%3C/svg%3E)
2 answers
How to uninstall sql and its packages?
I tried to use SQL Server Integration Services, but it wasn't working at all, I was running on administrator and I checked it was installed. So I tried to uninstall everything to reinstall and it keeps saying "setup failed". It starts to…
asked 2024-03-17T12:57:34.0733333+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(233.6, 99%, 32%)' 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)
Office
0
Reputation points
answered 2024-03-19T02:27:05.0866667+00:00
ZoeHui-MSFT
33,296
Reputation points
4 answers
Microsoft.ace.oledb.12.0 provider is not registered for VS 2022 and run64bitRuntime disabled
I recently upgraded my sql server from 2019 to 2022. And also start to use Visual studio 2022. Because there is some excel destination or source file in the SSIS package, I got some errors like Microsoft.ace.oledb.12.0 provider is not registered. I see…
asked 2024-03-15T21:53:36.26+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(147.20000000000002, 18%, 24%)' 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)
Anne
276
Reputation points
answered 2024-03-19T02:01:31.4533333+00:00
ZoeHui-MSFT
33,296
Reputation points
2 answers
Connection failover doesn't work with the MicrosoftSSISOracleConnector using tnsnames file and the first service is unaccessible
Hello, I have installed MicrosoftSSISOracleConnector-SQL22 v1.2 (64-bit) on Microsoft SQL Server 2022. Everything was working fine until I used failover=on in the tnsnames.ora and the first service in the list was unaccessible. It can be tested by…
asked 2024-02-14T22:14:56.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(265.6, 43%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Dragana Popovic
5
Reputation points
answered 2024-03-18T14:04:02.36+00:00
Dragana Popovic
5
Reputation points