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...

Use an Expression to set the SQL ... That will decode your variable for you.

Ah, yes, I see it now. That would require detailed knowledge of importing from XML, which I do not have, sorry:-) But, in SSIS, there's always a way ... it's...

Your example did not appear, but you should check out the Multicast transformation to see whether it gives you what you need ... one source to multiple destinations.

Perhaps this thread is relevant to what you are trying to achieve?

http://www.windows-tech.info/15/e7e4a96178d88c7e.php

OK, this is how I think it should work - not that I've done it before - so please excuse slight inaccuracies ...

1) Create two string package variables, 'FileSpec' and...

Surely this thread would be more likely to get a decent response in the BI forum?

Introduce an initial Execute SQL task which sets a package variable to, say, the result of running a query like this:

select count(*) [VersionCount] from table

where version = 'xxxxxx'

Then, after your...