Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Changing MS Access conn. task changes all conn.

Author  Topic  dbleyl Starting Member 21 Posts Posted - 2002-12-31 : 10:01:01 Hello, I have a DTS package with 4 MS Access connection tasks: 3 are unique. The package fails. Upon inspection, all of the access connection tasks have reverted to the most recently changed. Once I fix the incorrect package, the package fails again, this time it is the task that previously worked. Obviously, this isn't a good thing for scheduling the dts package. These access databases are replaced weekly during a build process. I'm in the process of migrating all the Ms Access to SQL Server; eventually this step will be skipped all together. Below is my version information. I'm using MSDE for testing before I move the packages and data to our production sql server 7 sp4. I'm installing sp 4 for sql server 7 on this MSDE today (for some reason we skipped the dev machines). Microsoft SQL Server 7.00 - 7.00.623 (Intel X86) Nov 27 1998 22:20:07 Copyright (c) 1988-1998 Microsoft Corporation MSDE on Windows NT 5.0 (Build 2195: Service Pack 2)