Extract fields from string

[lbertoldi]

Hi there, I want to use your SQL integration to execute some scripts in a db.
Problem is that I only have an OleDb connection string (read from registry) while your SQL Server integration requires each field to be configured separately.
So, from this string "data source=xyz;initial catalog=mydb;user id=sa;password=myown" I need to extract each field in order to pass them to the SQL Server action.
Is there a (easy) way to achieve this?
Thanks
Luca

[giaviv]

Dear Luca,

There is no straight forward way to achieve this. You would have to use the Parse String command multiple times in order to get to your fields.
Let me know if you can't figure out how to do this and I will help.

[giaviv]

Sorry guys - second attempt at uploading the script: