Hi,

I want to pass the table name as parameter,

I am designing a dts package in sql server 2000,where i am trying to load data from one server to another server...

Thanks a ton Jack,

This is what i am looking for....

Hi,

This is the exact error I am getting

Server: Msg 8115, Level 16, State 2, Procedure dateadd1, Line 13

Arithmetic overflow error converting expression to data type datetime.

Hi,

It may be null,plese check some sample values below for the parameter

1987-06-30 00:00:00.000

Null

That is what we are trying now,like we are trying to avoid "not in " instead of that I am trying to use left outer join,but still I am not...