It doesn't matter where I script it from (QA or EM on any PC) the difference seems to be on the server options - but both servers are set up...

That's where I started - both servers are set up the same

That's just what I was after - many thanks

Thanks for the idea - I'll give it a go

Just answered my own question

Stuart

Many thanks for your help.

Stuart

We should all consider our selves thankful.

If you woke up this morning with more health than illness, you are more blessed than the million who will not survive this...

Many thanks - checked the advanced tab and that was were the problem was

Stuart

Sorry for the delay in giving you this info.

The problem was caused by a Sybase ODBC driver which was used when the package was called. A search on microsoft found...

Thanks for all you help - I'm now sorted it was a mail client problem on the server. Sadly we use groupwise

Stuart

Thanks - although not the answer it has put me onto the fact that email services had been started, they did not complete. Only checking logs on two servers highlighted...

No - the only way to re-start it is to re-boot, which still leaves me with the initial problem

It shows as being started there and in services manager. None of the Sql logs show that the service has failed to start or that any have stopped. Windows Event...

And as a post script - how about OLAP cubes and version controlling?

Stuart

Do you have set ansi warnings on ? If so, and you are 100% positive the data lenghts match i.e. char (20) into a char(20) field then set , then set...