You´re welcome!

I´m glad my struggles and the gained knowledge really are useful for someone. Looking back, those months were some of the worst I had considering work :angry:

...and: In order to edit and view the DTS-Files, you need to download the "DTS Designer Components" from Microsoft.

Eeeerh, what do you mean with "building an expression"?

1.) The DB you want to pull data from is not on the destination Server? That shouldn´t be a problem, just fix...

That´s correct. I wouldn´t migrate the package but execute it within ssis with the "execute DTS"-Task.

Here you can find the DTS designer for BIDS:

http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_DTS.msi

To use you have the ADO.NET-connection, young padawan

You set up a valid ODBC Data source in your ODBC-Administrator. Then, in the BIDS in...

@sql Noob: Thanks for your reply.

I also did that:

Creating a DTS-Package and execute it within SSIS. SSIS DOES use ODBC, I can get my data, as long as...

We opened a MS support incident which didn´t give us any positive results so far.

Has anyone experienced a similar problem? I´m glad for every reply.

That´s definitely true

I intend to open a Microsoft support Incident, but I honestly doubt the can solve the problem...