Post reply

Access to SQL

  • August 4, 2011 at 1:26 pm

    #255307

    Is there anyway we can import the whole Access database to the SQL server using SSIS? Do we need create data flow task for each column?

  • August 4, 2011 at 2:13 pm

    #1363973

    I don't know if there is a complete way from SQL/SSIS, but Access has an upsize wizard. Does that not work?

  • August 4, 2011 at 2:14 pm

    #1363974

    Could you please explain how does that work? I am not familiar with access.

  • August 4, 2011 at 2:30 pm

    #1363990

    Open Access, select Database Tools on the Ribbon, then there's a "Move Data" section. Choose SQL Server, follow the wizard.

  • August 4, 2011 at 3:32 pm

    #1364019

    Thanks Steve. But it looks like creating the SSIS package through the importa data wizard works better and can be reused too.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply