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
1
vote
1 answer

WebRequest A connection that was expected to be kept alive was closed by the server

using a Webrequest within a script task to consume a Rest Service I get the following error A connection that was expected to be kept alive was closed by the server I'm calling the rest service within a For Each Loop container. It works the…
Geezer
  • 513
  • 5
  • 17
1
vote
0 answers

Execute data flow task based on multiple input data flow from Expression Task

Is it possible to execute the data flow task based on multiple Expression task. The expression task contains the source query variable var_srcquery and a dynamic query assigned here at runtime. There is 4 Expression Task all assigning to the same…
SQL006
  • 439
  • 6
  • 21
1
vote
0 answers

Parent package variable configuration not working after migrating package from 2008 to 2016

I have a set of ssis 2008 packages that I need to now migrate to ssis 2016. I used VS data tools 2015 to migrate the packages. Packages got migrated successfully with few warnings regarding the script tasks which I have taken care of. Now one of…
ketaki
  • 11
  • 3
1
vote
0 answers

SSIS Log Provider not working with SQL Server User

I have created a SIS Log Provider to write a log entry from a Script Task in a SSIS package. The connection is working a long as I use Windows Authentication, but if I switch to SQL Server Authentication and provide a username and a password no log…
FRropen
  • 13
  • 3
1
vote
1 answer

SSIS operational configuration of server instance, database, and schema?

In order to enable operational management of data integration processes developed in SSIS, I am seeking to be able to externally configure: server (data source) database (catalog) schema From what I have seen, all of these are typically hardcoded…
lit
  • 14,456
  • 10
  • 65
  • 119
1
vote
0 answers

Capturing Truncation in SSIS flows

I've been working with SSIS 2016 to create some data flows. One of my objectives is to be able to capture any truncation issues and populate an error table highlighting where truncation is occurring. Part of this is due to us importing JSON data and…
BakersCat
  • 33
  • 7
1
vote
0 answers

SQL0206 Column or global variable P1 not found when inserting into DB2 table with SSIS

Using SSIS 2016 data flow and inserting into DB2 table using the latest IBM.Data.DB2.iSeries .net connector. I'm able to preview the data, and SSIS grabs the column from the DB2 table and knows the type. Table was created using: create table…
tvanharp
  • 325
  • 3
  • 11
1
vote
0 answers

Event Handler Send Mail Failing with SocketException

I am working SQL Server 2016 and Visual Studio, but when I deployed my project to the Integration service catalog, SSIS send email task on event handler failed. The error message as below: Error: an error occurred with the following error message:…
JohnCincau
  • 39
  • 2
1
vote
0 answers

SSIS Excel Destination Create Worksheet Work with Variables?

When I hit the "new" button, it starts a create table statement. Is there a way to replace the default table name with a variable?
Chicken Sandwich No Pickles
  • 2,953
  • 8
  • 45
  • 92
1
vote
2 answers

SSIS Storing File Name as a Variable

I am very new to SSIS. Like, less than a month of exp using it new. Here is what I want to do: In the "File name:" section of the File File Connection Manager editor, I want to replace this with a variable. i.e. variable\name_of_file.txt. In the…
Chicken Sandwich No Pickles
  • 2,953
  • 8
  • 45
  • 92
1
vote
1 answer

SSIS Sequence Container not executing each task

I am new to SSIS and am building a package to perform varies File System Tasks. All objects are working as intended with the exception of a group of Foreach Loop Containers that are within a single Sequence Container. The idea is that I want them to…
Matt
  • 71
  • 8
1
vote
1 answer

Unable to load collection for the connection odata source in SSIS

I am using SSIS to connect to Microsoft Dynamics 365(Version 9.0) WebApi to read the data. Below are the details. Control Name / Transformation(Source Component): OData Source OData Connection Manager: Service Document Location:…
bipro
  • 23
  • 7
1
vote
2 answers

SSIS: The For Each File enumerator is empty revisited

This issue was addressed in a prior post, and I have a very similar situation, however it is sufficiently different that a new post is justified. I have an SSIS package with a For Each file loop. In Visual Studio 2017, the package behaves exactly as…
stinkyP
  • 555
  • 6
  • 14
1
vote
3 answers

SSIS - The script task ... use version 15.0 script that is not supported in this release of Integrated service

Hi I'm looking for some guidance. I've developed an SSIS project with a couple of script tasks and script components using visual studio 2015 for targeted version 2016. I have two environment server A and server B both have SSIS 2016 SP1 installed…
Nathan TSQL_Jr
  • 117
  • 1
  • 8
1
vote
2 answers

SSIS- ADODB Recordset Error

I am getting below error while running my ssis package. Error: COM error object information is available. Source: "ADODB.Recordset" error code: 0x800A0BCD Description: "Either BOF or EOF is True, or the current record has been deleted. Requested…
Naveen Kumar
  • 582
  • 2
  • 8
  • 25
1 2
3
4 5 6 7