HI Robert,

Thanks for the reply.. Yep I have logged onto both nodes & manually performed the winzip operation manually (switching the node at the same time)

Pete

Ah ok, I'll give that a go, I assumed because the F: drive was mounted from the SAN on both servers (one node offline one node online) that Iwould be...

Hi Aaron,

Thanks for your reply, sorry I didn't say... The directory is on a SAN which is attached to both nodes (F: drive)

What is strange is that the DTS job...

Can you run other DTS jobs on this server? If not have you had a look at what user SQL Agent is running on the server?

Hi,

Wouldn't it be simplier to call a stored procedure from DTS which accessed both the tables using a linked server.

Pete

Hi,

Could you modify your DTS packages to have a new dynamic properties task which modified the connection string using an incoming global variable. Thus when you called the DTS package...

If the field should not ever be null, shouldn't you change the field to have a not null constraint?

Hi,

To import the DTS Package itself into Sqlserver do the folloiwing in enteprise manager

1) right clcik on data transformation services

2) click open package

3) Find your file in the filesystem...

Shouldn't the statement

recordsupd = @@recordcount

be

recordsupd = @rowcount

Pete

oops mistype, I meant

recordsupd = @@rowcount

DOH!

Pete