Post reply

How to load data into SQL Server Table from Access mdb file table whose table structure is dyanamic

  • September 7, 2011 at 6:54 am

    #247430

    Hi,

    I am loading data from Access mdb file table to SQL Server database table using DataFlow Task in SSIS. Problem is mdb file table structure is not static. Let say for april month it has five columns a,b,c,d and e. For May month, it has eight columns a,b,c,d,e,f,g and h. I mean to say that, every next month access table get some more new columns. So, my dataflow task works for one month and it failed for the next month as access db table structure is changed. Is there any way to handle this issue dynamically in data flow or using other SSIS task while importing it to SQL Server database 2008 R2. I am using SQL Server 2008 R2 edition.

    A quick reponse is appreciated.

    Thanks in Advance.

  • September 7, 2011 at 7:30 am

    #1377965

    if the source columns list is dynamics, do you need it dynamics on SQL as well?

    Look with the for each loop container, maybe you could do somethig columns by columns

  • September 7, 2011 at 11:44 am

    #1378184

    No. I do not need to create SQL Server table dynamically as SQL Server table is created with the structure of lastest access db file. So, SQL Server table have all the columns required to load the ms access db table.

Viewing 3 posts - 1 through 2 (of 2 total)

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