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: Help please !!! on SLX Updates

gopal
Posts: 1

Help please !!! on SLX Updates Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 29 Apr 08 2:18 AM

Hi all ,

Iam in a critical stage of the project where we have tumbled into a problem .
Please help .
We have updated the saleslogic Accounts from external source using dts, which is basically for sync .
We did it sucessfully . But the history table doesn't update automatically , even if we use slx oledb .
We need the history table because this help to sync the external clients .
During the nomal entry , history table is updated automatically .
1. Do we need to insert into history table ? Is this the only way ?
2. Is there any better method to do ? if yes, how to do it ?

Pls help ...

Thank you,
Gopal

[Reply][Quote]

Walter Shpuntoff
Posts: 167

Re: Help please !!! on SLX Updates Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Apr 08 4:15 AM

You are working at the table level, so there is no reason for anything to be generated in history when you update the account table via the provider.

If you want to create history entries, then you need to create them with your DTS/SSIS.
Inserting records has one gotcha though - go into the history table in (SLX) database manager and make sure that the HistoryID column is set to AutoIncrement. Then apply that change and REBOOT your SalesLogix server. (In theory you can just restart the service, but that never seems to work for me).

Then you should be able to create an insert for every account you have changed.

HTH

ws

[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): 11/22/2024 4:44:46 AM