Dean,

Access will run the SP, but for some reason it will not update the DTSRUN string in the SP. It's wierd, I can type in the changes...

It is fighting me every step of the way!! I can cut & Paste my Dtsrun String to the command prompt and it will run fine, but when I...

Thanks Allen,

I can Execute the package at a command prompt, but I can't execute the xp_cmdshell from my SP. I should have access to it since I...

Andy,

One Problem was the table didn't have a Primary Key. Let me check a little more before I respond.

fryere

Thanks for the help. I have it working By updating MgmtLevel tables. I thought there might be a easy way to do it with a SQL Statement.

Thanks NPeters,

You gave me exactly what I asked for, unfortunately, after I looked at this I need something slightly different. I would like to pass an EmpNum to the...

Thanks Greg,

I think that I am going to get it to work. The input value that I was testing was an INT and it was giving me problems.

Thanks Again!...

Version Info : 7.00.623

I will take the suggestion & re-install the client tools.

Thanks.

Andy,

That was a good question. I learned a lot by trying to verify how I was logging on.

I finally got it to prompt me for a logon. However logging...