Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
greatlakes
Starting Member
3 Posts |
 Posted - 2005-02-22 : 14:17:24
|
DTS is properly bringing data over to a database we have named 'Staging'. However, when we transfer over the data from 'Staging' to 'Dimension' within SQL Server, we receive multiple error messages during the load between the two. e.g. 'error converting data type varchar to numeric'andSyntax error converting the varchar value 'Active' to a column of data type intAny ideas??? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-22 : 15:13:29
|
| So you are trying to copy data into a different data type. Make sure that your destination schema matches the source schema.Tara |
 |
|
|
|
|
|
DTS not working within SQL Server