Integration Services

• Topics

  Started by

  Posts

  Last post

• for each variable getting unset

  So, inside a for each loop, I have various things that I am doing from an result set. First off I g…

  Sailor

  3 replies

  8 years ago

  By: Sailor

• opening a rowset failed

  hi i have ssis package , loading data from excel file into sql server table.package is working fine…

  coool_sweet

  7 replies

  8 years ago

  By: Phil Parkin

• SSIS on a cluster.

  Hello, I am running a 2 node Active/Active SQL 2008 Ent R2 cluster, I am looking at putting SSIS on…

  Duran

  12 replies

  8 years ago

  By: farooq.md

• Execute SQLs in Parallel using SSIS

  Hello, I have a unique situation where i need to execute all the SQLs sitting in the directory on s…

  nic2885

  12 replies

  8 years ago

  By: nic2885

• 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

  8 years, 1 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

  8 years, 1 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

  8 years, 1 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

  8 years, 1 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

  8 years, 1 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

  8 years, 1 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

  8 years, 1 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

  8 years, 1 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, 1 months 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, 1 months 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, 2 months ago

  By: DamianC