January 13, 2010 at 4:29 pm
I have set up a new website for a client using eWay payment gateway XML web services. Part of the set up include their Rebill service (recurring billing).
However to keep the future payment transactions up to date in my SQL website database i will need to create a SSIS package that runs daily to check for failed/successful future payment transactions in order to update my backend with the status the next day after eWay processes the transaction for recurring billing.
Has anyone:
1) Set up SSIS packages using Web Services (general question). If so is there a good video or online tutorial you can point me to for bulding a basic web service package?
OR
2) Set up a SSIS package specifically using eWay web services that they can help me with?
January 14, 2010 at 8:11 am
[font="Comic Sans MS"]
Simple Ones:
----------------
http://www.codeproject.com/KB/database/webservicessis.aspx
For more/complex w/s see:
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/61360/
http://www.technade.com/2009/08/how-to-call-wcf-service-using-web.html
Hope this helps 🙂
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
January 14, 2010 at 8:15 am
sabyasm (1/14/2010)
[font="Comic Sans MS"]Simple Ones:
----------------
http://www.codeproject.com/KB/database/webservicessis.aspx
For more/complex w/s see:
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/61360/
http://www.technade.com/2009/08/how-to-call-wcf-service-using-web.html
Hope this helps 🙂
[/font]
Hot linked for those who don't like to copy/paste:
http://www.codeproject.com/KB/database/webservicessis.aspx
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/61360/
http://www.technade.com/2009/08/how-to-call-wcf-service-using-web.html
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply