Viewing 5 posts - 1 through 6 (of 6 total)
July 26, 2017 at 8:30 am
Oh sound's great! I just added a OLE DB comand with TRUNCATE TABLE between DB.Table1 and DW.Table1 and it work 😛
Thanks 😉
July 26, 2017 at 8:26 am
so how can i do this? stored procedure?
If yes what's the best way and code for do that?
Thank you and apologize for these questions but...
July 26, 2017 at 8:13 am
Does your source table have a primary key? Yes, Col1 for example it's primary key
Does it have DateCreated and DateModified columns? No
July 26, 2017 at 7:31 am
I Have:
SOURCE DB TABLE1
Col1 Col2 Col3 Col4 Col5
Test Test Test Test Test
I create a DW with an integration Services process and now i have
DW.TABLE1
Col1 Col2 Col3
July 26, 2017 at 7:24 am
Viewing 5 posts - 1 through 6 (of 6 total)