Thanks Dood

That worked perfectly.

I had created the table from the schema of another database, but it was showing up in the User table list in the MSDB database. I wanted...

Yes, both account have the same level permission.

Anything else to look at?

Andrew SQLDBA

HI George

Yes, the AD accounts are the same on both boxes. Right now for the troubleshooting, I have granted the accounts on both boxes to the admin level permission level.

I...

I am not saying that is what for "Absolutely Certain, 100%" was the fix, but once I did that, the package started using the values in the XML config.

This is...

Found a fix for this issue:

Once you change or edit the config file, and then copy it up to the SSIS server, you need to remove and add the file...

Then it is time to rebuild the workstation. If this has not been done lately, it is way past time. There is something on it that is conflicting, or some...

You have not stated what the OS actually is. SQL Server 2005 is not an OS.

Is this a web app? or a GUI app? What language is the app written...

You can do that. I thought the same thing, until I started looking thru the actual XML code that is generated. All that you really have to do is place...

Since this is on your own workstation, I would have removed SQL and reinstalled, plus all service packs. Would take about a full hour.

I would have been done and back...

Exactly, you should never allow a connection to consume resources when it is not being used. That is the big drawback to the old fashioned ODBC. Eventually SQL will run...

You can read the code of the query, and translate to t-sql. There is not very much difference in the actual languages. Most of the difference that you will see...

You can get rid of the old fashioned ODBC connections and use the more modern OLEDB connections. That could be part of the problem in transferring data back and forth.

What...

I just noticed this in your post. The CPU goes from 1 to 90 percent. What else is running on that box? Is this a spike? or a constant? What...

What does SQL Profiler tell you about the query? Use that and it will tell you what the query will do.

There is always room for improvement in a database. Do...

ok, so you actually have a table named "query1" something or other?

You cannot call another query from a query.

You can call a function, but not a query.

Andrew SQLDBA