Thanks Guys, but we dont have change data capture turned on, I was thinking of stored proc that use a Not exists ..

ANY IDEAS guys

Hello All,

I have a task to write stored procedure for a data migration project, I am trying to load data from existing tables to a dimension table for...

The tempdata still has duplicates ...even with distinct

My question is how do I spot the duplicates without touching the joins please what do u reckon

Many thanks

jjj

its being highlighted in the temporary table above...although i did not paste that here

I think the problem is with the join on the

JOIN VR_DataLoad.prdrmkt.dbo.tbl_asset_instance ai

not that at all

Please take...

Which column please highlight ...

Many thanks

Tried it and it worked but the i think the join on VR_DataLoad.prdrmkt.dbo.tbl_asset_instance ai is actually the issue cos the multi-part identifier is the challenge

cos thats where the error...

Tried it and it worked but the i think the join on VR_DataLoad.prdrmkt.dbo.tbl_asset_instance ai

Hello Should i make this a sql task after or before the data flow task

It will include the bank holidays , the extract just needs to show the last working day of the month

Many Thanks

o sorry

HERE IT IS

PLEASE DONT MIND THE FAINT NATURE

THE EXECUTION PLAN IS ATTACHED

THANKS FOR UR HELP

Hello all,

i got it solved ....this way...its a ole db to file extract pakage ....

All i was having challenges with was to use to extract many files from the...

Hello all,

i got it solved ....this way...its a ole db to file extract pakage ....