Unanswered: DTS, consolidating databases, problem with transactions
I'm consolidating data from a number of databases and have managed to create a nice DTS script to loop through a table of datasources thanks to www.sqldts.com (Allan Mitchell) and various posts on usenet.
To get the script working I need to set "Close connection on completion" in Workflow properties for the datapump.
Doing that halts execution if I do not run outside of a transaction.
Is there a better way of closing only the source connection?
Also, is there a way to not require the source to be part of the transaction?
(Pervasive's driver doesn't seem to work very well with DTC anyway)