Thanks - I am familiar with the different ways to run the package.

What I mean is if I go to the development environment (SSIS/Visual Studio) and run the package...

SQL Server Integration Services

Deleted post

Both the production and QA SQL server services are logging on with the local system account.

That account is not directly mapped to the database in QA or production. Even...

Data Source=MYSERVER;Initial Catalog=MYDB;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;

Okay - I created a package on my QA server and the package is saved to the file system. When I run the package fro SSIS or from the stored...

Sorry - I meant to remove that. There was a line of code that was commented out that I removed before posting. The procedure runs in my test environment without...

Thanks for the response Phil.

The package runs fine on the production server when I run it from SSIS. It is only when I execute the stored procedure that I get...

Thanks Grant - I might give this a try when I have a chance. As I mentioned I was able to get the data I need so there is no...

Nobody is looking for a magic ID#. I am not creating this database it is already created. It is a database for an association management program and the members ID...

I browsed tha article and to be honest I am not sure I know enough SQL to write what I am trying to do in a way that would be...