"Shyam" <Shyam@discussions.microsoft.com> wrote in message
news:868BC33B-215D-4E03-BFDD-87441E2A1425@microsoft.com...
> Hello,
> I've a problem in DTS.The following is the scenario:
> The DTS which i developed is scheduled to run every day thru JOBS.
> The DTS has to check for the new data which has come in the past 24hrs and
> it connects between Oracle and SQL Server.
> So,when ever the new data comes fromOracle to SQL server,the value passed
> in
> the DTS script is something like this (for Eg:x='500').
> When the DTS runs for the next time,the value should get refressed as
> X='?'
> and the new value is replaced instead of question mark(?).
>
> I tried to solve this situation using one DTS,but it was not successfull.
> The solution for this is only by using 2 DTS package.
> Could some one help me in resolving this scenario using only one DTS.
> I think this is bug in Microsoft DTS architecture.
> Also,tried this with few MVP's(SQL Server) and Sr.SQL developers.No
> profits
> at the end!!!
>
> Regards,
> shyam