I am using an already developed DTS package that I created for a new
database. Everything looks the same here. Except now I am getting this nasty
transformation message...

An error occurred when you tried to submit changes to this transform. Please
refer to the following error message and make sure that you have edited other
properties of this transform by pressing "Properties" button on the "General"
tab.

Error Source: Microsoft Data Transformation Services (DTS) Data Pump

Error Description : DTSTransformCopy: Schema validation failed; See Extended
Error information. TransformCopy '(no name)' validation error; Cannot convert
(possibly due to type or length mismatch) column pair 1 (source column
'RequiredToRead' (DBTYPE_R8), destination column 'RequiredToRead'
(DBTYPE_BOOL).

The 'RequiredToRead' column is in a SQL Server Table and is defined as a Bit
and on the Excel spreadsheet is defined as a 'General' field. And when I
looked back at my previous DTS I used to create this, it was defined the same
exact way. So now why is it throwing up on me???

HELP!!!!!

Any help is greatly appreciated.

Thanks.

PSULionRP

Is the SQL database the source or destination?

If it is the source, I can see no reason why DTS should assume it is
of type R8 (real). If the Excel spreadsheet is the source you might
have to do some legwork.. Basically, Excel tries to guess the data
type of a column based on the first 8 rows (by default) and often gets
them wrong. The thread linked below has some further information
regarding this issue:
http://groups.google.com/group/micro...c9d758010c9d32

Good luck!
J

Is the SQL database the source or destination?

If it is the source, I can see no reason why DTS should assume it is
of type R8 (real). If the Excel spreadsheet is the source you might
have to do some legwork.. Basically, Excel tries to guess the data
type of a column based on the first 8 rows (by default) and often gets
them wrong. The thread linked below has some further information
regarding this issue:
http://groups.google.com/group/micro...c9d758010c9d32

Good luck!
J

Is the SQL database the source or destination?

If it is the source, I can see no reason why DTS should assume it is
of type R8 (real). If the Excel spreadsheet is the source you might
have to do some legwork.. Basically, Excel tries to guess the data
type of a column based on the first 8 rows (by default) and often gets
them wrong. The thread linked below has some further information
regarding this issue:
http://groups.google.com/group/micro...c9d758010c9d32

Good luck!
J

Is the SQL database the source or destination?

If it is the source, I can see no reason why DTS should assume it is
of type R8 (real). If the Excel spreadsheet is the source you might
have to do some legwork.. Basically, Excel tries to guess the data
type of a column based on the first 8 rows (by default) and often gets
them wrong. The thread linked below has some further information
regarding this issue:
http://groups.google.com/group/micro...c9d758010c9d32

Good luck!
J

Is the SQL database the source or destination?

If it is the source, I can see no reason why DTS should assume it is
of type R8 (real). If the Excel spreadsheet is the source you might
have to do some legwork.. Basically, Excel tries to guess the data
type of a column based on the first 8 rows (by default) and often gets
them wrong. The thread linked below has some further information
regarding this issue:
http://groups.google.com/group/micro...c9d758010c9d32

Good luck!
J

Is the SQL database the source or destination?

If it is the source, I can see no reason why DTS should assume it is
of type R8 (real). If the Excel spreadsheet is the source you might
have to do some legwork.. Basically, Excel tries to guess the data
type of a column based on the first 8 rows (by default) and often gets
them wrong. The thread linked below has some further information
regarding this issue:
http://groups.google.com/group/micro...c9d758010c9d32

Good luck!
J

Is the SQL database the source or destination?

If it is the source, I can see no reason why DTS should assume it is
of type R8 (real). If the Excel spreadsheet is the source you might
have to do some legwork.. Basically, Excel tries to guess the data
type of a column based on the first 8 rows (by default) and often gets
them wrong. The thread linked below has some further information
regarding this issue:
http://groups.google.com/group/micro...c9d758010c9d32

Good luck!
J

Is the SQL database the source or destination?

If it is the source, I can see no reason why DTS should assume it is
of type R8 (real). If the Excel spreadsheet is the source you might
have to do some legwork.. Basically, Excel tries to guess the data
type of a column based on the first 8 rows (by default) and often gets
them wrong. The thread linked below has some further information
regarding this issue:
http://groups.google.com/group/micro...c9d758010c9d32

Good luck!
J