Microsoft Q&A

SQL Server Integration Services

2,130 questions

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

2,130 questions with SQL Server Integration Services tags

Sort by: Updated
1 answer

SSIS : Connecting SharePoint Site through OData Source

Hi All - I am connecting to a SharePoint site and i have edited the site at end like below and at the end i have added _vti__bin/List.svc also i am able to access the sharepoint site through my account. When i selected the Odata source and passed the…

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
7,421 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,565 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.
10,211 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2023-07-13T00:04:27.4866667+00:00
kkran 771 Reputation points
answered 2023-07-13T01:52:13.6766667+00:00
ZoeHui-MSFT 23,541 Reputation points
2 answers

How to fix SSIS (dtexec) System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException

We have a very old SSIS package that runs fine on Windows Server 2012 R2. We are decommissioning the Windows Server 2012 R2 vm and have a Windows Server 2016 vm. The SSIS package accesses Oracle. I can see within the script portion of the dtsx…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2023-07-10T19:52:29.5533333+00:00
brwillia 0 Reputation points
edited an answer 2023-07-12T17:42:17.47+00:00
Yitzhak Khabinsky 22,121 Reputation points
1 answer

Package source SSIS Catalog with Windows Authentication only

hi all, anyone know that SSIS Catalog source on SQL Agent Job setting give us option Log on as Windows Authentication only.. great appreciation for all answer regards, Urbel

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,211 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2023-07-12T03:57:28.78+00:00
RASWADI 0 Reputation points
answered 2023-07-12T09:50:10.74+00:00
ZoeHui-MSFT 23,541 Reputation points
2 answers One of the answers was accepted by the question author.

Validate multiple columns in a csv file

Am loading a CSV file to a landing table , the problem is i have to check if some of the columns in the file are numeric or not , if they are not numeric the file should be sent to the error folder .If not they file must be processed to the landing table…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,211 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2023-07-10T12:42:50.73+00:00
Mfezeko Donald Sodawe 20 Reputation points
accepted 2023-07-11T07:39:17.1933333+00:00
Mfezeko Donald Sodawe 20 Reputation points
2 answers

SSIS - Derived task expression help to check if numeric

hi all, my data is coming from excel to sql via ssis package. now in my excel , sometimes due to formula i am getting data like #ERROR,#DIV/O,-,N.A,n.a and etc.. Now i want to put condition that,If data is numeric then leave as it is and if it is…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,211 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2020-09-07T13:01:05.123+00:00
Vishal Parikh 1 Reputation point
commented 2023-07-11T07:14:10.6566667+00:00
Mfezeko Donald Sodawe 20 Reputation points
5 answers One of the answers was accepted by the question author.

SQL and SSIS : Extract part of file name in SQL / SSIS.

Hi All - I have five SSIS packages and each of these packages source is a csv file. Each packages access the shared folder path respectively and loads the data into the SQL database table. Below are the file naming conventions of the files : …

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 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.
10,211 questions
asked 2023-07-05T21:29:27.37+00:00
kkran 771 Reputation points
accepted 2023-07-10T21:57:04.6066667+00:00
kkran 771 Reputation points
1 answer One of the answers was accepted by the question author.

SSIS : Read flat file header and load data into table.

Hi All - I have a package the reads the csv file and loads the data into the SQL table. But in SSIS i have checked in option of 'Headerrowstoskip' =1. My table is static and below is my table structure. Earlier, the requirement was not to read the header…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,211 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2023-06-23T22:29:19.3433333+00:00
kkran 771 Reputation points
accepted 2023-07-10T21:56:52.1366667+00:00
kkran 771 Reputation points
6 answers

SQL Server Excel Import - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

I'm trying to do a simple Excel import into a local SQL Server instance installed on my machine (to do some analysis), I'm attempting to use the wizard through SSMS. This worked a few days ago and I imported a couple of thousand tabs into tables in SQL…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,211 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2021-11-19T14:32:00.537+00:00
Alex Fletcher 16 Reputation points
commented 2023-07-08T19:21:38.18+00:00
Azaria Anderson 0 Reputation points
2 answers

what is cost for deploying on ssis server to onpremises to other server

what would be the cost for deploying on ssis server to onpremises other server

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
408 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.
10,211 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2023-03-28T12:53:58.63+00:00
Manikantha Narayana 0 Reputation points
edited the question 2023-07-07T23:33:03.99+00:00
lindalu-MSFT 161 Reputation points Microsoft Employee
5 answers

An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536

We have moved our SQL Database to SQL Server on Azure VM. I have already ran these USE SSISDB GO EXEC sp_changedbowner 'sa' Alter database SSISDB SET Trustworthy ON I am trying to deploy the package and create a folder but I still gettign…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2020-10-07T10:41:41.68+00:00
Nicky 116 Reputation points
commented 2023-07-07T13:24:13.2566667+00:00
Johnny Serrano 0 Reputation points
1 answer One of the answers was accepted by the question author.

