Integration Services

• Topics

  Started by

  Posts

  Last post

• Dynamically set variable to pass to foreach loop and exec web service inputs

  Hi, I'm a little lost (and new) on where to begin with this. Using SSIS 2008 r2 I've been able to …

  Marcus Farrugia

  1 replies

  10 years, 11 months ago

  By: Martin Schoombee

• Oracle.Oledb provider returning improper out-put

  Dear All, Need your help in below issue. I have SSIS package which pull data from Oracle to SQL Ser…

  Sushant Yadav

  8 replies

  10 years, 11 months ago

  By: Koen Verbeeck

• Importing Excel data, with more than 255 Characters

  Hi All, I'm hoping someone might be able to point me to a solution in regards to importing data fro…

  Thom A

  1 replies

  10 years, 11 months ago

  By: Eirikur Eiriksson

• generate multiple excels

  Hello everyone, I'm new in SSIS a i have problem with generate multiple excels, i have 400 location…

  lukasz8519

  5 replies

  10 years, 11 months ago

  By: lukasz8519

• Loading to table with clustered PK / Order by in source

  Here's a question which I feel like I should know the answer to. If I'm using SSIS to load a table …

  Phil Parkin

  3 replies

  10 years, 11 months ago

  By: Phil Parkin

• Package running from BIDS but not from Utility

  Hello, I have a package that uses Script task to refresh excel files in a shared folder. The creden…

  Knowledge Hunter

  1 replies

  10 years, 11 months ago

  By: Phil Parkin

• How to log the source count , inserted count and updated count in to log table

  Hi , I am working on SSIS package where I have to implement logging for records count. In my packag…

  vipin_jha123

  3 replies

  10 years, 11 months ago

  By: Phil Parkin

• Passing Multiple parameters in DTSX in bat.

  Hello: I am trying to pass two parameters. The following command works fine but when I add an other…

  zahid_mian

  3 replies

  10 years, 11 months ago

  By: Martin Schoombee

• Using SSIS Transfer Job Task

  hi , i use Transfer Job Task to copy jobs from one server to other. ( prinicipal to mirror) the …

  sharon-472085

  1 replies

  10 years, 11 months ago

  By: Phil Parkin

• Passing ssis variables from one task to the next.

  I am creating an SSIS Package which has a for each loop container. Inside the container are 2 task…

  paulze2000

  6 replies

  10 years, 11 months ago

  By: Koen Verbeeck

• Logging in SSIS 2012

  Hi , I have been given one task to redesign the existing SSIS Package. In that SSIS package I woul…

  vipin_jha123

  1 replies

  10 years, 11 months ago

  By: Koen Verbeeck

• Convert GETDATE() to DATETIMEOFFSET(0) within the Data Flow

  Hi All, If any one has any ideas on converting GETDATE() to a DATETIMEOFFSET(0) within the Data Flo…

  aarionsql

  6 replies

  10 years, 12 months ago

  By: Phil Parkin

• Issue in Microsoft BI connector 1.1 - Parrell processing for OHS

  In my project Using SSIS to connect the SAP BW 7.31 objects. Goal is, I need to raise the reque…

  pgk1983

  1 replies

  10 years, 12 months ago

  By: nmccormick

• Moving data from SQl Server to IBM AS400

  I am having a problem moving data from an OLE DB source (Sql Server 2012) to a ODBC Destination (IB…

  paulze2000

  3 replies

  10 years, 12 months ago

  By: paulze2000

• How does SSIS lock source tables

  Hi All, I'm writing a package to move the bulk of a table from one server to another, which amounts…

  Xedni

  2 replies

  10 years, 12 months ago

  By: Koen Verbeeck