DTS for multiple users at the same time

Question

DTS for multiple users at the same time

SQL_Programmer

SSC Veteran

Points: 248
More actions
October 28, 2005 at 11:57 am

#66830

Is it possible to have multiple users to execute DTS package at the same?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

rsharma SSCarpal Tunnel Points: 4865 More actions · Answer 1

That depends upon what the DTS package does - if it is say copying over data from one database table to another and two users execute it, you can run into issues.

But, Yes, multiple users can execute a DTS package at the same time.

SQL_Programmer SSC Veteran Points: 248 More actions · Answer 2

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”

Is it still possible for multiple users to run at the same time?

thanks again..

Sql Junkie-204042 Hall of Fame Points: 3874 More actions · Answer 3

If the target file (excel) is on the network and all users are exporting to the same file then you will get this error. If the target in on a local drive that should be ok.

SQL_Programmer SSC Veteran Points: 248 More actions · Answer 4

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.

rsharma SSCarpal Tunnel Points: 4865 More actions · Answer 5

Yes, you can. Look into global variable usage in DTS packages. You can pass in the user-name and then create file based on username and timestamp.