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 |
|
Crowknee
Starting Member
5 Posts |
 Posted - 2005-08-30 : 05:14:12
|
| Hi All, I am developing a DTS package to import files into a table. The issue I am having is that when I try to execute my Data Driven Query Task, I get the following error : Error Source : Microsoft OLE DB Provider for SQL Server Error Description : Statement(s) could not be prepared. Disallowed implicit conversion from data type datetime to data type numeric, table 'mytable', column 'mycol'. Use the CONVERT function to run this query. .... Where mytable and mycol are valid objects in my db. I am not sure what is causing this as the column from the source is numeric and the destination column is numeric - I have no idea where the datetime is coming from. The only thing I can think of is that there is a limit to the number of parameters you can pass to the (say) Insert query, as I have 104 columns that need inserting. If I change the order of the columns in the insert statement, the columns in error change too (it only shows 3 errors). Any help would be greatly appreciated. Thanks, Steele. |
|
|
|
|
|
Data Driven Query Parameters Error