June 18, 2011 at 2:13 pm
could someone please help me connecting Access db via ssis. I am new to this migration and I need to migrate access db to sql server 2008 and i was thinking of using import/export. When i try to connect to access db via import/export it gives me three options
Access db file path -- I know the path
Username and Password ---would like to know what username/password do i need to use here. Is it my windows authantication which i use to log in to the servers or do i need get Access password. Do i have to request from access adminstrator? Plese help
Please Please Help..........
June 20, 2011 at 5:13 am
if its a migration you want to do ...why not go into the access mdb itself and do an export to Sql Server...much easier...why use an ssis package ?
I seem to remember Access tries to make the best guess on the data types it imports....
all text comes out as nvarchar etc. What I would do is to get the stuff into staging tables
and then create the proper tables in sql server and then use sql to do inserts from staging into the
corresponding target tables...
June 20, 2011 at 8:07 am
Thank you so much robinrai3 ! it was really helpful. I just want to try different options to migrate from MS Access to SQL server and that’s why I am still trying to figure out the answer of original question. Would you be able to help me here?
Original questions
When I try to connect to access db via import/export it gives me three options
Access db file path -- I know the path
Username and Password ---would like to know what username/password I need to use here. Is it my windows authentication which I use to log in to the servers or do I need get MS Access password? Do I have to request from access administrator? Please help
June 21, 2011 at 6:42 am
If you are not using Access WorkGroup security, the default user name is Admin and the password is blank.
June 25, 2011 at 11:28 am
Thank you so much WILLIAM ! That worked !!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply