dbTalk Databases Forums  

Using CDO in a DTS Pacakge

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Using CDO in a DTS Pacakge in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Russell Hardie
 
Posts: n/a

Default Using CDO in a DTS Pacakge - 11-21-2005 , 10:11 PM






I have a DTS package that uses an ActiveX script to create an instance of
the CDO.Message object and then sets the configurations using the url based
microsoft namespaces, such as:

objFields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") =
cdoSendUsingPort

All has been working fine and dandy, when all the suden, Saturday it broke.
I found that our ISP implemented a new policy that day
to NOT allow access to the internet from their hosting (or in this case
database) servers. They did this to keep customers who are VPN'ed
to they're servers, to "pass thru" to the internet and run their bandwidth
meter up.

This would be ok with me as the smtp mail server is hosted by them, BUT now
I cannot see microsoft.com, to get to the schema namespaces.

I have found a couple of internet code snippets discussing METADATA
reference tags to the cdosys.dll, but so far all errors out (I believe these
samples are really for using from an ASP page).

Any suggestions or solutions?

Thanks,
Russell



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.