April 12, 2009 at 9:16 pm
HI,
I am new to SSIS world, sorry if my question seems very basic.
I have following requirement can anyone help me how can i do it in SSIS.
Requirement:
I have to transfer data from source to destination before doing so I have to check whether a column in destination table is null or not ....
Stpe 1: select a column in destination table(destination. tablea.column1).
Step 2: Verify if it null or not
step 3: if it's null , then insert a value to it from source table as.
insert in to destination.tablea.column1
select source.table X.column1 from source.tableX.
and insert records from destination.tableZ to source ,tableb.
step 4: if it's not null then .
check if source .tableX.column1 > destination . tablea.column
If this is flase stop the process .if this is true insert recors from destination to source.
Can any one please help me with this? Any help is really appreciated.
I did the following but no avail.
I select data flow in control flow. then selected data flow. selected source oledb connection connected to detinatination select table and column I need.
>> then I added conditional split added the conditon IS NULL(destination.colum).
>> then, I have to transfer data from source to destination if this is null and if it is not null I have to check for other condition....
no luck, I am gettign error saying, you cannot connect conditional split and a source connection as they con't have same columns.
April 13, 2009 at 5:18 am
Is this a homework assignment?
April 13, 2009 at 8:50 am
- Take two sources, pre-sort them in the SQL Command and set the SortKeyPositions appropriately.
- Use a merge (left) join on the keys.
- use a Conditional split and Verify the ISNULL(KeyName_From2ndSource). This will give an output which u need and another which is default.
- Split them into destinations of your choice.
I know this was kinda vague....but will solve your prob.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply