DB Insert Error

Diya · Post by **Diya** » Tue Aug 08, 2006 6:33 am

Hey guys...

Im getting the following error while trying to insert data(after creating the table through Dynamic RDBMS stage) into a table.

Warning:"[Microsoft][ODBC Driver Manager] Invalid string or buffer length"

Fatal Error:"SQLBindParameter: Failed to bind a parameter."

I checked all the job parameters but they seem to be fine

Can anyone tell me what is going wrong?

Thanks in advance,
Diya
Diya

ArndW · Post by **ArndW** » Tue Aug 08, 2006 6:36 am

You have most likely done your own SQL and the number of parameters does not match the number of columns.

Diya · Post by **Diya** » Tue Aug 08, 2006 6:39 am

No...Im using 'Generated SQL' by Dynamic RDBMS stage

ArndW · Post by **ArndW** » Tue Aug 08, 2006 6:43 am

Can you try to use your favorite SQL tool (or MSQUERY in a pinch) and execute the insert statement as it was generated by hand to see if the error persists? You could also post this SQL here.

Diya · Post by **Diya** » Tue Aug 08, 2006 10:19 am

I tried to insert some records manually...and it is working fine...
the SQL query generated by DS is like this

'INSERT INTO dbo.Error_table (column names ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)'

NBALA · Post by **NBALA** » Tue Aug 08, 2006 2:24 pm

Hi,

Check all the columns are mapped with required data type and length. Run debug and verfy the log.

-NB