11/22/2024 3:55:08 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss using SQL SSIS or DTS to perform SalesLogix imports. View the code of conduct for posting guidelines.
|
|
|
|
Using SSIS to Insert records 
Posted: 12 Aug 09 5:05 PM
|
Hellom
I created a simple SSIS package to import data from a text file into a Saleslogix custom table, I have set the AUTOINCREMENT field to "on", but still got the following error messages:
Error: 0xC0202009 at Data Flow Task, OLE DB Destination [203]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Cannot insert the value NULL into column 'CustomTableID', table 'Saleslogix_Dev.sysdba.CustomTable; column does not allow nulls. INSERT fails.".
I guess I need to use SLX ole db provider, right? Could any one give me a hint on how to create a SLX ole db provider on SSIS? Your help is greatly appreciated.
Emily
|
|
|
|
Re: Using SSIS to Insert records
Posted: 13 Aug 09 4:33 AM
|
| When you Create your Target connection, don't choose SQL instead choose OLEDB and configure the connection the same way as you would configure it from an SLX Client. |
|
|
|
Re: Using SSIS to Insert records
Posted: 13 Aug 09 8:23 AM
|
Raul,
Thank you very much for your quick response. I think that is what I did. I dragged “OLE DB destination” from the Data flow destination panel, double click to create a new connection manager – from the provider pick list, I tried both "SQL Native client” and “MS OLE DB for SQL server”. No luck. Any ideas??? Thanks so much!!!
Emily |
|
|
|
Re: Using SSIS to Insert records
Posted: 13 Aug 09 9:27 AM
|
Create a new OLEDB connection for your package. Change 'Provider' to 'SalesLogix OLEDB Provider'.
For this to be available you do, of course, need the SLX OLEDB Provider to be installed on your SSIS machine ... |
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|