Viewing 15 posts - 1 through 15 (of 16 total)
Hi Anshul,
To update, I tried to add a derive column and use LTRIM(RTRIM(HSBC_TRADE_REF)) but it is still the same. The Conditional split is sending the newrow for all data...
June 2, 2015 at 12:59 am
My Data type on source table is "char" and on my flat file it is String [DT_STR], would make some issue?
Any other procedure for Insert/Update? how about the Merge...
May 29, 2015 at 3:30 am
Hi Anshul,
Thanks but still the same. Attached is some dummy file.
Edited. After testing the dummy file I attached. It imported to the destination DB ( 3 entries). After...
May 28, 2015 at 10:13 pm
Hi Anshul,
Attached. Please rename it to DTSX
May 28, 2015 at 3:50 am
It seems it does not know which one is existing and which one is new. it keeps on importing to NewRow which it should not be because those data...
May 28, 2015 at 3:01 am
Hi Anshul,
Yes, the conditional split is updated..please see the output on my attachment
NewRow ISNULL(DB_HSBC_TRADE_REF)
ExisitngRow !ISNULL(DB_HSBC_TRADE_REF)
May 28, 2015 at 12:43 am
Hi Anshul,
I tried it but it does not import the new row. My unique column is the HSBC_TRADE_REF. For sure I made a unique entry which does not exist...
May 27, 2015 at 10:36 pm
Got some clues after the merge join flow, the first column become NULL, am I missing something on the merge join?
May 27, 2015 at 5:29 am
Hi Anshul,
Thanks again and please see the attachment.
Added a new attachment included the remaining process
May 27, 2015 at 4:13 am
Hi Anshul,
I think the issue is with the Merge Join, where it seems it does not work properly. I use left outer join same as the instruction on the...
May 27, 2015 at 3:21 am
HI Anshul,
I am following the link yo gave but it seems the Conditional split is not working with me. My reference column data is a varchar and does not...
May 27, 2015 at 12:10 am
If I put it on stating table, and if the destination table is too large, will it takes time to insert/update? What is the best practice to do this?
May 26, 2015 at 2:48 am
Hi Anshul,
I'll try all your suggestion and let you know if it is ok. Thanks.
May 26, 2015 at 2:09 am
Thanks, that do the trick and setting SET NOCOUNT ON / OFF around the store procedure fix some other issue. Many many thanks.:-D
May 20, 2015 at 3:54 am
Hi,
Thanks for the reply and it seems to be simple, the problem is on my query, it has 3 temp tables that is created and it says "No column information...
May 20, 2015 at 2:56 am
Viewing 15 posts - 1 through 15 (of 16 total)