SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Miscellaneous, Programming, SQL Server 7, DTS Rss

   Items 1 to 4 of 4   

Leveraging XP Excel , XML, and OPENXML for Data Imports

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.   Read more...
By Sloan Holliday 2005/11/22 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 10,661 reads

Comparison of Oracle Drivers

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.   Read more...
By Haidong Ji 2004/07/21 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 15,879 reads

Trapping DTS errors with Transact-SQL

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.  Read more...
By Additional Articles 2003/05/27 | Source: Other | Category: dts
Rating:  Rate this |   Briefcase | 2,398 reads

Using FileSystemObject with DTS

This article will show you how to use the FileSystemObject to determine the existence of a file inside DTS.   Read more...
By Brian Knight 2001/05/23 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 8,135 reads
   Items 1 to 4 of 4