Sorry, I never did find out! People at my work don't know and never found a solution on th einternet.

Thanks Darren.

I've found the answer. I should be altering the column to numeric (14,2).

You're right. But the objective is a bit of a mouthful. Need something shorter with a bit of wit if possible.

Thanks for your suggestions Lynn and Antares686.

Hi Bill

Your idea has also been suggested as a solution, in addition to the renaimg of files, to the powers that be at my workplace. They'll decide what solution they'll...

Thanks for all your replies. Very helpful.

The FTP process is separate from the DTS package. We're actually going with Michael's Lee suggestion that the FTP process renames the file after...

We have used global variables as a way of specifiying our connections in our DTS packages. So when we migrate from one server to another, it's just a matter of...