Hi again

So I tried this out on the actual server (sp3), still the same

I also tried just selecting just the 1 column (the date field), in order to rule out...

that...

You might have a point there, I have just started as a DBA at this place and although the servers are either service pack 2 or 3, I bet the...

Yeah it displays fine on the data viewer, no trailing zeros

Thanks for your help so far by the way.

I might as well consider using the BCP commands via xp_cmdshell, although...

The convert code is more me trying to force it to work properly, its not actually doing anything because the column data type is datetime anyway.

I changed the output columns...

Here you go

How do I show that?

Which part do you mean?

With the data viewer added, the dates look the same as before (incorrect) in the .csv file,

but show properly within the data viewer.

Ok, lets deal with date problem first

I am trying to export data to .csv from a sql server 2005 sp3 table using SSIS. This export normally occurs using a BCP...

I just noticed it and its been happening all the time.. so in my mind it is still on topic. Personally I think its better to keep it in one...

The problem seems to be that it is combining to columns, the ID and the date are showing as one column,

such as

2008-11-29 01 01 40 890000000 322085

even in the column...

Lol, so there's two Dave Ballantyne DBAs. The Scottish one should surely be your nemesis now.. 😀

You may well have to hunt him down and destroy him whilst screaming "THERE...

I actually think the roundabout works very in terms of traffic calming, confusing at first but good once you're used to it 🙂

I post answers on another SQL Server...

Update:

Dave Ballantyne, well if you're not Scottish and you didn't work in Hemel Hempsted then it's definitely not you 🙂

I think the slow view is more down to general bad...

Some jumped up new DBA decided that too many people had sysadmin permissions, so he started revoking permissions..including yours....ring any bells? hehe

So anyway back to matter in hand...

I really don't...