noeld, I finally came to the conclusion you had wich was to forget about DTS all together and just use osql.

This has fixed my syntax and results problem just fine...

Ok, reading through the sp_OA BOL files I found a critical point that is going to be hindering in my operation... 🙁

Only members of the sysadmin fixed server role can...

WOW, thanks for the reply, I'm going through the article right now 🙂 thanks again

-Francisco

Here is what I'm trying to do:

Execute the DTS package from a sproc, and still be able to get the values from the Output Parameters from the DTS... I couldn't...

noeld, I don't get any results back from BOL w/ a search for sp_OA am I seraching under the wrong keywords?

-Francisco

This worked as advertised... thanks so much for your help :D. next is looking at how to get back the DTS OUTPUT Variables 😀

-Francisco

thanks for that I will try it...

younsoha

to learn how to map the variable to a ? read this intresting article I found yesterday....

http://www.sqldts.com/Default.aspx?234

-Francisco

First of all thanks for your reply it helped point me in the right direction... i'm still having trouble here is the error that I keep getting back

DTSRun: Loading......

Found my solution here...

http://support.microsoft.com/default.aspx?scid=kb;en-us;295305

-Francisco

Thanks for the suggestions, initially I thought of using vbscript in order to simply just move the .mdb file over... but thought it might be too much overhead to simply...

I owe you big time Allen_CUI!

that was the answer 🙂 I want to say thank you!!!! man I've been cracking my head and didn't see that in BOL at all.......

Thank you Allan_Cui

your solution worked like a charm.... now I just gotta figure out how to make this proxy work right :). I no longer get an access...

the account that starts this account belongs to the administrators group (on the domain) but that group is not in the local administrators group. I suppose this must be...

the logins I have tried, my login (member of administrators / builtin), Administrator, SA, my sql login who is a member of sysadmin.

the exact error is Access Denied. 🙁 ...

as My myself or "sa" the procedure executes w/o fail. When I log in as my User who only has access to the procedure in DB1 it fails w/...