Database transport error
by portedquery on Thu, Nov 27 2008 3:35 PM
Last Edit: Thu, Nov 27 2008 3:36 PM
I've made considerable progress over the weekend passing data into the database. Seems that the test function complains about the smalldatetime conversion, but when I send the data through the port, there's no problem with the date conversion. One problem still exists, and I'm not certain how to go about resolving it. When I process the file to the database table, it contains 435 records. However, the same record repeats in the database table 435 times. I set the scope in the database send panel to once per repeating element, but that I still have that issue. I'm attaching the output schema and a sample of the output data for your review. If there's something I need to change, please advise. I'm getting very close to having an end-to-end scenario!
I've now modified my map to reflect the correct schema, and am partially successful in inserting data. It fails eight records in for the following error:
MessagingException, Error in Send Port Message Processing for Send Port 'ddl_hos_01_db_out' : --> Error executing scope 'HOS/HOSData' : Incorrect syntax near ','.
I checked the data, and I cannot find any errant punctuation. I also rechecked the sql script, and that seems to be fine as well. Any thoughts?