Identical Tables "Insert Error: Column name or number of supplied values does not match table definition"
Posted on 2009-04-07
I wrote a stored procedure to dynamically build the insert statement as I am using it as part of an SSIS package. It only fails on certain tables, not all of the tables. I am testing right now and the frustrating part is that this worked yesterday. I copied the table from dev to my test environment and I am comparing test with dev. Obivously, they match since I copied the table from dev to test. I have been debugging through the code and the dev table, the test table and the staging table all match. They all have the same columns in the same order with the same datatypes. I am getting this error when I execute the stored procedure from the package. When I run the stored procedure in the Management Studio, I don't get the error. Any ideas???