|
sql_er
Constraint Violating Yak Guru
251 Posts |
 Posted - 01/11/2013 : 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! |
Edited by - sql_er on 01/11/2013 16:39:39
|
|
|
yosiasz
Flowing Fount of Yak Knowledge
USA
1608 Posts |
Posted - 01/13/2013 : 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)
