Content
case condition
Hi Expert, the below is the condition case when oid= 'Winter' then Name else 'noname' create table table1(id varchar(30), name varchar(30), oid varchar(30)) insert into table1 values('1', 'David', 'Winter') insert into table1 values('2', 'Hash',…
Postgresql to MS SQL Server
hi, Using SSIS, I need to download data from snowmirror PostgreSQL to sql server. Could anyone tell me what steps I need to take.
DQS Cleansing transform in SSIS want to parameterize KB name
For the DQS Cleansing transform in SSIS, there is nowhere to parameterize the knowledge base name. Is it possible to change this input into a property?
unable to see DQS Cleansing transformation after upgrading SSIS 2017 to SSIS 2022.
I am not able to see DQS Cleansing transformation after upgrading SSIS 2017 to SSIS 2022 in DATAFLOW task. I already tried uninstalling and reinstalled SSDT and VS 2022.
The process exit code was "1" while the expected was "0" Error
The following error keeps occurring intermittently, the issue is not with permission because it works fine the majority of the time and no changes have been made to the ssis package. Would you please let me know what the following Error means? The…
Azure SQL Server on Managed Instance not the best fit for Data Warehouse + ETL workloads! Do you agree?
Hi, I currently have a Data Warehouse on an Azure Managed Instance and SSIS Packages hosted on the SSISDB Catalog of the same instance being executed via Azure-SSIS Integration Runtime. By looking at the features offered by a Microsoft Managed Instance,…
Errors upgrading SSIS 2014 packages to 2022 using the SSIS 2022 VSIX in Visual Studio 2022.
I’m trying to upgrade some packages from SSIS 2014 to SSIS 2022. I can’t find any documentation that says I can’t do this, but it’s not working. I open the project in VS 2022 with the SSIS extension. I’m using the Feb 13 release (version 0.3). I right…
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…
Occasional error for a SQL Server Agent job that calls SSIS packages to read SAP data - error code 0xC0014009
Hi, I’m monitoring a SQL Server Agent job that calls some SSIS packages deployed on the SSIS catalog, in order to load SAP data into a SQL staging via ODBC. This job goes in error one time each 4-5 runs with success. In particular, the error is “The…

source file path/db name ssis
Hi Expert, how to get db name or source file path from packages for an example

dynamic columns
Hi, I have a requirement to import data from different excels into DB using SSIS. Challenge is each excel file has different columns names with different file names. For example - one excel file will have - empid,empfname,emplname other excel file -…
SQL access control error: Insufficient privileges to operate on stage while copying data from sql server to snowflake
{ "errorCode": "2200", "message": "ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [42501] SQL access control error:\nInsufficient…

how to migrate from azure dedicated SQL pool to another azure dedicated SQL pool (different server,subscription)
I have around 3 TB of azureSQL DW . I want to migrate the entire DW to another azure DW which is under different subscription. what are the tools that can be used to achieve this or can you help me with the steps for the migration ? looks like I cannot…

SSIS package is executing fine in visual studio but slow down in SQl agent
Hi All i have one stage package which is executing in VS 2019 successfully but when calling from Sql agent its failing. the below is the error mesagae Message Executed as user: abc\user. Microsoft (R) SQL Server Execute Package Utility Version…

Connecting to Oracle using Microsoft Oracle Source Component by Attunity via LDAP for SQL 2022 Upgrade
We are upgrading from SQL Server 2016 to SQL Server 2022.. Our current SSIS packages use the Attunity drivers for 2016 to pull data from an external Oracle server database using LDAP protocol. We understand that Microsoft has created the Microsoft…

Sudden connection performance degredation
Hi, We have an Azure VM running Windows 2016 with SSIS installed. We retrieve and write data multiple times per day rom om-premise servers to an Azure SQL Server. Since tuesday morning, queries coming from 2 specific servers (Oracle) and to the…

C# Runtime Error - Diamond dependency when using Microsoft.Graph.Core (Microsoft.Kiota.Abstractions)
Hi guys, I've run into an issue whilst developing an SSIS package that's intended to automatically distribute emails using a Microsoft Graph connector. I'm using a Script component to perform the communication using C# and referencing the…
How to add ssisdb to distributed availability group?
How to add ssisdb to distributed availability group?

How to integrate flat file with special characted contain
Hi I have a csv flat file as per attached. I need to integrate the data from this flat file ODS destination SQL server table. I get error VinNo column delimiter not found when I run the SSIS. I understand because of the special char presence in the…

How to aggregate report on the number of days trip for vehicle
Hi All, SQL version: Lets say I have the database table consist of vehicle trip. The vehicle trip have start and end for every trip done by the vehicle. How can I get the number of days trip for vehicle done based on the trip done by vehicle. I have done…
