February 9, 2015 at 5:23 am
Hi all,
i need to create a package to move data from access to sqlserver.
please guide.
February 9, 2015 at 6:01 am
if this is a migration project, did you consider SQL Server Upgrade Assistant for msaccess ( MS freeware ! ) ?
http://www.microsoft.com/en-us/download/details.aspx?id=42656
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 11, 2015 at 5:24 pm
If it's a one-off, and you have the correct permissions, you can create linked tables in Access that point to the SQL Server destination tables and then run a series of append queries in Access. I suppose if you had to, you could open the databases in SSIS using the /x switch to call a macro to do the inserts.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy