Integration Services

• Topics

  Started by

  Posts

  Last post

• Sending Email using Script Task

  I have a problem which seems quite common. I would like to be able to send emails for error alerts …

  kingdonshel

  1 replies

  9 years, 10 months ago

  By: urmainpriority

• Need help to execute a Oracle stored procedure from execute sql task

  Hi, what is happening now with ETL ------------------------------------ I have a SSIS package which…

  prabhu.st

  4 replies

  9 years, 10 months ago

  By: prabhu.st

• SSIS Dynamic dataflow source from foreachloop object variable.

  Hi guys, I am after some much need advise with how to insert data from one instance database into a…

  acrutchley

  1 replies

  9 years, 10 months ago

  By: John Mitchell-245523

• Foreachloop continue inspite of server connectivity issues in SSIS package.

  How do I build an SSIS package which will have a dataflow task within a foreachloop container. The …

  mtz676

  3 replies

  9 years, 10 months ago

  By: Phil Parkin

• SSIS flat file source columns change

  I'd like to know if an SSIS package can accommodate a source that will vary in the number of column…

  inevercheckthis2002

  1 replies

  9 years, 10 months ago

  By: Phil Parkin

• Populating Surrogate Keys

  I am fairly new to BI and SSIS, but am currently working on putting together a data warehouse. I ha…

  SilhouetteBS

  1 replies

  9 years, 10 months ago

  By: Phil Parkin

• SS Data Tools GUI question

  Using SSQL Server Data Tools for SQL 2012, one of my Data Flows got "moved" to the bottom of a huge…

  dan-572483

  1 replies

  9 years, 10 months ago

  By: Phil Parkin

• SSIS 2008 Key not valid Error

  This one is confusing me a bit. We have a 2008 SSIS package that has been running fine until yester…

  Brandie Tarvin

  1 replies

  9 years, 10 months ago

  By: Phil Parkin

• Integration Services Catalogs remote execution

  Hi, I have created into my SERVER1 a SSIS package (into a Integration Services Catalogs), this pack…

  vincenzo_capelli

  5 replies

  9 years, 10 months ago

  By: Phil Parkin

• Accessing an ODBC Managed Connection in a Script Task

  Hi guys I'm using an ODBC driver to access a proprietary file type database (having multiple files)…

  danghita74

  3 replies

  9 years, 10 months ago

  By: Phil Parkin

• Facebook data with SSIS

  Hi, Did anyone ever tried to import facebook data to SQL with SSIS? I know that I have to use API.…

  Borut Olenik

  5 replies

  9 years, 10 months ago

  By: rpdouglas

• Exception when using third party dll files in a script task

  Hello all I work at a company, which deploys its products on its customers systems. I was asked to…

  scohn 53313

  3 replies

  9 years, 10 months ago

  By: Phil Parkin

• Users execute ssis 2008 package

  I am new to creating SSIS 2008 packages. What I want to do is to create a simple SSIS package and h…

  wendy elizabeth

  2 replies

  9 years, 10 months ago

  By: wendy elizabeth

• Need to pass in an ssis variable with sqlcommand into Attunity Oracle Source

  Hey guys, can someone point me in the right direction on how to create a sql command in an ssis var…

  dndaughtery

  3 replies

  9 years, 10 months ago

  By: Orlando Colamatteo

• hide source code in SSIS

  Hi I have few SSIS package which are called from UI application.In order to run these SSIS packages…

  sunnyepgc

  3 replies

  9 years, 10 months ago

  By: John Mitchell-245523