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!
|
|
Using a DTS to insert records into a SalesLogix table
Posted: 14 Jun 07 1:50 PM
|
Hi all.
Would someone happen to know how I can insert records into a SalesLogix table via a DTS?
My DTS will have a group of records that I would like it to enter into a custom table that has a one-to-many relationship with the ACCOUNT table (ACCOUNT --> MyCustomTable) it is joined by the accountid.
I would need it to also create the MyCustomTableid as it's inserting it. Any ideas?
Thank you in advance. |
|
|
|
Re: Using a DTS to insert records into a SalesLogix table
Posted: 15 Jun 07 9:14 AM
|
| Have you tried using an ActiveX script task or possibly an ActiveX script in the Transformation of a Transform Data Task. While I use DTS mostly for updating, you can create a connection using the provider in the script an potentially access the create id functions. |
|
|
| |
| |
| |
|