I'm trying to put together a DTS package to export data from SQL Server (2k) into a CSV file that I can in turn import into MySQL.<BR><BR>The problem I'm running into is SQL Server exports NULL values ...

In contrast, a regular INSERT statement retains the null value instead of inserting a default value. The INSERT ... SELECT * FROM [OPENROWSET(BULK...)](../../t-sql ...

On a table using the sql builder I added a filter to only display rows where a date column is null and ended up with SQL that looked like this. A value can never ...