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 |
|
misterdeey
Starting Member
19 Posts |
 Posted - 2012-02-29 : 17:19:40
|
| Hi,I have a weekly job that runs on SQL 2008 Server and I need to find a way to dump the final result into an existing MS ACCESS 2003 database using an SSIS package. Could someone please tell me how to do this?Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-29 : 22:26:42
|
| you need to use a package with data flow task using sql server as source and access destination.you can use OLEDB source connection for both------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
misterdeey
Starting Member
19 Posts |
Posted - 2012-03-02 : 18:25:23
|
| Actually I've used an OLE DB Source to ADO NET Destination via a .Net Provides for oleDB\Microsoft Office 12.0 Access database Engine OLE DB Provider as "Data Source".Thank you again. |
|
|
|
|
|
|
Export data from SQL 2008 to MS Access 2003