SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
4 answers
One of the answers was accepted by the question author.
Error when Running SSIS Package which has variables from Project.Params file using .bat file
Hi all, I am running my SSIS Package using .Bat file but encountered some errors. Currently, the SSIS Package is using project level variables which is stored in Project.params file. When i run the package using .bat file, i encountered errors…
![](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(80, 71%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
SSIS packege to load CSV file in new sql table every time it runs.
Hello, I am new to SSIS.I need to create a SSIS package where CSV is the source file and SQL table is the destination. Users place CSV file once in a week, for every run (on a weekly basis) it needs to create a new dynamic SQL table in DB.Table name will…
asked 2021-02-24T22:00:35.727+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(28.799999999999997, 34%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Kavitha Chandra
96
Reputation points
commented 2021-02-26T01:43:48.127+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
How to connect SSIS (on prem) to an Azure Managed Instance
Is it possible to connect SSIS that resides on-prem to an Azure Managed Instance?
asked 2021-02-10T19:04:04.59+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(105.60000000000001, 53%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
LM
1
Reputation point
commented 2021-02-26T00:12:56.497+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(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
25,116
Reputation points
2 answers
One of the answers was accepted by the question author.
SSIS load multiple files with same structure but diff extension using FELC
I have a scenario where I need to load multiple files with different file types but same structure eg: Emp_USA_012021.txt (Empid, name, desig) Empl_UK_012021.csv (Empid, name, desig) Employees_Europe_202101.xlsx (Empid, name, desig) Into sql table dbo.…
asked 2021-02-25T02:10:37.01+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(307.2, 41%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Newbie Newbie
21
Reputation points
accepted 2021-02-25T15:38:21.45+00:00
Newbie Newbie
21
Reputation points
1 answer
Import Excel Spreadsheets(plural) using Data Touch Points to prime a SQL Server Stored Procedure to INSERT
So I have to load multiple Excel spreadsheets to our Database. It's actually Customer Contact information...Emails...Texts...etc.. Each file layout being different. So we'll start with a Foreach Loop Container to process each file in its source File…
asked 2021-02-24T15:22:56.24+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(310.4, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBP%3C/text%3E%3C/svg%3E)
Bobby P
221
Reputation points
answered 2021-02-25T09:55:33.703+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
SSIS Proxy Credential Ignored
If I run a SSIS package through a SQL Agent job using a runas SSIS proxy account the package doesn't work - fails with a required connection (which it has permissions to). However, if I run SQL Agent using the same account as the proxy and choose SQL…
![](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, 11%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
“Create Catalog” is greyed out in SSIS
I'm try to create catalog in SSIS but when right clicking on Integration Services Catalogs, the Create Catalog is greyed out. It is a SQL server 2017 Developer edition. How can this be fixed?
asked 2021-02-24T19:58:38.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(233.6, 57.99999999999999%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kamalpreet Singh
81
Reputation points
accepted 2021-02-24T21:28:40.413+00:00
Kamalpreet Singh
81
Reputation points
4 answers
SharePoint Online-Reading/Access Lists-Using SSIS -OData Connection- Error 401 Unauthorized
Hi I am trying to connect with Lists data on Sharepoint online. I am working in SSIS -Visual Studio 2017 Odata Connector I have installed SDK-2013 as well and followed all the instruction on blogs on this topic. But I am getting error , TITLE:…
asked 2021-02-20T21:47:22.763+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(230.39999999999998, 25%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU7%3C/text%3E%3C/svg%3E)
Uzi 7117
1
Reputation point
answered 2021-02-24T16:13:06.517+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(313.6, 92%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Steve Rely
1
Reputation point
1 answer
HDFS modify row delimiter
Hi, for maintain the standard in my HDFS i need to modify the row delimiter. I use SSIS to get data from a DB and put in HDFS with the tool "Destination HDFS" , i need to replace the row delimiter from {CR}{LR} to {LR}. The tool…
asked 2021-02-19T16:23:02.103+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(297.6, 74%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Silipigni Marco
1
Reputation point
commented 2021-02-24T10:01:43.217+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
One of the answers was accepted by the question author.
Issue to SQL server 2012
Hi, There was no change to SQL server 2012 but why did the issue below arise? TITLE: Connect to Server > Cannot connect to WIN-429I3QNHOQT\EXPR2012. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred…
asked 2021-02-22T07:16:39.973+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, 43%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Peter_1985
2,526
Reputation points
accepted 2021-02-24T07:37:57.107+00:00
Peter_1985
2,526
Reputation points
1 answer
SSIS package Error - VS_Newmetadata
I have been using SSIS package to get data from SQL server Database . One of the queries being used is Select Ora_database_name as Database, to_char(SYSDATE,'YYYY-MM-HH24:MI:SS') as SCRIPT_RUN_DATE FROM Dual. Whenever there is a change in the environment…
asked 2021-02-11T21:29:53.237+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(140.8, 91%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Brijesh S Patel
1
Reputation point
commented 2021-02-24T07:09:15.157+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
Unexpected Termination - SSIS package writing to an Excel file
Hi I have an SSIS Package that writes to an excel file. It works fine in the DEV environment but wouldn't work in LIVE, the error was Unexpected Termination with no errors in the messages. I uninstalled and reinstalled the access database engine…
asked 2021-02-08T16:56:12.163+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(144, 61%, 23%)' 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)
Sam Garth
26
Reputation points Microsoft Employee
commented 2021-02-24T06:38:28.297+00:00
Monalv-MSFT
5,896
Reputation points
3 answers
SSIS package running fine from SSDT but not running from SQL Server 2019
Hello, SSIS package running fine from SSDT but not running from SQL Server 2019. I had tried all solution from internet but did not get any solution from it. Source and destination is oracle and SSIS package running from SQL Server 2019…
asked 2021-01-28T05:50:40.75+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(176, 12%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Kiritkumar Baraiya
1
Reputation point
answered 2021-02-24T02:53:57.74+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
I have an SSIS package where Source: IBM DB2, Target: SQL Server. I have created a package in SSIS and able to run perfectly in my local machine. All connections work perfectly, data populates in the target tables. However, after deploying it to SQL…
asked 2021-02-12T19:42:54.193+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(128, 8%, 22%)' 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)
Anonymous
commented 2021-02-23T22:18:47.33+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(278.4, 41%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Bamford
1
Reputation point
2 answers
File system task error ; Access to the path " " is denied when copy file using file system task
Hi, I am using file system task to copy files from one folder to another folder. When i tried to copy fileA from folderA to folderB, an access denied to path error will pop up when folderB has fileA. I tried deleting fileA in folderB and run my…
1 answer
One of the answers was accepted by the question author.
SSIS Encryption data tap
Dear, Via SSIS we need to load sensitive data into the SQL database. In this SQL DB we can use always encrypted as even DBA's may not see the data. However the next weakest link is a data tap in SSIS; is there a way to shield off everything so that from…
asked 2021-02-18T09:47:50.567+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(163.2, 77%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBD%3C/text%3E%3C/svg%3E)
Bram Decraene
21
Reputation points
accepted 2021-02-22T07:35:34.553+00:00
Bram Decraene
21
Reputation points
3 answers
One of the answers was accepted by the question author.
SSIS integration to run simple clustering task
Dear all SSIS fellow, Right now I work on SSIS pipeline to make automatic feature engineering which also have simple AI process to make the class. In the pipeline, we need to make a cluster based on simple feature (8 column pulled from database…
asked 2021-02-19T03:49:02.06+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(163.2, 10%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYS%3C/text%3E%3C/svg%3E)
yosafat saragih
21
Reputation points
commented 2021-02-22T03:22:02.493+00:00
Yitzhak Khabinsky
25,116
Reputation points
1 answer
Encrypted columns in SQL Server database
Hi I have to retrieve data from database (DB1) which has encrypted columns. I have written a stored proc (as my query has lot of temp tables) to extract data from DB1 and to insert it to tables in database DB2. In SSIS package or direct insert from…
![](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(22.400000000000002, 52%, 12%)' 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)
4 answers
ODBC with SSIS On Linux
I have installed unixODBC 2.3.4 and Mysql ODBC Driver, when I use CMD "isql DNS" ,it can connect to MysqlDB； but when I use dtexec pacakge to run SSIS ,it can't recognize DNS. The Error is "INVALID_HANDLE - unable to allocate an…
asked 2021-01-25T13:30:51.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(220.8, 3%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWC%3C/text%3E%3C/svg%3E)
william.chen
1
Reputation point
answered 2021-02-20T01:38:22.857+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, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWC%3C/text%3E%3C/svg%3E)
william chen
1
Reputation point
1 answer
Not able to connect azure analysis service using sevice principal in SSIS
I am receiving following message “Test connection failed because of an error in initializing provider. The following system error occurred: “ (Without any error description) while trying to connect Azure Analysis Services in SSIS using service principal…
asked 2021-02-11T13:30:59.747+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(233.6, 33%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Satish Sridharan (Cognizant Worldwide Limited)
1
Reputation point
commented 2021-02-19T13:17:21.21+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(201.6, 79%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SQLDev2021
1
Reputation point