Syntax for Exporting a Table to Access

[LonnieJohnson]

I have a routine I am building. The last step is to take a table that gets created and export it to an MS Access database. I am using SQL Server 2005.

It is easy to do if I use the Export Wizard by right clicking on the database and choosing "Tasks". But how do I do this same thing with code?

Any suggestions?

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[LonnieJohnson]

I finally ended up having the MS Access application do the import instead of SQL Server doing the export...


ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[philhege]

SSIS packages are stored in one of two places: the database or the file system. Unless your SQL server is a centralized job server, you should store the .dtsx file on the file system. You should have been prompted for this choice when you ran the wizard.

DTS files are typically stored under the MSSQL tree. Do a search on .dtsx on your file system. The SSIS package option for the job step should direct you to the default directory for file-system-stored SSIS packages.

-------++NO CARRIER++-------