As far as I know, the actual code of your embedded custom components is not in the actual package XML file (*.dtsx).

(correct me if I'm wrong)

So it doesn't really make...

Can you try option 2 again, but now with the RetainSameConnection property of the connection manager set to True?

With a little luck, that should work 🙂

I don't think it is possible to do it directly.

You can however:

store the results sets in two table variables. Merge these two variables with a union all and add some...

Just out of curiosity: why are you using J#? Can it do something that C# or VB.NET can't do?

To clean your data, you can use the derived column transformation.

You can also use it to generate data (if it is not too complex, otherwise you can use a script...

I think it is not possible without upgrading your packages.

Or you should shut down your SSIS 2008 instance, start your 2005 instance and run your 2005 packages. And vice versa...

The last one is the correct method.

For linked servers (or server name in the 4 part name), you cannot use variables directly.

Therefore, you need to store your SQL statement in...

The section Estimated Row Size/Length of this article seems to contradict that.

It says that the length is determined by the largest possible values in the columns. Which makes sense I...

Nice question, definately learned something today.

However, if I run the query in SQL Server 2008 using the AdventureWorks2008 database, I get an extra result: the select query with the cross...

So, if I got this right, the following happens:

you receive 2 flat files:

one with data, and one with the table name of the destination table.

Right?

Read the flat file with the...

That is a concern.

But, if your SP returns a result set, you should have columns.

Try rewriting the SP with TOP 1 or something like that, so that it speeds up...

Can you explain your question a bit more? (see also the links in my signature)

What are you exactly trying to do? Move data from source to destination? What is the...

Execute the stored procedure in an OLE DB Source in a dataflow. Connect the source to an OLE DB Destination to write the results to the preferred table.

As far as I know, this is not possible with SSIS.

Maybe you can script it with .NET, but my knowledge is pretty limited on that part.

What do you exactly mean...

Nice question.