April 10, 2009 at 9:31 am
Scenario: a daily download of MS Access from a third-party service. Each download holds entire historical data. I want to upsize to MS SQL Server 2005. I also want to automate this daily - an ftp download and the pull of the data into SQL Server.
Is SSIS a good fit for this? If so, can you suggest how to do it?
In any case, how do I entirely replace the content of an SQL Database from an MS Access database without dropping the SQL database and having to create it anew along with all db users and privileges, etc?
Thanks -
April 10, 2009 at 10:42 am
SSIS is a good fit for this, however, there is a fairly large initial learning curve.
The basic approach I would take is, for each table:
_ 1) Empty the SQL table (Delete From tablename)
_ 2) Load all of the data in the Access table into the SQL table
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply