Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted May 4, 2005

Explore SQL Server 2000 DTS Packages Using .NET and the DTS Class Library

By DatabaseJournal.com Staff

[From Developer.com]

SQL Server developers and administrators are no strangers to Data Transformation Services (DTS) packages. They likely develop DTS packages to perform everything from simple database operations to data aggregation. As such, when they upgrade some or all of their servers to SQL Server 2005, they must decide what to do with all of their DTS packages.

If you find yourself in this scenario, it can get hectic. The number of DTS packages you've created is probably not trivial, and as a DBA or developer in a perpetually changing environment that demands more with less, every minute counts. You must move quickly but remain thorough. With DTS literally everywhere, how do you assess the scope of a database change on your DTS packages? Short of opening and examining each package, what are the other options? Fortunately, there is a solution: the DTS class library.

The article continues at http://www.developer.com/db/article.php/3502036

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM