handling missed fields in ssis package

  • hi friends i have doubt in ssis please tell me how to solve

    souce is one server(mysql) and in that have 5 databases(s1,s2,s3,s4,s5).

    one server haveing 5 databases and in each database having same table name and below having data like

    database1

    table:emp

    id ,name,sal,dname,deptno

    1 , abc,1000 ,dr ,10

    database2

    table:emp

    id ,name,sal,dname

    2 ,jai ,500,jr

    database3

    table:emp

    id ,name,sal,deptno

    3, venu ,4500,50

    database4

    table:emp

    id,name,sal

    5,hari ,5000

    database5

    table:emp

    id,name,sal,dname,deptno

    6 ,balu,2410,ravi ,32

    in this above 5 database have in one server i want load this all tables data into target table dynamicaly.here i have problem to

    loading in this above table some table haveing some fields missed in table level .what ever missed field that place data load empty

    in target table(target is anothere server and its have one databasebase and table is emp).and i want look like target table data like below

    emp:

    id,name,sal , dname ,deptno

    1 ,abc ,1000 , dr ,10

    2 ,jai ,500 , jr ,

    3,venu ,4500 , ,50

    5,hari,5000 , ,

    6,balu,2410 , ravi ,32

    first level i get databasenames in query level and that result passed in one object and that object called in foreach ado enumeratore that dft drag and drop in foreach loop and dataflow level source is configure and convert datatypes and configur to target table .but here databse one table loading successfuly and databse2 table data failed because of one filed is missed in source level .how to handled missed columns dynamicaly in source level.

Viewing 0 posts

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