• After building the INSERT QUERY, try to print it in debug mode and see if it looks correct..Then try to execute the query in management studio you could spot the problem quickly.

    .