Click here to Skip to main content
16,015,809 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
could you please give sql job scheduling steps for accessing data from MS Access database to SQL Server 2008 database.
Posted
Updated 30-Jan-12 18:27pm
v2

1 solution

Read this

http://www.fmsinc.com/MicrosoftAccess/SQLServerUpsizing/importing/Import_Access_DB.asp[^]

Look at the last step . It will save SSIS package for you.
Please change the package storage path from "SQLSERVER" to "File system"

So that you can get SSIS package to load data from MSAccess to SQL SERVER 2008 into your drive.


Also if you need more insight on this.

Watch below link

http://www.youtube.com/watch?v=Jl0Vze2_6_o[^]

Hope this helps Or revert back with your queries,
Rahul D.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900