December 20, 2016 at 11:59 am
We have a few vendors who refuse to push us files. As a result we have a few FTEs that spend a few hours daily and weekly logging into Vendor websites then selecting the date range in which we want data for and downloading that file to a share where an SSIS FF Conn Mgr can access it.
I have found several tutorials showing how to get a file using the HTTP source connection but how could I handle the date ranges in which I need the data filtered on?
Many thanks!
December 23, 2016 at 2:15 pm
Vertigo44 (12/20/2016)
We have a few vendors who refuse to push us files. As a result we have a few FTEs that spend a few hours daily and weekly logging into Vendor websites then selecting the date range in which we want data for and downloading that file to a share where an SSIS FF Conn Mgr can access it.I have found several tutorials showing how to get a file using the HTTP source connection but how could I handle the date ranges in which I need the data filtered on?
Many thanks!
If it's even possible, it would depend on the vendors site. If they exposed things through a service in some way, that would make things easier and be ideal but sounds like that may be very unlikely.
Since SSIS really isn't going to be able to interact with the sites, the only thing I can think of would be if they happen to use query strings for the date parameters, you could build the connection string using that. I don't think there is even a way to do a total kluge with the flakey and unreliable sendkeys just because of issues with input focus.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply