Stack Overflow
Stack Overflow

Questions tagged [ssis-2016]

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

96 questions
0
votes
1 answer

SSIS multiple flow constraints re-joining to a single executable not continuing

Firstly, I am new to SSIS and not sure of what format to explain the problem in a repeatable way for testing So I have a task that loops through a folder looking for flat files and if in the correct format loads them into a SQL server staging table.…
Ian W
  • 385
  • 2
  • 10
  • 30
0
votes
1 answer

In SSIS script task not getting execute when it is deployed as an single package

I have an SSIS package in which I am using script tasks. Sometimes after making changes to this package and deploying it as a single package, I find that the package runs without error but doesn't actually execute the script task. If I deploy the…
user3557922
  • 9
  • 3
0
votes
0 answers

Unable to deploy the SSIS Package into SQL Server 2016

Currently SSIS package 2012 is working fine in SQL server 2012 so we have migrated the objects into SQL server 2016 and the same package also converted into 2016 and deploying into SQL server 2016 but faced below error. Batch File - We dont have…
Youth Icon
  • 1
0
votes
0 answers

Unable to trigger the SSIS packages from MSDB in SQL Server

Currently, the SSIS 2012 package is deployed in MSDB on SQL Server 2012, and it's working fine. We have migrated the same packages in MSDB to SQL Server 2016 through batch utility, after created the SQL Server job & mapping the "Master" package…
Youth Icon
  • 1
0
votes
0 answers

SSIS : DT_DECIMAL can accept null?

We input data from CSV file and sometimes decimal columns can be null. SSIS DT_DECIMAL or DT_NUMERIC seems not to be accepted null, got -1071607689, DTS_E_OLEDBDESTINATIONADAPTERSTATIC_CANTCONVERTVALUE error. May I ask we need to use DT_STR column…
Sachiko
  • 808
  • 1
  • 12
  • 31
0
votes
0 answers

2016 SSIS Package- Duplicate connections

We have noticed the SSIS packages has created duplicate connections in the package , not sure when we open the solution the package was trying to connect to the server credentials and unavailable due to the passwords and had created a duplicate…
user15014142
  • 1
0
votes
1 answer

SSIS ForEach Loop Container only processing one row

I have a simple job that grabs Employee IDs and sends them to an API call, which only accepts one Employee ID at a time. I have this setup using a ForEach Loop Container being fed by an Execute SQL Task. The job runs as expected, but it is only…
jdids
  • 561
  • 1
  • 7
  • 22
0
votes
0 answers

Confused with SSIS ForEach Loop

I'm looking for some help with getting started with the SSIS For Each Loop. I have a process that calls an API based on an ID. It can only make one API call per ID. What I'm looking to do is query a set of IDs, have the ForEach Loop through each…
jdids
  • 561
  • 1
  • 7
  • 22
0
votes
1 answer

Unexpected Termination when loading data from excel using ssis

I have SSIS package which simply loads data from excel using microsoft.ace.oledb. 12.0 driver to a sql server table. The excel file size is 4.5mb It is running fine locally. When I delploy and run using Sql Server Agent in development enviroment,…
Vlogs Bengali
  • 85
  • 1
  • 13
0
votes
0 answers

How to read the sensitive parameter value in SSIS script task?

In my SSIS package, I need to use a password parameter and I would like to keep it as sensitive. Is there a way to read this sensitive parameter value in the script task? I tried to use the GetSensitiveValue() method as in this link but it always…
Ashan
  • 13
  • 5
0
votes
1 answer

How to convert string which is output of select .....from for JSON AUTO to JSON Formatted file which is readable without using third party tool SSIS

HI I am writing SSIS package to get the output from Select a,b,c from CUST FOR JSON AUTO However I am getting output in a single row like {"a":"Rock" ,"b":"paper" ,"c":"scissors"}, {"a":"Rock" ,"b":"paper" ,"c":"scissors"}, {"a":"Rock"…
hrishi
  • 1,531
  • 8
  • 28
  • 43
0
votes
2 answers

Convert DDMMYY to DD-MM-YY in SSIS Derived Column

I am facing issue while placing "-" in a varchar datatype. . Need is after last two digits we need to put "-" and then again after two digits and so on. Input String is- 21220 Output String- 2-12-20 Or, Input String- 311220 Output String-…
Bibhudatta Hotta
  • 1
  • 1
0
votes
0 answers

Will the order of the data be retained from OLE DB Source to OLE DB Destination?

In an SSIS package, I have a data flow task that contains an OLE DB Source and an OLE DB Destination. The OLE DB Source is set to SQL command and has a query similar to the following: SELECT * FROM SomeTable ORDER BY Col1, Col2 Will the insertion…
Kevin Ganancial
  • 37
  • 7
0
votes
0 answers

upgrading ssis 2008 c# architecture to 2016 for azure

i m trying to upgrade ssis 2008 packages with c# architecture (screenshot joined), to ssis 2016 for moving to the cloud, i ve seen similar questions but the few answers there are do not apply when i try them, especially not this link:…
osm2
  • 37
  • 1
  • 9
0
votes
1 answer

SQL Server 2016 using SQL Authentication deploy SSIS package in MSDB by using powershell

I am using the following code to deploy the SSIS package using windows authentication in SQL Server 2016. When I tried to run it under SQL Authentication it always gives the following error. And the user account which I am trying to use having…
Vipin
  • 938
  • 5
  • 18
  • 36
1 2 3 4
5
6 7