Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

handling missed fields in ssis package Expand / Collapse
Author
Message
Posted Monday, December 16, 2013 4:47 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:11 AM
Points: 211, Visits: 4,540
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.
Post #1523156
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse