Re: Import data from Access to SQL2005 on daily basis
- From: Allan Mitchell <allan@xxxxxxxxxxxxxxxxxx>
- Date: Mon, 15 May 2006 10:30:52 +0000 (UTC)
Hello bwalke@xxxxxxxxxxx,
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
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
.
- References:
- Import data from Access to SQL2005 on daily basis
- From: bwalke
- Import data from Access to SQL2005 on daily basis
- Prev by Date: Re: SSIS Pulling Data from an AS400
- Next by Date: Re: Attn: Allan Mitchell
- Previous by thread: Import data from Access to SQL2005 on daily basis
- Next by thread: Looping Query not working
- Index(es):
Relevant Pages
|
