I've created a DTS package in SQL Server 2000 Enterprise Manager to
export the data in a table that has datetime fields using Task->Export
Data. I've specified Excel 97-2000 as the destination file for the
export, and I've let the dts export wizard configure the mappings.

When I run the package, the table gets exported, but all the datetime
fields in the spreadsheet have the time part truncated off - only the
date appears in the spreadsheet. How can I get the wizard to include
the time portion of the datetime fields?

Andy

I found that the time part isn't really truncated off during a DTS
migration when using an Excel spreadsheet as a transport vehicle. By
default, the date columns of the spreadsheet DTS creates are set to
display the date part of the datetime value. By selecting the date
column, and right clicking and selecting format cells, you can select
a time format that will display the datetime with both date and time
parts. If you save the spreadsheet in excel after this, you will also
be able to see the date/time values in Microsoft's Excel viewer.

If you are finding that DTS seems to migrate the dates okay, but not
the times, then the problem you may be experiencing is that the dates
are saved as GMT times, and you need to use timezones to read/write
the exported date data. Read about the .NET TimeZone and TimeSpan
functions in Visual Studio .NET's help file. These functions allow
your code to determine the timezone used on the computer the export
data arrived to, and expose a getUTCOffset method which returns an
offset which you can add to the date to adjust it for your timezone.

I found that the time part isn't really truncated off during a DTS
migration when using an Excel spreadsheet as a transport vehicle. By
default, the date columns of the spreadsheet DTS creates are set to
display the date part of the datetime value. By selecting the date
column, and right clicking and selecting format cells, you can select
a time format that will display the datetime with both date and time
parts. If you save the spreadsheet in excel after this, you will also
be able to see the date/time values in Microsoft's Excel viewer.

If you are finding that DTS seems to migrate the dates okay, but not
the times, then the problem you may be experiencing is that the dates
are saved as GMT times, and you need to use timezones to read/write
the exported date data. Read about the .NET TimeZone and TimeSpan
functions in Visual Studio .NET's help file. These functions allow
your code to determine the timezone used on the computer the export
data arrived to, and expose a getUTCOffset method which returns an
offset which you can add to the date to adjust it for your timezone.

I found that the time part isn't really truncated off during a DTS
migration when using an Excel spreadsheet as a transport vehicle. By
default, the date columns of the spreadsheet DTS creates are set to
display the date part of the datetime value. By selecting the date
column, and right clicking and selecting format cells, you can select
a time format that will display the datetime with both date and time
parts. If you save the spreadsheet in excel after this, you will also
be able to see the date/time values in Microsoft's Excel viewer.

If you are finding that DTS seems to migrate the dates okay, but not
the times, then the problem you may be experiencing is that the dates
are saved as GMT times, and you need to use timezones to read/write
the exported date data. Read about the .NET TimeZone and TimeSpan
functions in Visual Studio .NET's help file. These functions allow
your code to determine the timezone used on the computer the export
data arrived to, and expose a getUTCOffset method which returns an
offset which you can add to the date to adjust it for your timezone.

I found that the time part isn't really truncated off during a DTS
migration when using an Excel spreadsheet as a transport vehicle. By
default, the date columns of the spreadsheet DTS creates are set to
display the date part of the datetime value. By selecting the date
column, and right clicking and selecting format cells, you can select
a time format that will display the datetime with both date and time
parts. If you save the spreadsheet in excel after this, you will also
be able to see the date/time values in Microsoft's Excel viewer.

If you are finding that DTS seems to migrate the dates okay, but not
the times, then the problem you may be experiencing is that the dates
are saved as GMT times, and you need to use timezones to read/write
the exported date data. Read about the .NET TimeZone and TimeSpan
functions in Visual Studio .NET's help file. These functions allow
your code to determine the timezone used on the computer the export
data arrived to, and expose a getUTCOffset method which returns an
offset which you can add to the date to adjust it for your timezone.

I found that the time part isn't really truncated off during a DTS
migration when using an Excel spreadsheet as a transport vehicle. By
default, the date columns of the spreadsheet DTS creates are set to
display the date part of the datetime value. By selecting the date
column, and right clicking and selecting format cells, you can select
a time format that will display the datetime with both date and time
parts. If you save the spreadsheet in excel after this, you will also
be able to see the date/time values in Microsoft's Excel viewer.

If you are finding that DTS seems to migrate the dates okay, but not
the times, then the problem you may be experiencing is that the dates
are saved as GMT times, and you need to use timezones to read/write
the exported date data. Read about the .NET TimeZone and TimeSpan
functions in Visual Studio .NET's help file. These functions allow
your code to determine the timezone used on the computer the export
data arrived to, and expose a getUTCOffset method which returns an
offset which you can add to the date to adjust it for your timezone.

I found that the time part isn't really truncated off during a DTS
migration when using an Excel spreadsheet as a transport vehicle. By
default, the date columns of the spreadsheet DTS creates are set to
display the date part of the datetime value. By selecting the date
column, and right clicking and selecting format cells, you can select
a time format that will display the datetime with both date and time
parts. If you save the spreadsheet in excel after this, you will also
be able to see the date/time values in Microsoft's Excel viewer.

If you are finding that DTS seems to migrate the dates okay, but not
the times, then the problem you may be experiencing is that the dates
are saved as GMT times, and you need to use timezones to read/write
the exported date data. Read about the .NET TimeZone and TimeSpan
functions in Visual Studio .NET's help file. These functions allow
your code to determine the timezone used on the computer the export
data arrived to, and expose a getUTCOffset method which returns an
offset which you can add to the date to adjust it for your timezone.

I found that the time part isn't really truncated off during a DTS
migration when using an Excel spreadsheet as a transport vehicle. By
default, the date columns of the spreadsheet DTS creates are set to
display the date part of the datetime value. By selecting the date
column, and right clicking and selecting format cells, you can select
a time format that will display the datetime with both date and time
parts. If you save the spreadsheet in excel after this, you will also
be able to see the date/time values in Microsoft's Excel viewer.

If you are finding that DTS seems to migrate the dates okay, but not
the times, then the problem you may be experiencing is that the dates
are saved as GMT times, and you need to use timezones to read/write
the exported date data. Read about the .NET TimeZone and TimeSpan
functions in Visual Studio .NET's help file. These functions allow
your code to determine the timezone used on the computer the export
data arrived to, and expose a getUTCOffset method which returns an
offset which you can add to the date to adjust it for your timezone.

I found that the time part isn't really truncated off during a DTS
migration when using an Excel spreadsheet as a transport vehicle. By
default, the date columns of the spreadsheet DTS creates are set to
display the date part of the datetime value. By selecting the date
column, and right clicking and selecting format cells, you can select
a time format that will display the datetime with both date and time
parts. If you save the spreadsheet in excel after this, you will also
be able to see the date/time values in Microsoft's Excel viewer.

If you are finding that DTS seems to migrate the dates okay, but not
the times, then the problem you may be experiencing is that the dates
are saved as GMT times, and you need to use timezones to read/write
the exported date data. Read about the .NET TimeZone and TimeSpan
functions in Visual Studio .NET's help file. These functions allow
your code to determine the timezone used on the computer the export
data arrived to, and expose a getUTCOffset method which returns an
offset which you can add to the date to adjust it for your timezone.