Getting error while deploying SSIS packages through powershell

When we tried deployment of SSIS packages to sql server with sql login credentials instead of windows authentication through powershell, I am getting below error "The operation cannot be started by an account that uses SQL Server Authentication.…

Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
4,957 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.
10,211 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
936 questions
asked 2023-07-05T10:01:43.98+00:00
LVS Raghu Vamsi 40 Reputation points
accepted 2023-07-07T06:17:55.1166667+00:00
LVS Raghu Vamsi 40 Reputation points
4 answers One of the answers was accepted by the question author.

How to load CSV file with last row in bad format

Hi everybody, I have data like this: "629","New Orleans Medical Center","70444","28113","PIKE","LA","20230630","20230701" "629","New Orleans Medical…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,211 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2023-07-06T13:43:56.6366667+00:00
Naomi 7,361 Reputation points
commented 2023-07-06T21:54:27.2333333+00:00
Erland Sommarskog 80,906 Reputation points
1 answer

SSIS package targeting SS 2019 enforces 4.7 but want to change it to 4.7.1 atleast across all SSIS packages

It looks like SSIS packages targeting SS2019 enforces 4.7 .Net framework. However, I really want to enforce 4.7.1 or higher. I Can go and change at the script task level, but I guess that is not ideal if I have 40+ SSIS packages with 3 or more script…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2022-06-03T19:12:39.813+00:00
balu raju 51 Reputation points
commented 2023-07-06T19:29:38.1666667+00:00
P L 0 Reputation points
2 answers

Visual Studio SSIS project execute script task : C# version

I have a SSIS project and there is a script task inside it . but i am wonder if I can change the C# project version of it ? it always keep at framework 4.5

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2021-12-22T04:37:55.34+00:00
sakuraime 2,296 Reputation points
commented 2023-07-06T19:26:09.96+00:00
P L 0 Reputation points
6 answers

SQL Server 2022 Developer Edition - Installation of the SSIS Integration Services

Hello to all, I have been trying to do the one Integration Services installation on my SQL Server 2022 Developer Edition environment. Unfortunately I always get errors during the installation, these are mainly related to the installation of Microsoft OLE…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,211 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2023-02-20T09:37:55.24+00:00
Alessandro Di Pasquale 5 Reputation points
answered 2023-07-05T20:48:42.4333333+00:00
Brenda Woods 0 Reputation points
2 answers One of the answers was accepted by the question author.

Getting issue "Unable to fetch cdc processing range" in sql server

I am getting the below issue continuously for the job which points to SSIS package to capture and populate the changes to audit tables and lsn state variable values getting changed to TFREDO instead of TFSTART or TFEND Error -"Possible reasons:…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
7,986 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
936 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.
10,211 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2023-06-19T12:42:01.0366667+00:00
LVS Raghu Vamsi 40 Reputation points
accepted 2023-07-05T10:12:57.41+00:00
LVS Raghu Vamsi 40 Reputation points
2 answers

Reliable data provider to read SAP data inside a SSIS solution

Hi, I need to evaluate a more reliable data provider for reading SAP data in a SSIS vers. 2017 solution respect to the ODBC SAP HANA. Any suggests to me, please?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,211 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2023-07-04T11:50:28.19+00:00
pmscorca 157 Reputation points
commented 2023-07-05T08:18:08.09+00:00
Amira Bedhiafi 226 Reputation points
1 answer

Export Column Transformation in SSIS is not working.

I use Export Column Transformation to read data in a data flow and insert the data into a file in SSIS (Visual Studio 2019). When I open Export Column Transformation Editor and there are no options, see below. Does anyone know what the issue is?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2023-07-01T05:58:30.36+00:00
Rainbow1517 21 Reputation points
commented 2023-07-05T03:15:10.8866667+00:00
Rainbow1517 21 Reputation points
2 answers One of the answers was accepted by the question author.

Can I use case condition in SSIS

I can use case when in tsql, is it possible to use case condition in SSIS?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2023-06-30T00:06:54.16+00:00
sql test 60 Reputation points
accepted 2023-07-04T00:51:31.84+00:00
sql test 60 Reputation points
1 answer One of the answers was accepted by the question author.

Null values in package

I've created a package with SSIS, contains flatfile as source and load the data to sql server table, however it could not keep the null values, please advice.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,130 questions
asked 2023-06-30T00:13:00.1766667+00:00
sql test 60 Reputation points
accepted 2023-07-04T00:50:51.8+00:00
sql test 60 Reputation points