July 22, 2004 at 3:58 am
Hi All,
I have created a few DTS packages to perform data uploads. We require to programatically change the Destinatio Server so we decided to use UDL (Microsoft Data Link) files. Things seem to work fine until we started using it in a batch command, it seems that the DTS packs caches the connection details, so eventhough we change the destination DB the UDL file, the DTS pack still looks for the old/previous DB.
Anyone got any clue on how (via osql) we can clear the connection cache so the each time a DTS package is executed, it will read the connection string directly from the UDL file instead of cache.
This thing is driving me nuts!!!
July 22, 2004 at 4:14 am
You need to check the box 'Always read properites from UDL file'. If it is unchecked, the information is cached.
July 23, 2004 at 2:20 am
Hi,
I have done that, but is still seems to be caching it. The wierd side of all of this is, the first task in the DTS pack uses the correct UDL file (with the correct DB), the second task seems to execute to the incorrect UDL, which points to the wrong DB even though, when you check the UDL file properties, it points to the correct DB.
When you execute it, the first step is successful then the second fails with an error: "unspecified error".
July 23, 2004 at 9:40 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply