can i put a kind of sign in it.?

yes, i have an indicator column on oracle server table which states that "LAST WRITTEN".

for me it will be really good if i develop ssis package on first stage, or...

Hi Lowel,

I understand your point,bu the thing is I can not delete/drop/truncate the destination.

there thousands of records, my source table is updated every day and i have to update destination...

I found this question also suitable under T-SQL tag so I also posted here.

I am sorry if there is any mistake.

Pratik.

ya...

One is in the SQL SERVER 2008 R2 and one is on the ORACLE.

I can not post the code,because I am developing it from this http://www.sqlservercentral.com/articles/EDW/77100/ article.

in this article author has used tables from same database.

In my case, one table is...

Hi ,

But the issue is when I supply full name into GUI of the stored procedure, it gives an error due to '.' (period) because one my table reside on...