Hi, everyone,
I want to upload 'Route Versions V2' by DMF.
So I exported the file by DMF and I impoted in DMF.
But it was faild to import.
For your reference, I send the screen.
Please check and let me know the way to upload ASAP.
Thanks
Hi, The issue will be in your file as the duplicate is detected in staging table not route version table. Please check index of this staging table and verify if your file has duplicate records.
There is no data in Route Version table..So I think there is no duplicated data..
What's the problem? T,T
By looking at the log, there's a duplicated record causing failure. Can you fix that in data and try again?
Here is the Execution log.
<?xml version="1.0"?><Errors><Error><ErrorCode>-1071636471</ErrorCode><SubComponent>OLE DB Destination [82]</SubComponent><Description>SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'I_9199STAGINGIDX'. Cannot insert duplicate key in object 'dbo.ROUTEVERSIONV2STAGING'. The duplicate key value is (5637144576, ROUTEALL, ROUTEALL-2023-04-11T23:13:16-A14D2B0B77AC4BA5860F0F5654893C14, 0.000000, Jan 1 1900 12:00AM, VD11_1301419, , , 1100, , , , 35834642100DG, 0).".
</Description></Error><Error><ErrorCode>-1071607767</ErrorCode><SubComponent>OLE DB Destination [82]</SubComponent><Description>SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "OLE DB Destination.Inputs[OLE DB Destination Input]" failed because error code 0xC020907B occurred, and the error row disposition on "OLE DB Destination.Inputs[OLE DB Destination Input]" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
</Description></Error><Error><ErrorCode>-1073450974</ErrorCode><SubComponent>SSIS.Pipeline</SubComponent><Description>SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (82) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (95). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
</Description></Error></Errors>
Thanks
Hi, Do you have any logs in View Execution log?
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156