Integration Services

• Topics

  Started by

  Posts

  Last post

• how to capture the error value when Execute Process Task batch job fails?

  Hello, I'm using SSIS Execute Process Task to issue a 'reload file' command on a QlikView qvw.file …

  KoldCoffee

  2 replies

  11 years, 6 months ago

  By: KoldCoffee

• How to store multiple row values to different variables-SSIS

  Hi, My query and result is as shown below. Query:Select Column1 from tableA Result: Column1 a b c m…

  subramani.rudrappa 78855

  2 replies

  11 years, 6 months ago

  By: subramani.rudrappa 78855

• SSIS 2012 Problem with Oracle when run at Server via SSISDB

  Dear all, I do SSIS to get data from oracle to MSSQL by using Oracle provider for OLE DB follow st…

  waralees

  5 replies

  11 years, 7 months ago

  By: Nevyn

• How to get execution response from DTEXEC command line?

  Hi all, I'm looking to run the SSIS package using DTEXEC command line. I would need to get the exec…

  shafirmubarak

  3 replies

  11 years, 7 months ago

  By: Evil Kraig F

• One SSIS Project or Several?

  We want to create several SSIS packages that load data from various systems into the staging databa…

  imani_technology

  4 replies

  11 years, 7 months ago

  By: JustMarie

• Error code: 0x80040E21.

  Hi all, I am having .csv as my source which contains millions of records. almost 400000 records are…

  abhas

  1 replies

  11 years, 7 months ago

  By: viresh29

• Continuous hours of missing data

  Hi, In my ETL feed i need to identify whether the data is missing for continuous 5 hours. What cou…

  Anamika

  4 replies

  11 years, 7 months ago

  By: Koen Verbeeck

• Why we need DQS when we have SSIS ?

  I happen to read about DQS . I have not worked on it . But whatever description MSDN provided about…

  Shadab Shah

  1 replies

  11 years, 7 months ago

  By: Koen Verbeeck

• SSIS: Dynamically Changing file Name

  Hi I am using SQL Server 2008 r2 and I have to achieve blow result in through SSIS, Can any one gi…

  venkat5677

  3 replies

  11 years, 7 months ago

  By: Koen Verbeeck

• Single 1.3TB table, crash when trying to built fulltext index

  Hi all, I'm new to this forum, and really need your help. Recently I got a 1.3TB table, has 2.7bill…

  liudi

  2 replies

  11 years, 7 months ago

  By: liudi

• Why am I having to change the connection in the package whenits using a config

  I have a package where I have configurations setting the connection managers info. The thing I've n…

  dndaughtery

  2 replies

  11 years, 7 months ago

  By: dndaughtery

• Integration Service Dashboard & Row Counts

  I recently learned that SQL Server 2012/SSIS 2012 has a feature called the Integration Service Dash…

  imani_technology

  7 replies

  11 years, 7 months ago

  By: Koen Verbeeck

• SSIS Strange error when running as SQL Agent

  So I have a package that runs correctly from my local machine in BIDs, but gives the following erro…

  Wesley Middendorff

  12 replies

  11 years, 7 months ago

  By: Koen Verbeeck

• how to import excel sheet with varying no. of columns in ssis

  Hi, I have a requirement to import excel sheet which we receive daily, sometimes it may contain ext…

  ykonline

  1 replies

  11 years, 7 months ago

  By: Eirikur Eiriksson

• Sending Emails with SSIS however have a Script Task Error

  HI, Hope there is someone out there that can help me. I have a package which enables me to take a d…

  Healthdata

  4 replies

  11 years, 7 months ago

  By: Phil Parkin