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
"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
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 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
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 | Other
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

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
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
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
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
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
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 Explorer
Azure Data Factory
SQL Server Integration Services
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
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
Developer technologies | Visual Studio | Other
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
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
Developer technologies | Transact-SQL
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

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

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
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
