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!

Data & Imports Forums - SSIS/DTS
Forum to discuss using SQL SSIS or DTS to perform SalesLogix imports. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SSIS/DTS | New Thread

View: Search:

Author

Thread: Using SSIS to Insert records

SL106
Posts: 16

Using SSIS to Insert records Your last visit to this thread was on 1/1/1970 12:00:00 AM

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

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Using SSIS to Insert records Your last visit to this thread was on 1/1/1970 12:00:00 AM

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.

[Reply][Quote]

SL106
Posts: 16

Re: Using SSIS to Insert records Your last visit to this thread was on 1/1/1970 12:00:00 AM

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

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Using SSIS to Insert records Your last visit to this thread was on 1/1/1970 12:00:00 AM

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 ...

[Reply][Quote]

SL106
Posts: 16

Re: Using SSIS to Insert records Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Aug 09 12:38 PM

Thanks a lot for your reply, Phil.
I will install the provider... Hopefully it will fix my issue.

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 4/18/2024 4:46:21 AM