http://www.sqlservercentral.com/Articles tagged Programming, DTS posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)So you've created a SQL Server package and now you're ready to integrate it into your Visual Basic application? In this series, Brian Knight will show you how to use the DTS object model to execute a DTS package from Visual Basic. http://www.sqlservercentral.com/articles/DTS/executingpackagefromvisualbasic/585/2006/08/18http://www.sqlservercentral.com/articles/DTS/executingpackagefromvisualbasic/585/How do you easily copy DTS packages from one server to another? DTS, BCP, T-SQL? Are there advantages to using one method over another? Andy did some research - read the article and see what works and what doesn't! http://www.sqlservercentral.com/articles/Administering/copyingdtspackagestoadifferentserver/638/2006/05/05http://www.sqlservercentral.com/articles/Administering/copyingdtspackagestoadifferentserver/638/DTS is a fantastic ETL tool and it is often used to import Excel documents. However this can be a manual process in many cases in setting up the package. New author Sloan Holliday brings us a way that you can leverage Office XP's automation facilities and XML to import data into SQL Server. http://www.sqlservercentral.com/articles/DTS/leveragingxpexcelxmlandopenxmlfordataimports/2134/2005/11/22http://www.sqlservercentral.com/articles/DTS/leveragingxpexcelxmlandopenxmlfordataimports/2134/Oracle is usually a dirty word in the SQL Server community, but like it or not, lots of data resides in Oracle databases. And SQL Server is often used to gather this data together in a warehouse of some sort for spinning cubes, generating reports, etc. Haidong Ji looks at the various methods that you can connect to an Oracle driver and compares the speed of each. If you need to get data from Oracle, or may need to, this is the place you want to start. http://www.sqlservercentral.com/articles/DTS/comparisonoforacledrivers/1430/2004/07/21http://www.sqlservercentral.com/articles/DTS/comparisonoforacledrivers/1430/So you've created a SQL Server package and now you're ready to integrate it into your Visual Basic application? In this series, Brian Knight will show you how to use the DTS object model to execute a DTS package from Visual Basic. http://www.sqlservercentral.com/articles/DTS/executingpackagefromvisualbasic/585/2006/08/18http://www.sqlservercentral.com/articles/DTS/executingpackagefromvisualbasic/585/DTS logging is a pretty handy feature - if you've got it enabled. Got lots of packages and want to turn it on for all of them? Thats a lot of point and click using EM, but with the code Haidong has put together, it's a snap. Other possibilities to this code as well. After all, it uses a DTS package to modify other DTS packages. http://www.sqlservercentral.com/articles/DTS/automatedtslogging/1124/2003/09/09http://www.sqlservercentral.com/articles/DTS/automatedtslogging/1124/Joe has written some articles for us, he also some interesting comment on his site - this article looks at trapping errors such as timeouts or divide by zero.http://www.sqlservercentral.com/redirect/articles/995/2003/05/27http://www.sqlservercentral.com/redirect/articles/995/The challenge for Robert Marda was to devise a way to keep the data available at all times while importing the new data, detect if a full or daily update was received and run appropriate data pumps, put in sufficient fail safes to ensure bad data would not get imported, and to make the process automatic including notification to pagers upon failure. Robert shows you how he did it here. http://www.sqlservercentral.com/articles/DTS/importingnewdatawithoutemptyingexistingtables/895/2003/01/09http://www.sqlservercentral.com/articles/DTS/importingnewdatawithoutemptyingexistingtables/895/How do you easily copy DTS packages from one server to another? DTS, BCP, T-SQL? Are there advantages to using one method over another? Andy did some research - read the article and see what works and what doesn't! http://www.sqlservercentral.com/articles/Administering/copyingdtspackagestoadifferentserver/638/2006/05/05http://www.sqlservercentral.com/articles/Administering/copyingdtspackagestoadifferentserver/638/This article will show you how to use the FileSystemObject to determine the existence of a file inside DTS. http://www.sqlservercentral.com/articles/DTS/filesystemobject/178/2001/05/23http://www.sqlservercentral.com/articles/DTS/filesystemobject/178/