Create a record in a MsSql database thru generator

Created: 25 Feb 2013 | Updated: 25 Feb 2013 | 2 comments

cyberdive Partner Accredited Certified

This issue has been solved. See solution.

Good Morning everybody,

My test envirronment is : Windows 2008 R2 64 bits, CMS 7.1 (Version 7.1.8400) Core I5, 16 Gb ram, SSD 128)

I'm a beginner to workflow, and I would like to connect to an external database to add a record in a simple table ( http://0101.nccdn.net/1_5/1bf/2c8/048/IT-L13---Bui... ).

When I arrive at the step 1-11, the system should propose me to generate the component "Write Records", but on my test server I have less options.

Does anyone have an idea why I don't have the full list of components ?

Thanks in advance for your help.

Regards

Patrick

Operating Systems:

Windows Server (2003/2008)

Discussion Filed Under:

Endpoint Management, Workflow Solution - 7.x, Workflow Solution, Features, Training, Troubleshooting, Windows Server (2003/2008)

Comments RSS Feed

Comments 2 Comments • Jump to latest comment

reecardo Symantec Employee

Create a record in a MsSql database thru generator - Comment:25 Feb 2013 : Link

a Primary Key is required on a database table to get the ReadRecordsByKey, DeleteRecordsByKey, and WriteRecords component in the Table generator.

If adding a Primary Key to the table isn't an option, you can get around this by using the Query/Script generator and just using an INSERT statement for the script.

SOLUTION

cyberdive Partner Accredited Certified

Create a record in a MsSql database thru generator - Comment:25 Feb 2013 : Link

Hi Reecardo,

Thanks a lot for the help, I have, again, learned something ;-)

Regards

Patrick

Create a record in a MsSql database thru generator

Comments 2 Comments • Jump to latest comment

Would you like to reply?

Links