Viewing 15 posts - 1 through 15 (of 64 total)
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...
-Francisco
December 9, 2003 at 11:51 am
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...
-Francisco
December 8, 2003 at 4:56 pm
WOW, thanks for the reply, I'm going through the article right now 🙂 thanks again
-Francisco
-Francisco
December 8, 2003 at 2:04 pm
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...
-Francisco
December 8, 2003 at 11:27 am
noeld, I don't get any results back from BOL w/ a search for sp_OA am I seraching under the wrong keywords?
-Francisco
-Francisco
December 4, 2003 at 2:59 pm
This worked as advertised... thanks so much for your help :D. next is looking at how to get back the DTS OUTPUT Variables 😀
-Francisco
-Francisco
December 4, 2003 at 11:30 am
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
-Francisco
December 4, 2003 at 9:40 am
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......
-Francisco
December 3, 2003 at 4:20 pm
Found my solution here...
http://support.microsoft.com/default.aspx?scid=kb;en-us;295305
-Francisco
-Francisco
August 29, 2003 at 5:27 pm
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...
-Francisco
August 21, 2003 at 9:25 am
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.......
-Francisco
July 11, 2003 at 12:24 pm
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...
-Francisco
July 10, 2003 at 10:26 am
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...
-Francisco
July 9, 2003 at 10:29 am
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. 🙁 ...
-Francisco
July 9, 2003 at 8:43 am
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/...
-Francisco
July 3, 2003 at 10:18 am
Viewing 15 posts - 1 through 15 (of 64 total)