The users will be accessing thru citirx server.

Is it possible to set different file name for different users so that all users will have there own file.

Thanks Sharma!!

Actually iam exporting data from SQL server to spreadsheet using copy task and then running the DTS using batch file.

It gives me the error "File is opened by another user”...

Can anybody suggest something on this?

Thanks man,i used the temp table to insert the parameters but i still have one issue..

In store procedure i have query like this

Select * from Item where A.RU IN (SELECT...

Ok i tried your idea but this still gives all rows as i want to return userid too

Okay,i got it now.

We can set sheetnames for copytask properties called DestinationObjectName.

thanks Journeyman... for your kind help.

Thanks again Journeyman...looks like iam very close now.

I created two temp tables and another Copy transformation. Now i have two queries and passing separately to copy transformations but it gives same error as its...

Iam not using wizard.I have used some activex task and copy task and so far its exporting to csv file only and then its getting FTP's to remote.

It seems that...

Iam not using wizard.I have used some activex task and copy task and so far its exporting to csv file only and then its getting FTP's to remote.

It seems that...

Journeyman,thanks.

Atleast i can see another sheet in excel file but second sheet is total empty,it gives only first header.

I still get an excel row exceeds error. any idea?

Iam not writing any code for that..Iam just crating two tables using Execute SQL task before running the copy task.

This is still not working...

Is there any other process?

I am sorry its more then 10,0000.

Thanks Osoba  for your reply.I am already creating a table called Export_sheet for the original spreadsheet

and then as u suggested i...