Article ID: 275255
Article Last Modified on 10/31/2003
APPLIES TO
- Microsoft SQL Server 2000 Standard Edition
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q275255
BUG #: 58450 (SQLBUG_70)
BUG #: 236440 (SHILOH)
SYMPTOMS
When you create a Data Transformation Services (DTS) package (either through the DTS Design interface or through the Import Data Wizard), which transfers data from a table with a nullable BINARY source column to a nonnullable BINARY source column, the DTS interface incorrectly shows the column mapping on the destination table to be TIMESTAMP.
WORKAROUND
The base table schemas are not affected by this bug. That is, the package runs correctly, and does not change any base data types in either the source or destination tables. Therefore, to work around this behavior, ignore the column mapping and proceed with the package creation and execution.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
MORE INFORMATION
Steps to Reproduce Behavior
- Create two tables, one with a BINARY field that is nullable named DTS_Nullable, and one with a BINARY() field that is not nullable named DTS_NonNullable.
- Populate these tables with data to test the package execution.
- In the DTS Designer, create a package that transfers data from the DTS_Nullable table to the DTS_NonNullable table.
- When you click the Destination tab in the Transform data Task Properties dialog box, the destination column mapping for the BINARY field displays as a column of data type TIMESTAMP.
- Run the package and examine the data in your destination table.
- No data types have changed, and all the data was copied intact.
Keywords: kbbug kbpending KB275255
