October 9, 2006 at 1:03 am
Hey friendz,
I've developed a DTS package from importing data from excel files to SQL Server and its working according to the requirement except that I want the transform task to be in a transaction & it should rollback if any error occurs or else commit the transaction.
How will i achieve this in DTS?
--Ramesh
October 9, 2006 at 3:15 am
What programming language do you use in your DTS?
_____________
Code for TallyGenerator
October 9, 2006 at 4:18 am
.........VBScript
--Ramesh
October 9, 2006 at 4:20 am
Did you notice this forum is about T-SQL?
_____________
Code for TallyGenerator
October 9, 2006 at 4:35 am
Sergiy,
I posted this thread in this forum only because this forum is very active & secondly there isn't any forum dedicated to DTS in SSC.
--Ramesh
October 9, 2006 at 1:46 pm
Want to use transactions - use transactional language.
VB is not transactional.
Need transactions - drop DTS and start programming Transactional-SQL, or T-SQL. With all its SP, triggers, etc.
Sorry.
_____________
Code for TallyGenerator
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply