SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,508 questions
3 answers
SSIS Execute SQL Task error: Syntax error or access violation
Hi All, I am running below code in SSIS Execute SQL Task and Passing an input parameter to code. My connection is OLEDB connection so I am using ? but it is failing with error message: "failed with the following error: "Syntax error or…
asked 2020-09-24T07:02:42.477+00:00
Shivendoo Kumar
736
Reputation points
commented 2020-09-28T06:34:08.54+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
3 answers
One of the answers was accepted by the question author.
Protocol Error in TDS Stream SSIS when running with SQL Server Agent Job
Hi everyone, I have a SSIS package that pulls data from a source SQL server to a destination SQL server using a OLE DB provider for SQL Server Native Client 11.0. When I run the package in Visual Studio from the destination server everything works…
![](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(41.6, 17%, 14%)' 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
SSIS: How to go to next iteration in for each after a Error on actual Control Flow iteration?
Hi, I have a scenario where I have a Master Packet, and this Master call another 12 others .dtsx packets through 'Execute Packet Task' in sequence inside a ForEach loop. I run my Master ETL based on Customer separation...All packets for Customer1, all…
asked 2020-09-15T13:02:06.573+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
answered 2020-09-24T09:55:23.84+00:00
Monalv-MSFT
5,896
Reputation points
3 answers
One of the answers was accepted by the question author.
extracting .MPP files in Sharepoint using SSIS
Hello, I am trying to extract an .mpp file from a SharePoint Document folder . I'm able to use the OData Source to connect to SharePoint to see the lists but have no clue how to get to the files. Any assistance would be appreciated. Thanks …
asked 2020-09-22T21:11:06.293+00:00
Dyanna Hess-Miller
61
Reputation points
answered 2020-09-23T19:54:14.837+00:00
COZYROC
101
Reputation points
3 answers
Package dependency SSIS
Hi, Developers constantly ask for changes to table structures (column name, PK, FK) in SQL Server. I need to know which packages of the SSIS project should be changed if any database table is changed There are more than 100 packages I can't do it…
asked 2020-09-08T14:27:21.427+00:00
Keny Maciel
1
Reputation point
answered 2020-09-21T15:44:18.527+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(19.2, 13%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
Data Learner
1
Reputation point
2 answers
Replicate a database on-premise with muiltiple server to Azure SQL
I have done a copy of my onpremise database on Azure Sql but now my problem is the onpremise database is connected to diferents database from providers, and now i want to to the same connections in my Azure Sql For example PRIMAVERA and MEXICO (the…
asked 2020-09-16T09:48:13.807+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(32, 31%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Colina Davila, Carlos Javier
1
Reputation point
commented 2020-09-21T09:43:25.327+00:00
Monalv-MSFT
5,896
Reputation points
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
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,921
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,508 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.
1,005 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