September 10, 2008 at 10:33 pm
Hi All,
I have a question regarding DTS. Let say I have one DTS package as "ProcessMasterData". I wants the same DTS package should called by all the users who wants to upload data from Source to Destination table. Here My question is: IS IT POSSIBLE OR NOT?
If possible then how?
This related one more question, if in same time multiple user access the same DTS, which is design on the static Source and destination table will it be raise an error or not?
Cheers!
Sandy.
--
September 10, 2008 at 11:52 pm
Hello,
Multiple users can execute the same DTS package, for example by using the dtsrun utility, or from a custom application. (Please see the SQL 2000 BOL topic "Executing a DTS Package")
If the DTS package does not drop and re-create the Target Table, but just updates or inserts records, then in general you would not have any conflicts (beyond the usual Locking ones). When you design the Package, you do though need to consider multi-user operation.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
September 11, 2008 at 12:19 am
John,
Can you give me an example what you just described here.
Let see one of my requirements, I need to call the same DTS by multiple users at the same time by using one procedure..
Will it execute or not??
Please I need more clear on this??
Cheers!
Sandy.
--
September 11, 2008 at 1:23 am
John, its works for me...Even I tested it...
It is working for multiple user and multiple session too...for same time...
execute master.dbo.xp_cmdshell 'dtsrun /SserverName /UloginName /Ppassword /NDTSpackageName /M'
THANKS A LOT..
Cheers!
Sandy.
--
September 11, 2008 at 1:31 am
Hello Sandy,
Glad to hear it is working fine.
Here is a link to a related article that you may also find useful: http://www.sqldts.com/210.aspx
Regards,
John
www.sql.lu
SQL Server Luxembourg User Group
September 11, 2008 at 1:52 am
Thanks John again to you...
Cheers!
Sandy.
--
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply