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.
| Author |
Topic |
|
AndyC
Yak Posting Veteran
53 Posts |
 Posted - 2006-05-01 : 20:21:07
|
| When using DTS for updating SQL 2000 data with MS Access 2000 tables the wizard allowed you to specify access as a datasourceThis does not appear to be the case with the connection manager in Integration services for SQL 2005should i be using the ole db or odbc options and , if so, how do I set them upThanksAndrew Clarkwww.majorleaguecharts.com |
|
|
AndyC
Yak Posting Veteran
53 Posts |
Posted - 2006-05-02 : 15:06:32
|
| OK I've just started viewing a webcast and realised that you can get to similar wizard via the management studioSorry to take up your timeAndrew Clarkwww.majorleaguecharts.com |
 |
|
|
|
|
|
DTS MS Access to SQL 2005. How?