This works but if i have multiple files and the transformation runs for each file then if i use global variable th last records is selected. I am trying to have...

Exactly Russel. You are right. I need the servrname to be inserted into servername column , same with domain name also. I dont need the timestamp colum,n though. Do you...

Thanks for the response. I am able to set up a job to run the DTS package. I tried all 3 cases of selecting the DTs, FileSystem, SQL Server, Package Store but...

Thanks for all your help.

Thanks RGR'us

Just wanna make sure if @custom_value is not 'D' but some other value i need to check for AL1.quantity between Threshold_value1 and @threshold_value2 . From what you wrote...

SELECT col1, col2, col3, col4, col5, AL1.amount, AL1.quantity

from tab , tab2 AL1

WHERE tab.id = AL1.id

and name like '%bnb%'

and id = 100

AND CASE

WHEN @custom_value='D' then

(AL1.amount between @threshold_value1 and @threshold_value2)

ELSE

(AL1.quantity between @threshold_value1 and...

I got it working using the following

select * from openquery(linkservername,'select * from dbo.view').

Thanks

Thanks for the link that really helped I am able to set up the linked server successfully and i can see the oracle view from sql server enterprise manager. However...

I have oracle client installed locally on the server from where i am trying to connect to Oracle. Now when trying to set up the linked server I am not...

Unfortunately my tables doesnt have an identity col so i trying to set up rowcount but that doesnt seem to work. Anythoughts or ideas.

Thanks

Sorry but i cant truncate the log when thsi needs to be run in a prodn environment. Also I was looking if someone has written a code for this before.

TIA

Are you using sql 2005? somehow its doesnt work in sql 2000 as these system tables dont exists there.

TIA

Thanks.

RGR'us - What i am trying to do is in a DTS pckg if an index exists for a table on a specific column first "drop it" do the data...

Is that something that could be done from the back end or you are saying to have the counter at front end side? Can you please clarify. TIA

Thanks I am using sql 2000 only and you are right i couldnt see any other way other than usinga temp tablle with an identity col.

TIA