Thanks,

My code as above;

public override void CreateNewOutputRows()
    {
        /*
        ...

Thanks Phil,

I need to use a Script Component so please can you give any advice on my question as it is stated.

I don't mind what type of source file it...

Thanks frederico_fonseca,

So what do I replace the 'MyOutputBuffer.PersonID' value with to get it to output the 'PersonID' value for that row (and then the rest of the rows?)

If it was...

Thanks but I'm not importing an Excel, it's an .xml file as shown above.

Thanks Phil for your feedback,

I've created an .xml file using the CustomerSales table from the AdventureWorks sample db.

I've posted a sample of this data below;

These are the steps I'm taking...

Thanks, I've seen all those but I can';t find one that I can use & get it to work.

Forget it, thanks

Thanks but all I want to do is use a Cursor to copy a table row by row to a folder on a server drive.

Can you help with that?

Thanks

Ok, I've changed this to a script using a cursor.

What can I do to get this Adventureworks table to save into nominated folder? (I'm using a folder on my PC...

Thanks Thom A,

The use of 'C' is just for this purpose, it's actually on a Server.

Appreciate your advice, can you help with the Proc script though?

Thanks

Thanks Thom, I thought I had done something wrong or had some compatibility issue.

All good now.

Thanks frederico, I expected to see SSIS available without any extra files.

Appreciate your help.

I've already been all over the internet, the info I've found bypasses the actual connection part which is why I'm on the forum. 
If you can't help or don't know,...

Thanks again,

Re the info about User account as administrator, do you anything with a step by step approach to do this?

.....to add you user account...

My apologies Thom, I tried to find a way to delete the original but couldn't find any way to do it.
Peter

Thanks Eirikur,
I have Windows 7 as an O/s, using SQL Server...