December 16, 2013 at 4:47 am
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