2,705 questions with SQL Server Integration Services tags

Sort by: Updated
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,705 questions
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,705 questions
asked 2025-04-14T21:15:05.1133333+00:00
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,705 questions
asked 2025-04-11T15:22:59.3+00:00
sidney l 21 Reputation points
accepted 2025-04-18T00:39:44.1566667+00:00
sidney l 21 Reputation points
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,705 questions
asked 2025-04-15T15:59:44.84+00:00
Ollie 20 Reputation points
accepted 2025-04-17T09:28:03.26+00:00
Ollie 20 Reputation points
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 Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
SQL Server | Other
asked 2021-10-01T16:02:52.623+00:00
Alex (CSharper) 1 Reputation point
commented 2025-04-16T22:16:16.1833333+00:00
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,705 questions
asked 2025-04-15T14:25:43.9566667+00:00
Stephen Hulbert 0 Reputation points
commented 2025-04-16T02:36:30.72+00:00
Viorel 122.9K 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,705 questions
asked 2025-03-21T01:59:02.95+00:00
Prakash 0 Reputation points
answered 2025-04-15T14:17:18.29+00:00
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,705 questions
asked 2025-04-14T17:24:49.5033333+00:00
John Vac 0 Reputation points
commented 2025-04-14T17:25:32.67+00:00
John Vac 0 Reputation points
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,705 questions
asked 2021-01-07T03:01:26.647+00:00
Chapagain, Dilli R 96 Reputation points
commented 2025-04-11T19:02:48.71+00:00
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,705 questions
asked 2025-04-11T07:06:35.94+00:00
jWare Automation 5 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,705 questions
asked 2025-04-08T22:07:29.25+00:00
Ali Ahad 131 Reputation points
commented 2025-04-09T13:50:59.81+00:00
Ali Ahad 131 Reputation points
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,563 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.
579 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,670 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2023-12-18T13:44:07.4133333+00:00
Sivaramakrishnan S 20 Reputation points
commented 2025-04-09T08:08:05.3266667+00:00
Gowtham Selvaraj 0 Reputation points
0 answers

Issues Importing Excel Data into SQL Server after Update

After a recent update, assistance is needed with importing data from Excel into SQL Server Management Studio (SSMS) in a core process. Weekly, data is imported into a SQL database after running an application that generates the data, and there are also…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2025-04-07T14:08:03.93+00:00
Xephyr Enderborn 0 Reputation points
edited the question 2025-04-07T14:18:21.0166667+00:00
Xephyr Enderborn 0 Reputation points
4 answers

VS 19, SSIS project, getting and error "The specified provider is not supported. Please choose different provider in connection manager" when choosing OLEDB as the connection type

Using Visual Studio 19 on new laptop. Have installed the SSIS template. I also have SSMS 19 installed. I create a new project and try and create a new Connection Manager. I select OLEDB and click Add... On the next screen to configure the OLE DB I select…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
Developer technologies | Visual Studio | Other
asked 2023-04-26T00:34:01.27+00:00
Seeley, Steve 15 Reputation points
commented 2025-03-30T16:23:04.1466667+00:00
Anisha Poudel 0 Reputation points
2 answers One of the answers was accepted by the question author.

Is OLE DB Driver for SQL free?

Hello, a client of my company would like to know if this driver is free to download and use. Is there any specific place where it says it's free to download and use? Thank you for your time.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2025-03-19T14:24:01.5833333+00:00
Ajoy Moreno, Juan 20 Reputation points
accepted 2025-03-27T17:35:39.6633333+00:00
Ajoy Moreno, Juan 20 Reputation points
4 answers

Bulk Insert from csv having issues with double quotes

Hi Team, I am using Bulk Insert to load the data from CSV into SQL Table. I have used , (comma) as a field terminator and it was working fine. But in my csv file I have the Project Manager field which has in the format as (Lastname,…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
Developer technologies | Transact-SQL
asked 2021-01-20T07:55:09.193+00:00
Sarath 106 Reputation points
answered 2025-03-26T22:35:31.5566667+00:00
JonBr 1 Reputation point
9 answers

Custom ConnectionManager always returns null at runtime

I have written a very simple custom connection manager inheriting from ConnectionManagerBase. My acquireconnections and release works as it should in design time on my source component. The issue is when I try and execute it in Visual Studio. I associate…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2021-03-13T06:35:27.367+00:00
ManicFarmer 16 Reputation points
answered 2025-03-26T18:29:21.9+00:00
Tyler Sand 0 Reputation points
1 answer

Cannot install SQL Server Integration Project in SQL Server 2019

Running Windows 11 Enterprise, version 23H2, OS Build: 22631.4890. Running new installation of "Visual Studio Professional 2019" v16.11.45 SQL Server Integration Services Projects extension - Setup Failed. "Fatal error during installation…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2025-03-13T22:42:03.2633333+00:00
MarkDAgosta-2552 0 Reputation points
answered 2025-03-14T01:24:20.1366667+00:00
ZoeHui-MSFT 41,496 Reputation points
2 answers

Unable to update connection credentials. Logging into Sql server failed. Possible reasons for this error include an invalid authentication mode, a missing login in Sql server, a login from an untrusted domain or a problem contacting the domain controller

facing issue with connecting sql server to power bi service, in desktop this is working properly and also able to refresh but in service getting error.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2025-03-11T04:29:49.5633333+00:00
Nirmala Jawalkar 0 Reputation points
answered 2025-03-13T20:26:23.4+00:00
Irfan Mohammed 0 Reputation points
1 answer One of the answers was accepted by the question author.

SSIS XML write file task - how to preserve empty values?

Hi, We have SSIS package that writes XMLs into files. We have stored procedure that generates XML and outputs it as XML with tags like this <MiddleName> </MiddleName>. In other words, there is a space (intentional) inside the tags. We have…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
asked 2025-03-10T21:32:16.3566667+00:00
Naomi Nosonovsky 8,431 Reputation points
edited a comment 2025-03-11T21:30:32.6333333+00:00
Viorel 122.9K Reputation points