Integration Services

• Topics

  Started by

  Posts

  Last post

• Simple SSIS to check if file exists, always gets false (no file exits)

  Hi, Newbie here regarding SSIS. I have a package that will check if a file exists in a folder. The …

  hristo1977

  22 replies

  11 years, 7 months ago

  By: Phil Parkin

• extraction of day month and year using SSIS

  HI all i tried to extract day,month and year from a date using SSIS but i have problem in fact i us…

  prepaess

  2 replies

  11 years, 7 months ago

  By: prepaess

• SSDT-BI 2013

  It's finally here (see link). Has anyone started using it? Any comments regarding installation / co…

  Phil Parkin

  2 replies

  11 years, 7 months ago

  By: Koen Verbeeck

• Enviroment Variables as configuration

  I have an enviroment variable I want to be used for all of my ssis packages to configure an OLEDB c…

  dndaughtery

  1 replies

  11 years, 7 months ago

  By: Koen Verbeeck

• Purge and Archive using ssis packages

  Purge and Archive using ssis 2008R2 packages The OLTP DB and Archive DB are of two separate servers…

  jansub07

  6 replies

  11 years, 7 months ago

  By: Jeff Moden

• How are task implemented internally

  I am relatively new to SSIS. I was ask by one of my friend, what is the need of SSIS. I told him th…

  Shadab Shah

  2 replies

  11 years, 7 months ago

  By: Shadab Shah

• SSIS Lookup task failing to build hash table (unable to allocate memory)

  I am having trouble with an SSIS 2008 package, specifically with a Lookup transformation in a Data …

  Simon E Doubt

  2 replies

  11 years, 8 months ago

  By: Simon E Doubt

• assert variable and fail component

  Hello, I want to fail a dataflow/controlflow when an uservariable has a non-zero value. Something …

  Jo Pattyn

  2 replies

  11 years, 8 months ago

  By: Jo Pattyn

• SSIS error: To run a SSIS package outside of SQL Server Data Tools you must install Set Configuration of Integration Services or higher.

  I exported a working package from sql server integration services (Sql server 2012) to my local, ed…

  ForumUser3

  3 replies

  11 years, 8 months ago

  By: PurpleLady

• load a file into multiple databases table

  i am very new to ssis and wondering using foreach loop and inside of it data flow task can load the…

  ihpk74

  12 replies

  11 years, 8 months ago

  By: Lempster

• Applying script using a DLL applying DTS reference

  GIVEN: I am looking into updating multiple SSIS packages in SQL Server 2008 R2 that include script …

  grantbanjo

  1 replies

  11 years, 8 months ago

  By: grantbanjo

• Execute Process Task inside a ForEach File Container for unzipping zip files - help please

  I'd like to put an Execute Process Task inside a ForEach File container, so that if there is more t…

  KoldCoffee

  3 replies

  11 years, 8 months ago

  By: Eirikur Eiriksson

• Having trouble creating a folder in SSIS Catalog

  I encountered a rather perplexing problem at work and would like see if anyone has an answer. The …

  hjackson67 52048

  1 replies

  11 years, 8 months ago

  By: Eirikur Eiriksson

• Loading 7 millions of data into minutes..how is it possible?

  Here I have one challenge to load 7 millions of data from temporary table to Fact table followed wi…

  Abhijit More

  10 replies

  11 years, 8 months ago

  By: MMartin1

• SSIS looping trough sysobjects

  I got so for the table names inside of a ForEach Loop Container bit after that I need the variable(…

  nviggiani 99687

  11 replies

  11 years, 8 months ago

  By: SQLRNNR