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
3
votes
2 answers

C# alternative to a bunch of else if statements based on hierarchy

I apologize for the vague title but I wasn't really sure the best way to describe it. I am writing a C# transform script in SSIS. The goal is to take in 5 values which are decimals, and I need to receive the first value out of 5 that is not null, in…
user3494110
  • 417
  • 2
  • 9
  • 25
3
votes
2 answers

Assembly redirect not working for SSIS script task

We've a requirement where some SSIS packages need to run on multiple SQL Server versions (2014 and 2016), without us having to maintain 2 versions of the code base. I've built a wrapper C# console app which has assembly redirects (listed below) in…
Ash
  • 241
  • 4
  • 15
3
votes
3 answers

How can I delete the columns in DataFlow Task in SSIS?

I use SQL Server 2016 and I have a very busy DataFlow task. In my DataFlow task, I use Multicast component for some reason. After creating a new Flow in my DataFlow, I need to delete some of the columns in the new flow because they are useless. …
Ardalan Shahgholi
  • 11,967
  • 21
  • 108
  • 144
2
votes
2 answers

SSIS Lookup Transform use Table or Query

I have a Lookup Transformation on a table with 30 columns but I only am using two columns: ID column for the join and Update column as Output. On the connection should I enter a query Select ID, Update From T1 or Use Table in the drop down? Using…
Roger Clerkwell
  • 406
  • 4
  • 19
2
votes
1 answer

Convert mmddyy to YYYY-MM-DD in expression task in SSIS

I'm trying to use the below code to convert data from '010118' to '2018-01-01' (DT_DATE)(RIGHT(DATE,2) + LEFT(DATE,2) + SUBSTRING(DATE,3,2)) When I run this in SSIS i'm getting conversion error An error occurred while attempting to perform a…
Gowtham Ramamoorthy
  • 896
  • 4
  • 15
  • 36
2
votes
2 answers

how to capture timestamp with milliseconds in ssis package 2016

How to capture current timestamp in ssis package 2016 I declared a variable and using expression but milliseconds are missing @currenttimestamp = (DT_WSTR,50)(DT_DBTIMESTAMP)@[System::StartTime] I want the milliseconds too Thanks
SQL006
  • 439
  • 6
  • 21
2
votes
1 answer

Script to run to list the Connection Manager used by each control

Background Migrating from SSIS2008 to 2016. Using SSDT2015 Question Is there a script or any automation method to quickly list the Connection Managers used by all controls (both in Control Flow and Data Flow) in a project? Currently I'm opening…
Esperanza
  • 115
  • 10
2
votes
2 answers

SSIS OLEDB.12.0 issue on SQL server2016/visual studio 2015

I face a problem about SSIS to import an Excel file. It works when I use a Visual studio 2015 to develop and run SSIS with AccessDatabaseEngine(32-bit). It also works when I use Task-->import on SQL Server 2016 and select excel 2007-2010(xlsx) with…
alice
  • 85
  • 1
  • 9
2
votes
1 answer

Microsoft SSIS Connectors by Attunity Version 4.0 NOT showing on Visual Studio 2015

In one of our company meetings with Microsoft we were advised to use Microsoft SSIS Connectors by Attunity Version 4.0 if we extract data from Oracle. We used to extract the data from Oracle using Oracle Provider for OLE DB. I have tried to install…
Victor Barajas
  • 193
  • 1
  • 9
2
votes
1 answer

What is the use of SQL Server Integration Services Server in SQL Server 2016?

In SQL Server there is a separate Server we install for SSIS but when we deploy a project it goes to SQL Server Database engine (Integration Services Catalogs, SSISDB). What is the use of this Integration Services here? I'm new to this and couldn't…
kapz
  • 437
  • 1
  • 7
  • 15
2
votes
2 answers

Basic Approach to Diagnostic Logging in SSIS

Given help from this microsoft link, I am aware of many tools related to SSIS diagnostics: Event Handlers (in particular, "OnError") Error Outputs Operations Reports SSISDB Views Logging Debug Dump Files I just want to know what is the basic, "go…
Brent Arias
  • 29,277
  • 40
  • 133
  • 234
2
votes
5 answers

SSIS script task fail version 15.0 script?

I have a 2012 SSIS project that runs on SQL Server 2016. I have SSDT 2015 on both my dev machine and server. Everything works fine except for script tasks - I made a change to an existing script task and rebuilt and redeployed the project and I…
JD84212
  • 65
  • 1
  • 5
1
vote
1 answer

Empty connection managers when deploying SSIS packages unless converted to Package Connections

This is my first time starting from scratch with the "new" SSIS Integration Services Catalogs introduced in SQL 2012. I've developed packages with this new model for years but never set up my own environment. I have packages that work in Visual…
jdids
  • 561
  • 1
  • 7
  • 22
1
vote
2 answers

Data Conversion text to numeric in SSIS is removing characters

I am facing a strange issue while using SSIS "Data Conversion component" to convert string to decimal datatype. I use SSIS 2016. The source data input has values of mixed data types- string, integer, decimal and is defined as varchar in the flat…
Kavya
  • 21
  • 1
  • 4
1
vote
0 answers

Losing data in data flow with raw file

I use Data Flow task with Raw file source and OLE DB Destination (mssql table). I found out that during this load I loose most of the data rows, written in raw file. I used a Row count transformation to look for a raw file number of rows. And I…
Torus20
  • 11
  • 1
1
2
3 4 5 6 7