| Martin soory for the late ness in replying but its best if the two servers are linked and you use the sql agent to fire the job at a specific time during the day. Im not to up on firing DTS packages from with C#.
You say that its not arriving as you expect it, if you expand on that i might be able to help.
you could call the dts job from a stored proc that way your code can just fire that off, di you have a way of working out if the job failed etc
R |