Microsoft Q&A

SQL Server Integration Services

2,092 questions

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,092 questions with SQL Server Integration Services tags

Sort by: Updated
5 answers

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',…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,109 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,882 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,372 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-06-09T13:44:15.1866667+00:00
Shambhu Rai 876 Reputation points
edited an answer 2023-06-10T06:10:11.7633333+00:00
Samy Abdul 3,191 Reputation points
3 answers

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,882 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2022-02-19T20:22:29.447+00:00
coool sweet 61 Reputation points
edited an answer 2023-06-10T05:11:01.39+00:00
si li 0 Reputation points
2 answers

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?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2022-02-08T08:30:18.847+00:00
Yulia Fei 11 Reputation points Microsoft Employee
commented 2023-06-09T21:38:47.13+00:00
Ricardo Silva 1 Reputation point
1 answer

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,882 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-01-20T23:11:53+00:00
Agnel, Jasmine 0 Reputation points
commented 2023-06-09T21:34:44.7866667+00:00
Ricardo Silva 1 Reputation point
0 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,882 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-06-09T09:25:52.04+00:00
sql dev 6 Reputation points
2 answers

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

SQL Server on Azure Virtual Machines
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
Azure SQL Database
asked 2023-06-07T15:01:15.14+00:00
Marcelo Barbieri 0 Reputation points
answered 2023-06-08T14:16:57.11+00:00
Bas Pruijn 846 Reputation points
3 answers

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…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
3,191 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-03-09T17:08:09.4166667+00:00
Meagan Longoria 26 Reputation points MVP
answered 2023-06-08T13:37:03.8266667+00:00
Jim R. Donkersgoed 0 Reputation points
2 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…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
3,191 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-04-26T00:34:01.27+00:00
Seeley, Steve 0 Reputation points
answered 2023-06-08T13:03:47.4866667+00:00
TJH 0 Reputation points
1 answer

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,882 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-06-07T13:57:09.69+00:00
pmscorca 246 Reputation points
commented 2023-06-08T08:14:00.5566667+00:00
ZoeHui-MSFT 22,216 Reputation points
2 answers

source file path/db name ssis

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,882 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,372 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-06-06T12:30:27.6166667+00:00
Shambhu Rai 876 Reputation points
commented 2023-06-08T06:07:24.8+00:00
Olaf Helper 29,276 Reputation points
2 answers One of the answers was accepted by the question author.

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 Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,882 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-06-07T19:16:59.17+00:00
Dinesh Kalva 20 Reputation points
accepted 2023-06-08T05:22:34.1633333+00:00
Dinesh Kalva 20 Reputation points
0 answers

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-06-07T14:01:40.6366667+00:00
K Sai Shireesh 0 Reputation points
commented 2023-06-07T23:40:41.4733333+00:00
Oury Ba-MSFT 11,381 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

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…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,213 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-05-04T10:45:24.0866667+00:00
Prasanna, Prashanth (RIS-CON) 20 Reputation points
edited the question 2023-06-07T06:00:42.35+00:00
ZoeHui-MSFT 22,216 Reputation points
1 answer

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-06-06T16:24:46.07+00:00
Naresh y 81 Reputation points
answered 2023-06-07T02:38:28.66+00:00
ZoeHui-MSFT 22,216 Reputation points
1 answer

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-06-06T21:47:39.7933333+00:00
MakingEasyLookHard 0 Reputation points
answered 2023-06-07T01:38:08.0466667+00:00
ZoeHui-MSFT 22,216 Reputation points
0 answers

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…

Azure VPN Gateway
Azure VPN Gateway
An Azure service that enables the connection of on-premises networks to Azure through site-to-site virtual private networks.
985 questions
Azure VMware Solution
Azure VMware Solution
An Azure service that runs native VMware workloads on Azure.
230 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,882 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-06-01T15:38:42.23+00:00
Peter Vos (Admin) 0 Reputation points
commented 2023-06-06T17:35:27.3566667+00:00
KapilAnanth-MSFT 15,701 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

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…

Microsoft Graph Mail API
Microsoft Graph Mail API
A Microsoft API that supports accessing data in users' primary mailboxes and in shared mailboxes.
812 questions
Microsoft Graph SDK
Microsoft Graph SDK
A Microsoft software developer kit designed to simplify building high-quality, efficient, and resilient applications that access Microsoft Graph.
891 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
8,246 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-05-26T11:26:05.56+00:00
Andy Guinan 30 Reputation points
accepted 2023-06-06T17:10:41.3233333+00:00
Andy Guinan 30 Reputation points
1 answer

How to add ssisdb to distributed availability group?

How to add ssisdb to distributed availability group?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-06-05T06:24:29.3066667+00:00
mohamed Abdalla 0 Reputation points
answered 2023-06-05T07:03:08.45+00:00
ZoeHui-MSFT 22,216 Reputation points
3 answers

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-06-04T04:03:11.3333333+00:00
jn93 631 Reputation points
commented 2023-06-05T06:13:09.7533333+00:00
ZoeHui-MSFT 22,216 Reputation points
3 answers One of the answers was accepted by the question author.

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,882 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,092 questions
asked 2023-06-02T08:50:30.13+00:00
jn93 631 Reputation points
edited an answer 2023-06-05T02:14:31.09+00:00
CosmogHong-MSFT 11,896 Reputation points Microsoft Vendor