sql server dts: I am fairly new to SQL Server Integration Services Packages. I am
looking to transfer data on a daily basis from an Access database to
the SQL 2005 database. I am able to set up a DTS package and do this
in SQL 2000, but do not know how to go about it in SQL 2005. I have
tried importing the 2000 DTS package into 2005 with little luck. Any
information or guidance on best ways to go about this would be great.
I have not used the 2005 tools in this area so any procedures would
also be great!!

Thank you,

Brett

Hello bwalke@lbrspec.com,

OK So you still have the wizard to do the import (Right Click on Databases
| Tasks | Import Data) in there you will find an Access connection manager


You can use SSIS to execute your working 2K package by using the Execute
DTS 2000 Package task.

You can build the package from scratch using BIDs (Business Intelligence
Development Studio) (Start | Run | Devenv | New Project). You would use
an OLEDB connection manager to a Jet.4.0 provider to get to Access)

You can find examples of using BIDs on our site www.SQLIS.com

Allan





[quoted text, click to view]