Integration Services

• Topics

  Started by

  Posts

  Last post

• Execute Stored Procedure with Parameter Via SSIS

  Hi all I am not sure if I am doing this right and would love to have some help / suggestions with …

  vani_r14

  6 replies

  15 years ago

  By: vani_r14

• What is Data Integration?

  Data integration involves combining data residing in different sources and providing users with a u…

  mexia.john72

  1 replies

  15 years ago

  By: Koen Verbeeck

• Creating a sql query through variables and parameters

  Greetings all, So I have a table ETL that I am using SSIS to manage. In the data Flow I am using a…

  shannonjk

  1 replies

  15 years ago

  By: Koen Verbeeck

• Script task runs on separate thread?

  I can't believe what I'm seeing... but I don't have another explanation for the behavior. =========…

  eric.johnson 33562

  7 replies

  15 years ago

  By: Koen Verbeeck

• Analysis Services task

  Hi all, I have a DTS 2000 package for processing cubes which uses Analysis Processing task. I need …

  vick12

  7 replies

  15 years ago

  By: Koen Verbeeck

• Calling SSIS package located on a 2008 server from Agent on 2005 server

  We have just implemented a dedicated SSIS server on SQL 2008 R2 that only runs SSIS. The jobs would…

  TangoVictor

  8 replies

  15 years ago

  By: TangoVictor

• Running child packages simultaneously

  Hi I have a parent package which will be calling a child package. Can the parent package call the c…

  brian118

  3 replies

  15 years ago

  By: brian118

• Error Redirection

  I have been pulling my hair out all day trying to figure this out, perhaps someone here can help me…

  Khades

  5 replies

  15 years ago

  By: Koen Verbeeck

• Changing server name and db name

  Hi, We're in the process of migrating from SQL 2005 to 2008, and we have quite a number of package…

  Layne-812700

  4 replies

  15 years ago

  By: Orlando Colamatteo

• The connection "Servername" is not found. this error is thrown by connections collection when the specific connection element is not found.

  Hi, I am getting below mentioned error while deploying the package from dev to test. Error: the con…

  naveen.nagareddy

  1 replies

  15 years ago

  By: Koen Verbeeck

• Loading up to 60 optional txt files

  I receive our data extracts in .zip format. They are then un-compressed to a clean \working directo…

  BobMcC

  5 replies

  15 years ago

  By: Alvin Ramard

• Manually rollback all child packages if any fails

  Hi, I'm loading tables (1 package per table, managed by a parent package) and need to be able to ro…

  sam.dahl

  11 replies

  15 years ago

  By: sam.dahl

• Derived Column

  :angry::sick: I have a derived column transformation. The input values are Intergers, but I need th…

  Khades

  4 replies

  15 years ago

  By: Khades

• connecting to oracle data source

  Hi all, I just wanted to know how to connect to a oracle data source from SSIS 2008. I am having co…

  vick12

  1 replies

  15 years ago

  By: Koen Verbeeck

• Package stops executing but does not report

  I am having an issue with a 2008R2 SSIS package the loads a Datamart. The packages are nested, as …

  michael.french 172

  9 replies

  15 years ago

  By: michael.french 172