July 25, 2001 05:25 PM

DTS 2000 in Action

Rating: (0)
SQL Server Magazine
InstantDoc ID #21587
Global variables become the activity hub for a DTS package
The first version of Data Transformation Services (DTS), which Microsoft introduced with SQL Server 7.0, gave database professionals an easy-to-use, low-cost alternative to more expensive products in the data extraction, transformation, and loading (ETL) market. The first versions of most products leave gaps in their coverage, however, and DTS was no exception. Microsoft provided several enhancements in SQL Serv...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

google has a better search

faiz1 7/15/2004 10:12:40 AM


I'm getting a 'task failed during execution',
where step 11. Copy tables has 24 times a message:
1:foodmart copy tables) substep 'DTSSTep_DTSDataPumpTask_24' failed with the following error: Login failed for user ''. Looks to me the access user login but can't find more...

Ben van Zanten 9/25/2002 3:10:50 PM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS