SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
1 answer
SSIS Execute SQL Task Error on Variable
I'm selecting a Number(38,0) data type field from an Oracle table and am attempting to pass the value returned from that Oracle select statement into an Int64 type variable in Visual Studio. The query I'm using is select max(<field_name>) from…
SQL Server Integration Services
asked 2025-04-29T23:21:53.8833333+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, 37%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kristie A
0
Reputation points
answered 2025-04-30T20:20:29.22+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
58,696
Reputation points
0 answers
Upgrading SQL Server from 2016 to 2022 SSIS query
Hi, I am looking to upgrade around 6 virtual machines utilizing SQL Server 2016 to 2022. One of these servers runs multiple SSIS jobs hourly and I am concerned that the upgrade will cause incompatibility for these jobs. I have been informed that these…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2025-04-30T07:37:41.6266667+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(128, 76%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jon Burrows
0
Reputation points
asked 2025-04-30T07:37:41.6266667+00:00
Jon Burrows
0
Reputation points
2 answers
One of the answers was accepted by the question author.
SSIS server 2022 connecting to SQL Server 2019 - Jobs are failing
Good day, We have many SSIS packages developed and stored in the file system. We're running them using dtexec utility like this dtexec.exe /FILE E:\SSIS_ROOT\VA\package\exec_usp_File_Extract_Setup.dtsx /SET…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2024-11-15T18:33:44.1866667+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,351
Reputation points
commented 2025-04-29T22:17:01.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(182.40000000000003, 78%, 27%)' 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)
Jovy
1
Reputation point
1 answer
One of the answers was accepted by the question author.
SSIS - 13 or more different files from the same directory
Good morning, I'm trying to figure out a best SSIS solution for the following problem. I have 13 or more input files of different structure. I already designed 13 data flow tasks for these text files and I used string variables file1, file2, etc. for…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2025-04-29T13:21:46.0233333+00:00
Naomi Nosonovsky
8,351
Reputation points
accepted 2025-04-29T21:52:47.93+00:00
Naomi Nosonovsky
8,351
Reputation points
1 answer
SSIS - Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done
Hi, I am getting this error Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done which I cannot figure out. My execute SQL Task has the following code which I can run in SSMS fine: DECLARE…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2025-04-29T18:42:22.52+00:00
Naomi Nosonovsky
8,351
Reputation points
answered 2025-04-29T20:45:40.1166667+00:00
Naomi Nosonovsky
8,351
Reputation points
0 answers
Added package from disk to a project then tried to rename it, but the original name is preserved in the project
Good day, I added a package saved on disk to an SSIS project. I then modified it and renamed. However, the original name with (1) is still shown in the project although I can see that the newly named package is saved in the project directory. But the…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2025-04-27T20:07:31.78+00:00
Naomi Nosonovsky
8,351
Reputation points
commented 2025-04-28T12:15:01.22+00:00
Naomi Nosonovsky
8,351
Reputation points
10 answers
SQL SERVER 2022 - certificate error when creating a job for integration services
In a test environment with SQL Server 2022 Developer Edition, I am trying to create a job to run an SSIS package. These same packages have been successfully tested in SQL 2019. When trying to create the job, configuring it as follows: General / Owner :…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2024-04-10T03:35:21.82+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(278.4, 98%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Marcio Matos
115
Reputation points
commented 2025-04-22T14:26:14.0633333+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, 35%, 37%)' 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)
Angela Saayman
0
Reputation points
0 answers
Executed as user: XXXX The step did not generate any output. The return value was unknown. The process exit code was -1073741819. The step failed.
Executed as user: XXXX The step did not generate any output. The return value was unknown. The process exit code was -1073741819. The step failed.
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2025-04-14T04:44:14.8833333+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, 84%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGA%3C/text%3E%3C/svg%3E)
Ganesh Asokan
0
Reputation points
commented 2025-04-21T12:11:33.0533333+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(188.79999999999998, 71%, 28%)' 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)
Brain
0
Reputation points
0 answers
Obtaining Sharepoint Online List from SSIS
Hello, Trying to connect to a online sharepoint list using odata component but always getting 401 error, but my account is authorized to access it (if use URL on browser i can see it). I know MFA is enabled, but only for out our internal network…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2025-04-21T11:55:37.9466667+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, 20%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Ricardo Baptista
0
Reputation points
asked 2025-04-21T11:55:37.9466667+00:00
Ricardo Baptista
0
Reputation points
1 answer
"HCRP403 Error when registering second on prem SQL server in ARC
I have a test on prem SQL server already ARC enabled and is configured as a PE with a link scope and there is also a Virtual network Gateway in the mix. When attempting to register a second SQL server in ARC and a PE with the already existing link…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2025-04-14T21:15:05.1133333+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, 85%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
Chris Pair
0
Reputation points
commented 2025-04-18T12:29:28.57+00:00
Chris Pair
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Migrating VS2019 SSIS Pkg to SQL Server 2022 - Error Encountered
I am trying to migrate an SSIS PKG that was developed using VS2019 for SQL Server 2019 on Windows Server 2019. Now we have this new test server with the following components installed: Windows Server 2022 Datacenter SQL Server 2022 Enterprise VS…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
![](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, 52%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
SQL Express Server 2019 upgrade to Standard Server 2019, using Standard Server 2022 and Downgrade Rights
Currently I have installed SQL Server Express 2019, and looking to upgrade this to Server Standard 2019 using the installation center which requires a product key. As you can no longer purchase SQL Server Standard 2019, I have purchased SQL Server…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
![](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, 99%, 24%)' 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)
1 answer
SSIS Package Fails in Validation (Excel Destination)
Hi, I have been frustratingly trying to deal with a very odd problem. I created a package to handle the filling of an Excel file from a SQL query. I spent a couple days debugging, making sure it worked through manual execution, then I managed to get it…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2021-10-01T16:02:52.623+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(201.6, 76%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Alex (CSharper)
1
Reputation point
commented 2025-04-16T22:16:16.1833333+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, 82%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKR%3C/text%3E%3C/svg%3E)
Kumar Rnd
0
Reputation points
0 answers
How to use XML datatype with OleDB (deprecation of sqlclient)
Migrating packages from SQL2017 to SQL2022. One package contains a script which creates its own connection. It uses SqlConnection and associated objects. Moving over to use OleDbConnection. The following line is causing problems. //SqlParameter…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2025-04-15T14:25:43.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(156.8, 75%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Stephen Hulbert
0
Reputation points
commented 2025-04-16T02:36:30.72+00:00
Viorel
121.4K
Reputation points
1 answer
SSIS Package Error: The attempt to add a row to the Data Flow tank buffer failed with error code 0x8007000E
Hi, Wet are migrating SSIS Packages from SQL 2008 to SQL 2016 and getting below errors when running SSIS 2016 package through command line (or) scheduling tool . Same package executed successfully if running through SQL Agent. Error No 1: The attempt…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2025-03-21T01:59:02.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(28.799999999999997, 19%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Prakash
0
Reputation points
answered 2025-04-15T14:17:18.29+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, 83%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Kuruba Gowthami (US)
0
Reputation points
0 answers
Unable to connect to azure hosted sql server using service principal
I am trying to run a script on a server to download some csv files from a website then import them to an azure sql server. I set up a registered app, gave it graph permissions for directory.read.all, user.read, and user.read all. Then I created a secret…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
![](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, 7.000000000000001%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
3 answers
One of the answers was accepted by the question author.
A script task is not functioning as expected at runtime when I use targetserverversion2019 on SSIS 2019
On my local machine, the package runs fine with any targetserverversion, but when I load it into SQL Server Management Studio the script task doesn't work as expected at runtime environment. SQL job/package run successfully, However, the "Script…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2021-01-07T03:01:26.647+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(300.8, 52%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Chapagain, Dilli R
96
Reputation points
commented 2025-04-11T19:02:48.71+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, 28.999999999999996%, 16%)' 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)
mh
0
Reputation points
0 answers
Error connecting to MySQL server: 'Lost connection to MySQL server at reading initial communication packet'
Encountering the following error when attempting to connect to a MySQL server: mysql.connector.errors.OperationalError: 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 This error occurs…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2025-04-11T07:06:35.94+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, 44%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
jWare Automation
0
Reputation points
asked 2025-04-11T07:06:35.94+00:00
jWare Automation
0
Reputation points
0 answers
Type Cast Error
I am trying to write a derived column expression to check for year. We get a data file for employees for previous month in the current month and I am trying to tackle the year so when I get the file in January the year should be 2024 since I will get the…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
1 answer
One of the answers was accepted by the question author.
I would like to know if connector is available for SAP BPC?
Hi Experts, I am working on solution development to ingest data from different SAP systems to ADLS Gen 2. I have selected ADF for the integration and could see ADF connectors available for SAP BW, HANA, C2C etc. However, I don't find any information…
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,554 questions
Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
561 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,464 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
asked 2023-12-18T13:44:07.4133333+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, 59%, 37%)' 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)
Sivaramakrishnan S
20
Reputation points
commented 2025-04-09T08:08:05.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(6.4, 70%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Gowtham Selvaraj
0
Reputation points