Nice work and no problem - I don't think I helped much. By the sound of it, you already know way more than I do anyway! Glad that you tracked...

Two derived columns seems like the easiest way to me.

If you need help writing the expressions, post back. But give it a go, it's not too difficult.

The error message specifically mentions SQL Native Client - making me wonder whether you tried to connect to Oracle using the wrong provider ...

Can you use SQL Native Client to connect to Oracle?

Actually it's more elegant than that.

Create a Foreach container with 'item' enumeration and add the folders' names as items in column 0.

Then map a variable to this column.

Then plonk your...

Not that similar! Two file system copy tasks would seem to meet your requirement.

Do it as an Execute SQL task after the data flow - ie, on the Control Flow tab.

John Marsh (7/12/2009)

---

Hello,

There is probably a more elegant solution but as a workaround you could edit the Mappings to the Destination Table, to ignore the first and last Input Columns.

Regards,

John...

By "achieve", do you mean how do you unpack it? Sounds like a derived column to me. What's the unpacking algorithm?

Sure thing. Edit the Foreach container, click on Collection, select Expressions and set the Directory and Filespec properties to retrieve the contents of your variables.

You could try a FOREACH container - put your File System Task in it and it should move all of the matching files one by one - after just a...

Please post the full error message, not just the codes.

When your source data is already in a single database there is no need for a merge join ... just write a query to bring out the data that you...

You need to create the new variable outside of the script task first - same as creating your other variable. Your script task just sets its value.

For the script task,...

There is a thread here - and specifically a post by NaffMonk - that seems relevant to what you are trying to do.

http://www.sqlservercentral.com/Forums/Topic531295-148-2.aspx