SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
1 answer
Median aggregation in SSIS
Hi, I have a table of that have 3 columns, column A, column B and column C. Column B can have multiple records of column A. What I need to do is to add another column that contains the median value of column C based on column B. The thing is, the…
asked 2020-09-17T07:58:22.32+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 7.000000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
Yohandy
1
Reputation point
commented 2020-09-21T01:12:38.913+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Monalv-MSFT
5,896
Reputation points
1 answer
Convert SSIS Packages to MSSQL Stored Procedures
I have been tasked to convert a SSIS package to stored procedures. The package runs in less than 60 seconds. The package builds staging files from DB2 to MSSQL and then runs the MSSQL Merge statement. Unfortunately, if I try to use an OPENQUERY to…
asked 2020-09-14T20:23:33.703+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 6%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Michael Henderson
111
Reputation points
commented 2020-09-18T03:51:05.72+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
I'm trying to source data in a comma-delimited file from an Azure Gen2 Storage account using Flexible File Source task. The connection succeeds but Preview of data is blank.
I'm trying to pull data from ADLS Gen2 using the SSIS Flexible File Source task. I'm getting blank results when trying to view the data in the Columns tab of the dialog.
asked 2020-09-13T19:33:30.68+00:00
atrapp
6
Reputation points
commented 2020-09-18T03:49:40.807+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
cast COM object of type error using SSIS ODBC Connection to PostgreSQL
hi I have one doubt in ssis how to avoid Unable to cast COM object of type error using SSIS ODBC Connection to PostgreSQL I want load data from postgres to sql server using ssis package . In ssis solution I have 50 plus dft for loading data …
asked 2020-09-10T16:31:14.433+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 41%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
harinathu
6
Reputation points
commented 2020-09-18T03:47:30.217+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
Unable to reference Custom Class library in SSIS Script Component
I have a .Net Standard 2.0 Class Libary which I am unable reference in my SSIS Script Component. I am using Visual Studio 2019. The Library has the following settings. Whenever the script references the library I get an error indicating the…
asked 2020-09-11T00:02:43.583+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 7.000000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
scott goodwin
1
Reputation point
commented 2020-09-18T03:45:47.947+00:00
Monalv-MSFT
5,896
Reputation points
3 answers
One of the answers was accepted by the question author.
finding the invalid character
In my SSIS project in Visual studio 2019, I am receiving this error. An error occurred with the following error message: "System.Xml.XmlException: ' ', hexadecimal value 0x03, is an invalid character. Line 44, position 4. I believe I have…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 16%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
2 answers
Truncation may occur due to inserting data
I recently changed the flat file source in the data flow task. Following that change, I am noticing below error for most of the columns and SSIS package no longer executes. Can someone please let me know what might be going wrong? Also I see these…
asked 2020-09-10T02:40:09.937+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 9%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Mike Harris
1
Reputation point
answered 2020-09-15T21:51:04.02+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 23%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
Jeffrey Williams
1,891
Reputation points
2 answers
SSIS Package assessment Uisng Data Migration Assistant
We have successfully created a small SSIS package that extracts data from CSV and stores it in the SQL Server database. The next task is to carry out an assessment of the Integration Services using the Data Migration Assistant. I am following…
asked 2020-09-09T13:05:49.887+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 64%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENJ%3C/text%3E%3C/svg%3E)
Nikhil Jha
1
Reputation point
answered 2020-09-15T02:46:18.263+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
One of the answers was accepted by the question author.
Script Task:Error: Could not load file or assembly 'Oracle.DataAccess, Version=2.112.1.0
Hi All, I create a SSIS C# Script task to pull data from oracle server. I'm using default "Oracle.DataAccess,.DLL" from oracle 11g 32 bit. when i run that package normally its work fine. but after deploy package in SSIS DB package not working…
asked 2020-09-14T04:19:22.243+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 63%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELW%3C/text%3E%3C/svg%3E)
lonely wolf
21
Reputation points
answered 2020-09-14T06:15:46.883+00:00
lonely wolf
21
Reputation points
1 answer
Error Testing Connection from SSIS to ADLS Gen2
I'm trying to connect to ADLS Gen2 from SSIS using an Azure Storage Connection Manager using a service account & Service Principal authentication. I'm using the Key Vault client ID for the application ID and secret key for the Application key. I'm…
asked 2020-08-31T17:17:19.263+00:00
atrapp
6
Reputation points
commented 2020-09-14T02:15:53.777+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
Fail to update an existing SSIS package
Hi, We are running SQL Server 2016. Lately, I have already updated an existing package in a SSIS Solution as the request of sorting sequence has been changed. When I run the package in Data Tools, the output Flat File is correct. Then I Deploy…
asked 2020-09-08T06:42:42.047+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 99%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
TonyJK
876
Reputation points
commented 2020-09-14T01:10:56.95+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,611
Reputation points
2 answers
ssisdb database not there
hi all, I just installed sql server 2016 and ssis I do not see the ssisdb in the list of databases, please advice
asked 2020-09-04T06:07:19.223+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 99%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NeophyteSQL
241
Reputation points
answered 2020-09-11T10:29:53.437+00:00
Olaf Helper
42,746
Reputation points
3 answers
SSIS solution edited on VS 2019 Enterprise can't be opened on VS 2019 Pro
I've had to switch from VS 2019 Enterprise to VS 2019 Pro as the Enterprise eval licence expired. (I had to install a separate instence of VS 2019 Pro). The SSIS solution and packages that worked fine on the Enterprise version won't open in the Pro…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
996 questions
asked 2020-08-27T15:25:18.537+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 35%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
AntoDN
1
Reputation point
commented 2020-09-11T10:01:34.293+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
processing encrypted files with SSIS (flat file source)
Any recommendations on how to process (file-level) encrypted data with SSIS? We'd like to avoid any un-encrypted content on disk, and instead read the encrypted data into memory (or the database,) decrypt using .NET, then proceed with transform &…
asked 2020-09-02T21:21:43.917+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 44%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Roman P
1
Reputation point
commented 2020-09-11T09:56:35.913+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
Code review checklist and Secure best practices for SQL, SSIS
HI. Is there a document for : Code review checklist for SQL, SSIS and Secure best practices for SQL, SSIS ? Could anyone please point to these ? Thanks
asked 2020-09-02T11:52:17.997+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 16%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
venkatesh padmanabhan
181
Reputation points
commented 2020-09-11T09:44:35.06+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
How to know what row crashed my SSIS DataFlow -> ScriptComponent?
Hi, I am with a problem that my C# script componente is crashing with the message: "The column has a null value" But I am executing a data flow over a table with more tem 100.000 rows and more than 60 columns. This simple message is…
asked 2020-09-03T17:42:10.773+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 0%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
Luis Lima
61
Reputation points
commented 2020-09-11T09:42:46.597+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
SQL Server SSIS package performace issue
Hello All, Using SQL Server SSIS package Trying to export MS SQL table data into oracle table it is taking 1hr for 50 lac row (Table Name - EMP, Column ID, and Name) For the same table SSIS IMPORT taking only 1 min. I need help or suggestion how…
asked 2020-09-04T00:53:56.307+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 7.000000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGR%3C/text%3E%3C/svg%3E)
GUPTA, R. (Rajeev)
1
Reputation point
commented 2020-09-11T09:39:31.017+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
SSIS Source Control Azure Dev Ops Git repo help
HI All. I have recently moved an SSIS project from VSTS into an Azure DevOps git repo. The project is a simple one with a master package calling several child packages using "Execute package Task " with reference type = "Project…
asked 2020-09-08T07:36:34.57+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 86%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA0%3C/text%3E%3C/svg%3E)
ApplebyNick-0083
1
Reputation point
commented 2020-09-11T09:30:25.963+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
SSIS OData conn parameterized
Hello, I am having some trouble parameterizing an OData connection to sharepoint. I created an SSIS package that gets a list from sharepoint. I am using an OData conn manager, the auth type is Microsoft Online Services. In VS2019 I provide the…
asked 2020-09-07T14:22:32.097+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 5%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Richardo Roias
6
Reputation points
commented 2020-09-11T09:30:00.4+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
Attunity CDC for Oracle OCI_FETCH error
We have setup Oracle CDC by Attunity in a SQL server 2016 environment. From the Designer everything runs fine until an actual change happens in one of the included tables in the Oracle database at which point the operation aborts. When looking at the…
asked 2020-09-05T14:25:13.25+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 83%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
Perusse, Tim PW
1
Reputation point
commented 2020-09-11T09:27:39.347+00:00
Monalv-MSFT
5,896
Reputation points