Can you manually create a new file in the location specified?

Fantastic. Thanks again!

Do with it as you wish. 🙂

I do not have to deal with negative numbers but it is not to hard to explain, what changes would i have to make?

Always...

Mister.magoo, You sir are a beautiful human being. Need to run a few more tests but it all looks good. Thanks a lot!

SELECT ROUND(16499.00,0-LOG10(1000))

So its

SELECT ROUND(Result,0-LOG10(RoundingNumber))

IS that correct?

Thanks for all your help

Thanks. Thats almost perfect. However, it always rounds down. How can i get it to round to the nearest?

Figured it out, i was missing my slashes! Thanks again for all your help!

Hi Guys.

Thanks for all your help, sorry it has taken me so long to reply. I have been in bed with flu.

The IMEX solution looks like it will do the...

I managed to sort this problem out a few days ago.

It turns out that i was not setting the connection string for the excel connection properly.

I did learn...

Ok, i have managed to replicate the behaviour in a simple package that is easy to test.

I have package that contains a foreach loop container. That container is pointed at...

Anyone else got any ideas?

Just to echo the other Steve's, Selecting the data for export from a SP/View/Query and perform the truncation there.

Happy to help

Steve (From England)

Correct, but if i...

Just tested this functionality myself. In the dataflow, the source was set to the database and the destination was set to a text file. I had the same settings as...

Hi,

One thing to remember is that the first column in a flat file is usually Column 0.

If you have already taken this into account then you could use a data...