Integration Services

• Topics

  Started by

  Posts

  Last post

• How do I code a three-level table name in SSDT that will honour environment settings in deployed job?

  Hi, Say I have these databases on my server: Extract_DevExtract_ProdTransform_DevTransform_ProdLoad…

  Scott In Sydney

  13 replies

  7 years, 11 months ago

  By: Scott In Sydney

• SSIS- execute sql task - Excel connection - query error

  Hello, I am using Execute SQL task in SSIS, I am passing variable as input parameter and executing …

  nic2885

  2 replies

  7 years, 11 months ago

  By: Phil Parkin

• This error is thrown by Connections collection when the specific connection element is not found

  Hello guys, This is my first post in the forum, i'm faily new at SSIS and i've made my first packag…

  Alejandro Santana

  2 replies

  7 years, 11 months ago

  By: Alejandro Santana

• SCDs for Staging DB or Table Copy?

  Hi All I'm looking for some advice on getting data into our STAGING Data Warehouse Database. At the…

  MattieG72

  4 replies

  7 years, 11 months ago

  By: MattieG72

• SSIS returns the same identity each time table is truncated and Inserted with the same identity values

  Hi,I have a situation like I have to insert the records from one source to destination table which …

  ammit.it2006

  5 replies

  7 years, 11 months ago

  By: ammit.it2006

• Taking huge time while .loading data from one db to another db table

  Hi , I am trying to load one tables data from X database to  Y database in target table . I do…

  vipin_jha123

  1 replies

  7 years, 11 months ago

  By: Jo Pattyn

• Microsoft.SqlServer.Dts.Pipeline.CannotCreateUserComponentException

  My SSDT job is: OLEDB Source Table:  SQL Command, Left Join on Two Tables.  Preview works…

  Scott In Sydney

  1 replies

  7 years, 11 months ago

  By: Scott In Sydney

• SSIS Package (File System-Based) Has Changed But SQL Server Agent Job Still Running Old / Cached DTSX Code Apparently?

  I periodically do some work on an SSIS pkg. or two that I designed for a client several years ago. …

  brad.mccollum

  3 replies

  7 years, 12 months ago

  By: Sue_H

• Export to multiple Workbooks with multiple worksheets

  Hi I have a query related to exporting to Excel workbooks in SSIS. I've read the two articles below…

  ByronOne

  2 replies

  8 years ago

  By: ByronOne

• Can't read the formula =NA() from Excel into SSIS

  Hi, I got an Excel sheet where I am trying to read a column where nearly all cells have the formula…

  Diske

  2 replies

  8 years ago

  By: Thom A

• Auditing dynamically changing connections

  Hello Using SQL 2008R2 I work in a dev->test->prod environmentI have a packageIn this package…

  DamianC

  2 replies

  8 years ago

  By: DamianC

• SSIS : Create C# Script that creates an excel file.

  Dear all, I have created a script task 1) connects to a txt file - sucessfully 2) Reads …

  river1

  3 replies

  8 years ago

  By: tim.ffitch 25252

• Design Input for ETL of OLTP Database

  Hello All -  I wasn't sure exactly where my question fit, so thought i'd put it here first.&nb…

  Polymorphist

  9 replies

  8 years ago

  By: SQLCrook

• Nested IFs in Derived column transformation

  I'm not sure how to go about this.  I have a series of dates that are strings in the input (mo…

  karen.ferrara

  1 replies

  8 years ago

  By: Phil Parkin

• Error message from SSIS Package

  Hi all Every so often we get an error on one of our SSIS packages that refreshes our cubes.The only…

  richardmgreen1

  1 replies

  8 years ago

  By: Martin Schoombee