Integration Services

• Topics

  Started by

  Posts

  Last post

• Cannot load into table having identity column - INSERT fails

  Very odd behavior in BIDS 2010. Why is SSIS changing removing the IDENTITY property of the destina…

  polkadot

  9 replies

  12 years ago

  By: polkadot

• General ETL question - ETL from unknown number of tables ?

  AFAIK, ETL integrates data from a fixed number of sources/tables. Is it possible that ETL can integ…

  blasto_max

  8 replies

  12 years ago

  By: SQL Padawan

• Data Flow Transformation Performance Issue

  Hi, I am using a Data flow transformation for loading data from sql store procedure. which consist …

  harsimranjeetsinghwasson

  5 replies

  12 years ago

  By: Nevyn

• SSIS is hanging.

  I have a package in SSIS 2008. It is taking data from one database and transforming it to another d…

  mz1derful

  3 replies

  12 years ago

  By: mz1derful

• Exception Handling in script task in SSIS ?

  I get exceptions in my C# script task. Does SSIS point to the exact line which caused it ? If not, …

  blasto_max

  3 replies

  12 years ago

  By: blasto_max

• Flat File Source and Flat File Destination & Convert Dates to text mm/dd/yyyy

  I'm getting a flat file from an AS400 Vendor with no column headers. The Date Columns are in a Date…

  Welsh Corgi

  8 replies

  12 years ago

  By: Welsh Corgi

• Want to update the table performance vice which transformation is best to use

  Hi Everyone, I want to update the table in a database, performance vice which transformation is bes…

  sharmili.net

  10 replies

  12 years ago

  By: Koen Verbeeck

• Error in open Query in DB2 linked server

  Hello, We have set up a linked server for DB2 with name BID, when we try to run a open quer…

  sam.jhonny15

  5 replies

  12 years ago

  By: corey lawson

• Store SQL server varchar max in SSIS string

  What i am doing - Get single row result set from execute sql task (EST) via oledb connection (OLE)…

  blasto_max

  1 replies

  12 years ago

  By: Koen Verbeeck

• How to check for number of rows in recordset using constraint?

  I have an execute SQL task which is connected to a script. The SQL initializes variables to be used…

  blasto_max

  3 replies

  12 years ago

  By: Lempster

• SSIS Excel Source makes Visual Studio unresponsive

  I've found that using an Excel Source in the Data Flow of an SSIS package makes Visual Studio desig…

  kinzleb

  13 replies

  12 years ago

  By: Evil Kraig F

• Flat File connection not fixed width but the row length is !!

  Bit of a bonkers file, but has a fixed number of columns in the file. All columns are ok and are de…

  Ells

  3 replies

  12 years ago

  By: Ells

• SSIS Exchange Web Services - Could not load file or assembly

  Hi I'm trying to write a Source component in a dataflow task to recover some details from Exchange.…

  MikeLPlates

  3 replies

  12 years ago

  By: msafarali

• How to loop through a recordset or resultset multiple times using SCRIPT TASK only

  I want to loop through the same recordset or resultset multiple times using a C# script. How do I …

  blasto_max

  2 replies

  12 years ago

  By: blasto_max

• Simultaneous loading using ssis

  hi, i am Kannan. i need tmplate for loading flat files into staging as well as historical simultane…

  Kannan Vignesh

  5 replies

  12 years ago

  By: sneumersky