Integration Services

• Topics

  Started by

  Posts

  Last post

• Help with Date in SSIS

  Hi all the clever people I have set up the following three variables that I want to use in a for lo…

  frdrckmitchell7

  6 replies

  12 years, 4 months ago

  By: frdrckmitchell7

• merge join

  I would like to create a teacher extract file. The teacher table is in Oralce database. it has teac…

  sqlfriend

  1 replies

  12 years, 4 months ago

  By: Tee Time

• Convert 'select getdate()' to a string in SSIS ?

  I am not able to convert SSIS get date to sql server datetime format. I saw some error which i don'…

  blasto_max

  6 replies

  12 years, 4 months ago

  By: Umer Akram

• Convert SSIS datetime to sql server 2005 datetime ?

  I want to convert SSIS datetime obtained by getdate function into a database datetime variable. How…

  blasto_max

  2 replies

  12 years, 4 months ago

  By: Raunak Jhawar

• Script task inside a For Each loop - writing to a file

  My script task is inside a for each loop. I want the script task to write some dynamic string to on…

  blasto_max

  1 replies

  12 years, 4 months ago

  By: Phil Parkin

• Apostrophes ' inside a SQL table called through script task

  Hi all How can I escape the apostrophes when I am using the variables inside a .net script? See bel…

  pnr8uk

  11 replies

  12 years, 4 months ago

  By: Phil Parkin

• ForEach Variable Mapping cannot be applied.

  Hi, i'm usting Dataflow task where i used OLEDB source to select data from the sql server the query…

  Nomvula

  1 replies

  12 years, 4 months ago

  By: Phil Parkin

• Processing large amounts of data in SSIS ?

  I have a huge result set from SQL, 2-3 million rows which need to be "processed". Is there anyway I…

  blasto_max

  12 replies

  12 years, 4 months ago

  By: corey lawson

• How to get the time taken by an ETL job and status- success or failure ?

  How do I get the time taken by an ETL job and status of a job, ie success or failure ?

  blasto_max

  8 replies

  12 years, 4 months ago

  By: Phil Parkin

• Appending values from second row to first row

  I have .csv source file that looks like this: Type,ColA,ColB Test,ValueA,ValueB Test,ValueA,ValueB …

  MattieMich7

  6 replies

  12 years, 4 months ago

  By: Phil Parkin

• help with expression builder in SSIS 2008

  Hello there,, i got a variable which is an Expression. my expression is this: '||'''DateVar'''||' i…

  avishain

  5 replies

  12 years, 4 months ago

  By: Koen Verbeeck

• here was an error with output column on output "OLE DB Source Output The column status returned was: "The value could not be converted because of a potential loss of data."

  I have stored procedure that creates a dynamic SQL command to run another stored procedure that has…

  Phillip.Putzback

  4 replies

  12 years, 4 months ago

  By: Phillip.Putzback

• Connection String Expression Syntax

  I'm building a SSIS job using a foreach loop to import several MS Access files. I have the Enumer…

  dan-572483

  2 replies

  12 years, 4 months ago

  By: dan-572483

• SSIS package configurations

  Hi all, We've got numerous 2008 SSIS packages all using the same DB for storing package configurati…

  davewall_london

  4 replies

  12 years, 4 months ago

  By: davewall_london

• Data Flow Task Reporting OLE DB Error 0x80040E0C

  I have a data flow task, which should update records in one environment (in this case, UAT) from re…

  BurikkuDeibu

  1 replies

  12 years, 4 months ago

  By: BurikkuDeibu