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…
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?
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…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
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…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
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)…
Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications
I have been following the SSIS tutorials from Microsoft Learn: https://video2.skills-academy.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…
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
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
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…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
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/,…
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…
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…
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…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
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…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
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…
Web service with SQL server lost connection
I have a complicated SSIS package with child packages, and it scheduled as a SQL agent ETL job. One of the steps is to call a .net application that calls a web service. The web service is hosted on a web server, then it queries the database on the…
SSIS Error "Could not create a managed connection manager." in VS2022
I just upgrade MSSQL and VS to 2022 and I have a data flow where the destination is an Always encrypted table in SQL Server. I switched the cllient provider to the Microsoft SQLClient Data provider, The connection test is successfull, the data preview…
SSIS script task SMO call fails when running from Windows 2016 Server (sql server agent) but succeeds when run from Visual Studio or Windows 2012
This SSIS package is part of the scheduled process that worked fine for years. It started failing after we upgraded OS of SSIS SQL Server (application server) from Windows Server 2012 to Windows Server 2016. Note that this SSIS package (contentious…
Run SSIS package through Server its working fine but that package I am running on my local system its not working.
I am using 2016 SSMS client on my local system [SSMS-Setup-ENU.exe] . I am using 2017 visual studio. I created a package on Visual Studio 2017 , this package is based on package deployment model, I'm running this package through powershell and call the…
Why does performance degrad when inserting into columnstore based on guidance?
With reference to this article, https://video2.skills-academy.com/en-us/sql/relational-databases/indexes/columnstore-indexes-data-loading-guidance?view=sql-server-2016, it is suggested to have bulk load sizes (no of rows) between 102,400-1,048,576. Based on…
![](https://techprofile.blob.core.windows.net/images/LaMnhm6dYUm819lrFKr8rA.png?8D834F)
Compilation Error in SSIS script Task
Dear Expert, I have gotten the script to change the data type of the excel using C#. The code is working when I use the console app in visual studio. But its not working when using SSIS script task in visual studio. Its have the compilation error. I'm…