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.
| Author |
Topic |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2013-01-11 : 16:38:56
|
| Hi guys,There is a REST API that once called returns the data set in the CSV format.I am trying to figure out the best way to implement that API call in SSIS so that a csv file can get returned and stored in a folder to be looped through and processed by the next step.Can anyone, who has made REST API calls from SSIS, provide some suggestions please?Thanks in advance! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-12 : 12:51:55
|
| Sounds like use of script task for me.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2013-01-13 : 00:00:25
|
| definitely a script task. Just did one and it was a bear. gotcha is that you cannot use web.config from SSIS. you have to carve up the bare binding var binding = new WSHttpBinding(); binding.Name = "WSHttpBinding_IYOURSERVICE"; binding.CloseTimeout = new TimeSpan(00, 01, 00); binding.OpenTimeout = new TimeSpan(00, 01, 00); binding.ReceiveTimeout = new TimeSpan(00, 10, 00); binding.SendTimeout = new TimeSpan(00, 01, 00); binding.BypassProxyOnLocal = false; binding.TransactionFlow = false; binding.HostNameComparisonMode = HostNameComparisonMode.StrongWildcard; binding.MaxBufferPoolSize = 524288; binding.MaxReceivedMessageSize = 65536; binding.MessageEncoding = WSMessageEncoding.Text; binding.UseDefaultWebProxy = true; binding.AllowCookies = false;your best bet is to try it out with a small client .net app then port over the code in SSIS<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
|
|
Calling REST API from SSIS (SQL Server 2008 R2)