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

Are the field names / types always the same, or do they need to be dynamic too?

There is no function which will look at a column of data and return you an appropriate datatype. This is something which Excel tries to do when it opens a...

I have not seen this error before.

Please post the code from your Script task.

How is Oracle involved in your package?

Never got to the bottom of it. Somehow, by some means, the problem stopped happening for me. I have no idea why. Seeing your post reminded me of just how...

You probably need to use a Script task to assign the text and access the contents of the variable - otherwise you'll just get the literal text in there.

OK, not quite correct for an OLEDB source.

First you need to assign the whole SQL string to a variable, then you need to change the Data Access Mode on your...