Thanks LutzM.. I found that we are using stored proc too often with various frequent calls. we have decided to use only default pass parameter for building the color cache...

index definition is there in the create table script.... I am attaching the SQL query execution plans for both conditions..

color has 175000 rows where as colorfamily has 25 rows

USE [ProductCatalog]

GO

/****** Object: Table [dbo].[Color] Script Date: 04/26/2011 14:35:53 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE...

I used the below script and I am not getting clean text.

I want to extract the whole text which a browser would display for my dhtml code. The below...

Phil, this is not possible as I deleted the file also and created new one. I am all clue less about this. If one needs I can send him the...

Thanks Erik,

I wud try to use the script task if active-x script task is going away...

Thanks everyone for replies..

Thanks Vikas... It worked like charm.. I was under impression that if you are passing something to variable that is also a output variable for the execute task query.

Anyways thanks...

Guys,

I tried the MS-Access approach and it seems that this is not going to work all well. When I run query after designing the Link Tables, the query retruns error...

I wanted to do a Data match up between two tables. Think of it just like a VLOOKUP in excel. I will try the Access approach and see what comes...

Have you cross-checked the task flow properties? Sometimes one may unintentionally change the flow properties....

This may be due to TCP /IP load on SQL server connection. You may need to check that your SQL is up and running efficiently. You also have the option...

I think you are trying to say that even if certain statement is not executed successfully; the SQL engine processes the next statement. you can check the return code and...

okiftequar ,

You should try to find out a sql task in your package which is not having any incoming arrow from other Task. Probably it will be your first step...

I think BCP would be more useful in this situation. You can just write those two lines in BCP query to get appended in file. Moreover performance will also...

May be you can pull data from oracle tables to some text file on SQL server or some temp table in SQL server then you can use joins.