Integration Services

• Topics

  Started by

  Posts

  Last post

• 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 months ago

  By: BurikkuDeibu

• Keep a lock on flat file destination between dataflow tasks

  Guys, I have a flat file which gets written in three parts (generic header, specific lines, generic…

  aaron.reese

  1 replies

  12 years, 2 months ago

  By: Phil Parkin

• Why should we lock variable before access it in the script task

  Hi everyone, Could you please tell me Why should we lock variable before access it in the script ta…

  sharmili.net

  2 replies

  12 years, 2 months ago

  By: Koen Verbeeck

• Need help with simple ETL strategy with SSIS

  I have the following ETL scenario and I need some suggestions on how to go about it. I have a sourc…

  blasto_max

  5 replies

  12 years, 2 months ago

  By: aaron.reese

• Loop or iterate through resultset or recordset by column, using C# only

  I have a result set like (in SSIS actually) - ID, Name, Address 1,John, Japan 2,Sarah, UK 3,Jeremy…

  blasto_max

  1 replies

  12 years, 2 months ago

  By: Koen Verbeeck

• visual c# - How to get a column with a name from a DataTable ?

  I stored a result set from an sql query into a DataTable. I want to get a DataColumn with a particu…

  blasto_max

  1 replies

  12 years, 2 months ago

  By: Mark Cowne