Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2016 is a part of SQL Server 2016 Data Tools
Questions tagged [ssis-2016]
96 questions
1
vote
1 answer
SSIS adding more than 200 columns in flat file source as a header
I am using VS2015,I have input as a flat file which doesn't have headers.I need to add the multiple columns that is all most more than 200 columns as flat file header.Basically how we can do is we will open FLAT FILE CONNECTION MANAGER and will go…
Hemanth aks
- 11
- 2
1
vote
1 answer
SSIS loading Excel file
This is my first time using SSIS, I'm getting this error.
Using:
VS 2015, Excel 2010
Exception from HRESULT: 0xC02020E8
Error at Data Flow Task [Excel Source [1]]: SSIS Error Code DTS_E_OLEDBERROR.
An OLE DB error has occurred. Error code:…
Draco
- 51
- 8
1
vote
1 answer
Sharepoint 2010 List adaptor for SSIS 2016
Background
Migraing from SSIS 2012 to 2016. Connecting to an exisint Sharepoint 2010 site. Using SSDT for VS15. In SSIS 2012 project, we used SharepointlistAdapters from CodePlex.
Problem:
When loading 'old' project, I get the error that the…
Esperanza
- 115
- 10
1
vote
2 answers
Deploying a SSIS 2016 packages (Project Deployment Model) to the file system
Working on a project to migrate SSIS 2008 projects to 2016 deployed to a File Server. Currently have the packages on the file server and prefer to keep it that way. I'm aware that the Project Deployment Model has been introduced since 2012. …
Esperanza
- 115
- 10
1
vote
2 answers
Disable parallel execution of SSIS packages at server level
Can anyone advise if there is a way to disable or limit parallel execution of SSIS packages at the server level?
I have an SSIS project with a large number of packages drawing from multiple data sources. My development and production environments…
Maff
- 54
- 4
1
vote
1 answer
Can the same SSIS ETL Product (Package) work for SSIS for SQL Server 2014 and 2016?
We're building an ETL Product in SSIS. A lot of our SSIS packages have script tasks written in C# script with assembly references to Microsoft.SqlServer.ScriptTask, Microsoft.SqlServer.ManagedDTS etc.
Some of our customers may be using an older…
Ash
- 241
- 4
- 15
1
vote
1 answer
Modifying a copy of an existing project and deploying that project updates the original project as well Visual Studio
I have a SSIS project which I want to copy the existing code, forms, etc. from which is present in the project and simply make some adjustments to the existing code within. This is in order to adjust the code for another customer.
However, copying…
Cenderze
- 1,202
- 5
- 33
- 56
1
vote
0 answers
Can't use OData with SQL Server 2016 (DTExec 13)
I've build a simple package that extract data from an OData source.
It work with DTExec 12 (SQL Server 2014) but when I deploy to an SQL Server 2016 (DTExec 13) I got a weird error in french :
La connexion « Connexion » est introuvable. Vérifier…
JPB
- 255
- 1
- 5
- 16
1
vote
0 answers
Script Tasks losing code in SSIS 2016 (VSTA 2015)
I have an SSIS package with a number of For Each ADO Loops, each with a single script task, which are usually working fine.
However, every so often, the script task will suddenly 'forget' all the code in task. I'm presented with an empty task…
Kevnotec
- 61
- 5
1
vote
1 answer
SSIS: Dynamic Lookup Query
I would like to implement the following logic to my Lookup query as an expression:
SELECT ID,
CASE @[User::ConnectionStringID]
WHEN 1 THEN "NE"
WHEN 2 THEN "BALT"
WHEN 3 THEN "NY"
WHEN 4 THEN "PA"
…
Jonathan Porter
- 1,365
- 7
- 34
- 62
1
vote
1 answer
Dtsx designer files showing on *some* SSIS 2016 packages
In the following screenshot, you can see there are 7 SSIS packages with their corresponding .dtsx files. What I'm trying to understand is why 2 of the packages also show a .dtsx.designer file and if that's advantageous in anyway.
Nick Heidke
- 2,787
- 2
- 34
- 58
0
votes
1 answer
Failed to acquire connection after switching from IP address to Server Name
I have an SSIS package that has been running as a job without issues for years, alongside several other jobs.
Recently we changed our subnet IP address - this along with one other job was referencing the SQL Server by IP address so it broke. Which…
rgorr
- 331
- 3
- 18
0
votes
1 answer
Add an unknown number of attachments to html email
I have a SSIS package containing just a script task that sends an email.
The package is fed all the necessary params (To, from, subject, body) and also a param (string) containing a list of filenames, separated by a pipe.
I would like to add those…
Henrov
- 1,610
- 1
- 24
- 52
0
votes
1 answer
Why doesn't user in SSIS database role db_ssisoperator see any projects in the Integration Services Catalog?
I am trying to give a user (AD Group) the ability to list all Integration Services Catalog projects and packages, execute all packages, and read the package logs. I DO NOT want them to be able to upload or modify Integration Services Catalog…
meadek
- 1
- 3
0
votes
1 answer
Best way to transfer data IN BATCHES/BULK from Oracle 19c to SQL Server 2016 using SSIS
We have a legacy process that runs on SSIS 2016 on Windows Server 2016, executes custom queries against databases on remote servers, pulls the results (thousands or sometimes millions of records) and stores them in a local SQL Server database. These…
Ray
- 5
- 2