http://www.sqlmag.com/authors/author/author/5080481/rsscomment/5080481en-USFri, 25 May 2012 10:44:09 GMTFri, 25 May 2012 10:44:09 GMThttp://www.sqlmag.com/article/dts/using-dts-to-populate-a-data-warehouse#commentsAnchorThu, 24 Jul 2008 12:29:03 GMT
Thanks, Marcos. As you mentioned, we do have online archives for SQL Server Magazine articles, going back to the first issue--March 1999. I often see reader comments on older articles and am glad to know that you and other readers find them useful.]]>AnneThu, 24 Jul 2008 12:29:03 GMThttp://www.sqlmag.com/article/dts/using-dts-to-populate-a-data-warehouse#commentsAnchorhttp://www.sqlmag.com/article/dts/using-dts-to-populate-a-data-warehouse#commentsAnchorThu, 24 Jul 2008 09:58:46 GMT
Nice step-by-step initiation to DTS. I used DTS in mane cases and it demonstrated to be a useful tool. Thanks to SQLMag to leave this article on-line. Marcos Galvani MCDBA(SQL2k) MCTS (SQL2k3) marcosgalvani@gmail.com]]>MarcosThu, 24 Jul 2008 09:58:46 GMThttp://www.sqlmag.com/article/dts/using-dts-to-populate-a-data-warehouse#commentsAnchorhttp://www.sqlmag.com/article/odbc/the-dts-development-guide#commentsAnchorFri, 16 Mar 2007 22:19:22 GMT
This gave me info on the execution location of DTS packages.]]>ErandaFri, 16 Mar 2007 22:19:22 GMThttp://www.sqlmag.com/article/odbc/the-dts-development-guide#commentsAnchorhttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorSun, 17 Jul 2005 02:41:22 GMT
Anonymous]]>Anonymous User Sun, 17 Jul 2005 02:41:22 GMThttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorhttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorSun, 17 Jul 2005 02:41:22 GMT
Anonymous]]>Anonymous User Sun, 17 Jul 2005 02:41:22 GMThttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorhttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorSun, 17 Jul 2005 02:40:31 GMT
Anonymous]]>Anonymous User Sun, 17 Jul 2005 02:40:31 GMThttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorhttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorSun, 17 Jul 2005 02:40:31 GMT
Anonymous]]>Anonymous User Sun, 17 Jul 2005 02:40:31 GMThttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorhttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorSun, 17 Jul 2005 02:40:31 GMT
Anonymous]]>Anonymous User Sun, 17 Jul 2005 02:40:31 GMThttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorhttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorSun, 17 Jul 2005 02:40:31 GMT
Anonymous]]>Anonymous User Sun, 17 Jul 2005 02:40:31 GMThttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorhttp://www.sqlmag.com/article/activex/unleash-the-power-of-dts#commentsAnchorSat, 16 Apr 2005 05:24:05 GMT
should have elaborated a lil more]]>Anonymous User Sat, 16 Apr 2005 05:24:05 GMThttp://www.sqlmag.com/article/activex/unleash-the-power-of-dts#commentsAnchorhttp://www.sqlmag.com/article/migration/migrating-from-sql-server-6-5-to-7-0#commentsAnchorThu, 17 Mar 2005 02:31:47 GMT
f]]>Anonymous User Thu, 17 Mar 2005 02:31:47 GMThttp://www.sqlmag.com/article/migration/migrating-from-sql-server-6-5-to-7-0#commentsAnchorhttp://www.sqlmag.com/article/odbc/the-dts-development-guide#commentsAnchorTue, 15 Mar 2005 06:12:09 GMT
I have been fighting for this DDQT since a year. I have been avaiding it, since I was not able to catch it. Your article is really great and has explained with exaple, which very small percentage do it. I liked the article and was really usefull. Thank you Saurabh Kothari]]>Anonymous User Tue, 15 Mar 2005 06:12:09 GMThttp://www.sqlmag.com/article/odbc/the-dts-development-guide#commentsAnchorhttp://www.sqlmag.com/article/tsql3/constructing-dts-custom-tasks#commentsAnchorFri, 17 Dec 2004 14:26:25 GMT
VB is obsolete. Need more C# oriented articles]]>Anonymous User Fri, 17 Dec 2004 14:26:25 GMThttp://www.sqlmag.com/article/tsql3/constructing-dts-custom-tasks#commentsAnchorhttp://www.sqlmag.com/article/dts/pump-up-the-power-of-dts#commentsAnchorFri, 17 Dec 2004 02:02:04 GMT
aaaaaaaa]]>Anonymous User Fri, 17 Dec 2004 02:02:04 GMThttp://www.sqlmag.com/article/dts/pump-up-the-power-of-dts#commentsAnchorhttp://www.sqlmag.com/article/activex/dts-error-handling-revealed#commentsAnchorSun, 28 Nov 2004 23:09:45 GMT
s]]>Anonymous User Sun, 28 Nov 2004 23:09:45 GMThttp://www.sqlmag.com/article/activex/dts-error-handling-revealed#commentsAnchorhttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorThu, 18 Nov 2004 15:41:06 GMT
Anonymous]]>Anonymous User Thu, 18 Nov 2004 15:41:06 GMThttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorhttp://www.sqlmag.com/article/visual-basic-vb/dts-scripts-and-tricks#commentsAnchorWed, 03 Nov 2004 15:02:11 GMT
To the Anonymous User, you should use global variables to set all values that are going to change when you move the package. Then, you simply have to update the global variables to whenever/wherever you move it.]]>Anonymous User Wed, 03 Nov 2004 15:02:11 GMThttp://www.sqlmag.com/article/visual-basic-vb/dts-scripts-and-tricks#commentsAnchorhttp://www.sqlmag.com/article/visual-basic-vb/dts-scripts-and-tricks#commentsAnchorWed, 27 Oct 2004 07:32:13 GMT
I want to create a DTS package in the development SQL Server and move it to Production SQL Server later. How can i change the SQL Server Name, Source and Destination names used in the package with out much intervention from the Production DB Administrator.? Is there any way I can create some scripts like SQL Stored Procedure and edit it later.]]>Anonymous User Wed, 27 Oct 2004 07:32:13 GMThttp://www.sqlmag.com/article/visual-basic-vb/dts-scripts-and-tricks#commentsAnchorhttp://www.sqlmag.com/article/data-access/introduction-to-data-transformation-services#commentsAnchorSun, 08 Aug 2004 11:15:56 GMT
This article is very nice but still if author focus on parallel processing through DTS package, may help me lots.]]>darshSun, 08 Aug 2004 11:15:56 GMThttp://www.sqlmag.com/article/data-access/introduction-to-data-transformation-services#commentsAnchorhttp://www.sqlmag.com/article/data-access/introduction-to-data-transformation-services#commentsAnchorMon, 14 Jun 2004 03:46:33 GMT
Your Comments (required):it is gr8!!! it reall y helped me out,.. thanks.....]]>sunil vadgama Mon, 14 Jun 2004 03:46:33 GMThttp://www.sqlmag.com/article/data-access/introduction-to-data-transformation-services#commentsAnchorhttp://www.sqlmag.com/article/visual-basic-vb/dts-scripts-and-tricks#commentsAnchorSat, 05 Jun 2004 23:59:14 GMT
This article is very usefull for me. Thanks]]>Rohan Perera Sat, 05 Jun 2004 23:59:14 GMThttp://www.sqlmag.com/article/visual-basic-vb/dts-scripts-and-tricks#commentsAnchorhttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorMon, 26 Apr 2004 05:23:44 GMT
I need the details of Planning and Monitorings of the projects related to Buildings.]]>ahmad khan Mon, 26 Apr 2004 05:23:44 GMThttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorhttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorMon, 08 Mar 2004 05:20:40 GMT
Article is very basic and gives intro to the data warehousing terminology in a simple way. Send me the details / links for some of the advanced concepts of Data Ware Housing.]]>Ajay Mittal Mon, 08 Mar 2004 05:20:40 GMThttp://www.sqlmag.com/article/data-management/data-warehousing-back-to-basics#commentsAnchorhttp://www.sqlmag.com/article/odbc/the-dts-development-guide#commentsAnchorThu, 04 Mar 2004 08:46:47 GMT
The Transformation ActiveX script is where it gets confusing for me (which wasn’t discussed very well except for the fact that it must return one of the query-type constants). Does the actual copying of values from the Source To Destination take place in the Transformation script, and then the parameterized Query over-rides or adds to what was done in the Transformation script. In all that I’ve read about DTS’ DDQs this link between what code gets executed in the Transformation script and the parameterized query is extremely cloudy or just overlooked.]]>markThu, 04 Mar 2004 08:46:47 GMThttp://www.sqlmag.com/article/odbc/the-dts-development-guide#commentsAnchorhttp://www.sqlmag.com/article/odbc/the-dts-development-guide#commentsAnchorFri, 20 Feb 2004 12:39:50 GMT
After spending many hours researching how to do error handling in the DTS Package Designer, this article was very helpful in guiding me to research the object model to do what I am trying to implement. Thank you.]]>bsamlokFri, 20 Feb 2004 12:39:50 GMThttp://www.sqlmag.com/article/odbc/the-dts-development-guide#commentsAnchorhttp://www.sqlmag.com/article/tsql3/constructing-dts-custom-tasks#commentsAnchorWed, 05 Nov 2003 21:53:39 GMT
Hi! i am trying to build a custom task in c#. The problem on hand is that my custom properties do not appear on the properties window even though they have been declared public. Any suggestions/Pointers would be great help. Regards, Alok Arora]]>Alok Arora Wed, 05 Nov 2003 21:53:39 GMThttp://www.sqlmag.com/article/tsql3/constructing-dts-custom-tasks#commentsAnchorhttp://www.sqlmag.com/article/tsql3/constructing-dts-custom-tasks#commentsAnchorWed, 05 Nov 2003 21:53:39 GMT
Hi! i am trying to build a custom task in c#. The problem on hand is that my custom properties do not appear on the properties window even though they have been declared public. Any suggestions/Pointers would be great help. Regards, Alok Arora]]>Alok Arora Wed, 05 Nov 2003 21:53:39 GMThttp://www.sqlmag.com/article/tsql3/constructing-dts-custom-tasks#commentsAnchorhttp://www.sqlmag.com/article/visual-basic-vb/dts-scripts-and-tricks#commentsAnchorFri, 17 Oct 2003 06:12:39 GMT
Hi I’m searching the web to try and find any information on the ’Parameters’ value in DTS package task ’Execute Process. So far I havent’ found much, the batch job I’m calling from DTS is failing and so is my knowledge..! Cheers]]>Richard Burton Fri, 17 Oct 2003 06:12:39 GMThttp://www.sqlmag.com/article/visual-basic-vb/dts-scripts-and-tricks#commentsAnchorhttp://www.sqlmag.com/article/activex/unleash-the-power-of-dts#commentsAnchorWed, 30 Jul 2003 09:44:52 GMT
I want to use a comma delimited list as my source and insert the data into an SQL server 2000 table. Here is my problem: The list is not always going to be named the same thing and I also need to run a SP during the insert to check and see if the data from the list already exists in the table. There will be many rows of data from the lists that will be inserted and many will not because they are already present in the table. Can you help me?]]>Brian Pregler Wed, 30 Jul 2003 09:44:52 GMThttp://www.sqlmag.com/article/activex/unleash-the-power-of-dts#commentsAnchorhttp://www.sqlmag.com/article/activex/dts-error-handling-revealed#commentsAnchorThu, 01 May 2003 07:41:03 GMT
I currently have several datapump tasks which move SQL Server 2000 table data to several access tables. I have an ActiveX Task in the same package which emails a note when executed. The issue is that I can’t seem to set the task workflow up in a way that would allow the email task to only execute if ALL tasks were successful. In addition, I have an "error" email task and I am finding it difficult to setup the workflow in a way that would allow the "error" email to be executed if ANY ONE of the several datapump tasks fail. Do you have any advice? Thank you! - NW]]>nwThu, 01 May 2003 07:41:03 GMThttp://www.sqlmag.com/article/activex/dts-error-handling-revealed#commentsAnchorhttp://www.sqlmag.com/article/odbc/standalone-dts#commentsAnchorSat, 29 Dec 2001 18:22:53 GMT
I have installed standalone DTS on a webserver and am trying to create/execute package in an ASP. However, I can’t get this page to work - it’s gives a timeout error. Has anyone experienced this problem?]]>JaiSat, 29 Dec 2001 18:22:53 GMThttp://www.sqlmag.com/article/odbc/standalone-dts#commentsAnchorhttp://www.sqlmag.com/article/dts/using-dts-to-populate-a-data-warehouse#commentsAnchorMon, 17 Dec 2001 07:21:36 GMT
I could not find Listing1 or Listing2 from the article.]]>Lisa Pai Mon, 17 Dec 2001 07:21:36 GMThttp://www.sqlmag.com/article/dts/using-dts-to-populate-a-data-warehouse#commentsAnchorhttp://www.sqlmag.com/article/visual-basic-vb/dts-scripts-and-tricks#commentsAnchorTue, 26 Jun 2001 01:46:17 GMT
Hi I have been trying for quite sometime now, to execute a DTS Package saved on my server under Local packages, from the command prompt using a batch file. It doesn’t execute. It opensup a separate window but it doesn’t execute. The syntax i had used to get it executed is as follows cmd /c \\abcdefghi\MSSQL7\binn\dtsrun /S abcdefghi /E /N P1 I had tried all combinations of flags for instance , saving it as a file and running and using USERID etc. But it doesn’t seem to work. The server configuration we have is as follows.. It’s a Winnt CLUSTER of 2 servers , which i am accessing through their virtual Names. Some one told me that you cannot invoke the DTCRUN application on a virtual server. If this is true how do you schedule the package. Please help.]]>Sambasiva Darbha Tue, 26 Jun 2001 01:46:17 GMThttp://www.sqlmag.com/article/visual-basic-vb/dts-scripts-and-tricks#commentsAnchorhttp://www.sqlmag.com/article/activex/unleash-the-power-of-dts#commentsAnchorThu, 19 Apr 2001 05:17:07 GMT
straight outta msdn or what!]]>mickster Thu, 19 Apr 2001 05:17:07 GMThttp://www.sqlmag.com/article/activex/unleash-the-power-of-dts#commentsAnchorhttp://www.sqlmag.com/article/tsql3/constructing-dts-custom-tasks#commentsAnchorWed, 14 Mar 2001 10:48:45 GMT
Thanks for this article. It was really very informative, and several VB apps I was using as .exe in packages are now comfortably wrapped as custom tasks in packages. However , I am running across a major problem with these custom tasks. If this task is nestled in a package, and if it errored out because of any reason such as missing parameters etc, I see that after it reports an error I cannot delete this custom task and even I could I see that SQL server throws an exception and terminates abnormally. Any ideas why this might be happening?!!]]>Karthik Nagaraj Wed, 14 Mar 2001 10:48:45 GMThttp://www.sqlmag.com/article/tsql3/constructing-dts-custom-tasks#commentsAnchorhttp://www.sqlmag.com/article/odbc/the-dts-development-guide#commentsAnchorMon, 30 Oct 2000 10:58:29 GMT
I was really disappointed you didn’t show the screen for the transformation tab. I like to see completeness not laziness and shortcuts.]]>BillMon, 30 Oct 2000 10:58:29 GMThttp://www.sqlmag.com/article/odbc/the-dts-development-guide#commentsAnchorhttp://www.sqlmag.com/article/data-access/introduction-to-data-transformation-services#commentsAnchorSat, 02 Sep 2000 05:35:14 GMT
Good]]>Rabi Pattnaik Sat, 02 Sep 2000 05:35:14 GMThttp://www.sqlmag.com/article/data-access/introduction-to-data-transformation-services#commentsAnchorhttp://www.sqlmag.com/article/odbc/the-dts-development-guide#commentsAnchorSat, 22 Jul 2000 07:38:31 GMT
I have been stuggling with Data Driven Queries in DTS for the past few weeks. Your article has shed the insight the I needed to use this tool in our data warehousing execution. Thank you, Adam Luckhaupt]]>Adam Luckhaupt Sat, 22 Jul 2000 07:38:31 GMThttp://www.sqlmag.com/article/odbc/the-dts-development-guide#commentsAnchorhttp://www.sqlmag.com/article/visual-basic-vb/creating-dts-custom-transformations#commentsAnchorWed, 05 Jul 2000 04:38:21 GMT
It is a nice article, but the sample code don’t work with SQL Server 2000. The method CXMLDoc::Execute didn’t write in the destination column. To fix this error you must set obStatus of destination binding to DBSTATUS_S_OK, like DWORD* status = (DWORD *) ( rDTSDestColumnData.pvData + rDBDestBinding.obStatus ); *status = DBSTATUS_S_OK; before you change the content of obValue.]]>Jürgen Meister Wed, 05 Jul 2000 04:38:21 GMThttp://www.sqlmag.com/article/visual-basic-vb/creating-dts-custom-transformations#commentsAnchorhttp://www.sqlmag.com/article/odbc/standalone-dts#commentsAnchorThu, 15 Jun 2000 07:16:21 GMT
After SP2 has been applied on the server, is there anything that needs to be done on a machine that has a standalone copy of DTS on it based on SP1 to run new format DTS packages ?]]>Jack Miller Thu, 15 Jun 2000 07:16:21 GMThttp://www.sqlmag.com/article/odbc/standalone-dts#commentsAnchor