XML request/response over http in ssis

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 2005 Forums

SSIS and Import/Export (2005)

XML request/response over http in ssis

Author

Topic

munafbhai
Starting Member

3 Posts

Posted - 2007-09-06 : 09:42:52

Hi,

I've a xml file which I need to send over http to another server. The other server processes xml file and sends back xml response over http.

How can this be achieved in SSIS.

Thanks

Manish

Kristen
Test

22859 Posts

Posted - 2007-09-06 : 10:08:51

I use httpxml for this type of thing - i.e. from the web page, rather than directly from SQL Server.

Kristen

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-06 : 10:39:23

plus i don't think SSIS can do this.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

karuna
Aged Yak Warrior

582 Posts

Posted - 2007-09-06 : 13:43:41

Did you check the web service task?

Thanks
Karunakaran

munafbhai
Starting Member

3 Posts

Posted - 2007-09-06 : 16:00:48

I don't want web service task. I was just wondering whether we have a http listener service by which I can expose or consume HTTP request/response.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-09-06 : 16:06:31

no.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp