Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Posting a file from ActiveX script within DTS pkg

Author  Topic 

renugrover
Starting Member

5 Posts

Posted - 2007-11-02 : 16:59:45
I have a zip file created automatically that needs to be posted to another server. All I got from the other part is the following:
-------------------------------
Test URL for Purchase Order submission
https://xyz.abc.com/invoke/process/receive_order?partner=cXML

Let me know when you send some over so that I can pull them form the logs.
--------------------------------


Can someone please help tell me what code I need to add to my activex script/DTS pkg to send out the ZIP file to this location?

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-02 : 18:03:06
Do you have access to that location? Will the SQL Server account have access to it? What options are available to move the file? Does it have to be FTP or can it be copy/xcopy DOS commands?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

renugrover
Starting Member

5 Posts

Posted - 2007-11-02 : 18:38:20
this location is on a business partner site. How do I test if I will have access to it via SQL Server acct? I cannot tell by looking at the URL if this is an FTP site or a web-service or what. All I got from the person requesting the information is

"you will have to post the file in the body of an https post."

Does not make much sense to me unfortunately.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-02 : 19:09:51
You'll need to contact them to determine this.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -