http://www.sqlmag.com/authors/author/author/5415142/rsscomment/5415142en-USFri, 25 May 2012 11:09:25 GMTFri, 25 May 2012 11:09:25 GMThttp://www.sqlmag.com/article/task-scheduling/dts-on-the-move#commentsAnchorThu, 17 Jan 2008 07:59:36 GMT
Hi Shane, Thanks for the Article. I have a query. I have a server having 100 odd DTS Packages. Some of the Packages are refering some local Drivename on the Network (say P:, Q: etc.) I have to move out all these DTS Packages as a part of my DB Migration process to a new Server where the Drive reference might be (say R:, S: etc.). My question is that is there anyway to submit any query for finding the Package in my existing drive where the local Drivename convetion have been used. Warm Regards, Arindam Ganguly.]]>ArindamThu, 17 Jan 2008 07:59:36 GMThttp://www.sqlmag.com/article/task-scheduling/dts-on-the-move#commentsAnchorhttp://www.sqlmag.com/article/task-scheduling/dts-on-the-move#commentsAnchorThu, 29 May 2003 15:43:54 GMT
"CDONTS doesn’t rely on profiles" but does rely on an SMTP gateway. Our problem is we have a DEV environment which isn’t trusted by PROD, and isn’t connected to the Internet. So, we can’t authenticate by Profiles nor post to SMTP. So, it seems no email notification is possible from DEV. But we want to implement it in PROD. Any suggestions how to proceed?]]>MIS Analyst Programmer Thu, 29 May 2003 15:43:54 GMThttp://www.sqlmag.com/article/task-scheduling/dts-on-the-move#commentsAnchorhttp://www.sqlmag.com/article/task-scheduling/dts-on-the-move#commentsAnchorTue, 27 May 2003 10:05:43 GMT
Shane, Great article. I wish I had read this article 12 months ago. However, another take on this aricle is "How do I build in portability - and control tranfer from test to live data?" We have one development box and two live environments at opposite ends of the UK. We put a lot of work into taking data from flat files to import into various databases. This needed a test location for flat files and a test database. When the package is sent to the live server, the locations needed to be live. We "solved" the problem with UDL datasources. These were always stored on the "S:\" drive. By mapping the S:\ drive appropriately for each machine we ensured that the all sources and destinations were either live or test. (Unfortunately, this didn’t work with the AS/400 queries, where the library name needed to be in the SQL explicitly) Another issue that we uncovered was that when calling a child package, if the parent was moved from test to live, the references to the child package were still pointing at the test child. - This was solved by the first task for each package deleting the reference to the PackageID for each DTSExecutePackageTask Mike]]>Mike Gordon Tue, 27 May 2003 10:05:43 GMThttp://www.sqlmag.com/article/task-scheduling/dts-on-the-move#commentsAnchor