you suggest me to read individual fields from file, put in variables using Script and then use INSERT clause in Execute SQL task

Am i correct?

Thanks Koen...

Do you have any inputs on the below:

1.I need to read data from Flat file, convert into XML string and load into XML column in a SQL table.

My Data...

Thanks Joen.

Let me try with scripting and get back to you with results 🙂

Thanks Joen

I tried that too. Stored all rows of a single column in an Object variable.

How to assign this object variable to array variable inside the script

The Web service consumes...