I have finally managed, after struggling for many, many, many hours, to get SSIS to pull data from JDE and enter it into an SQL database.
I will post the full tutorial at a later date, but I wanted to address the main issue i faced in this whole painful ordeal :
[OLE DB Destination [1070]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
You need to make sure the Data Conversion datatypes match the expected datatypes AND length exactly for the destination, for example, if the SQL field is a type of varchar with a length of 50 - the Datatype conversion in the Data Conversion Transformation Editor must be set to string[DT_STR] with a length of 50
A list of associated datatypes can be found here : http://msdn.microsoft.com/en-us/library/ms141036.aspx
ReplyDelete