July 25, 2016 at 10:44 pm
Hi!
I'm wondering if it's possible to enlarge a url using SSIS, actualy i have a database full of url, for example:
http://bit.ly/1dNVPAW (short) which large url is (www.google.com).
i would like to convert that and insert in my database again, based on the first url,
it could be possible? please help me, i dont have too much experience using SSIS. Thank you.
July 26, 2016 at 12:12 pm
I don't think there is anything native to SSIS for this and I'm not sure this is really an SSIS task as much as a coding task. But it doesn't mean you can't write a CLR function or have another external app of some kind to do this.
However, how to do it really depends on what URL shortening service you are using. There are many of them. Your example is using Bitly and they do have an API available which can be used to expand a URL. Most of the other services do as well and there are examples up on CodePlex for some. Some of the APIs require you to provide a login, some require registering you application with them, some require money, some have free examples, etc. How it's done really depends.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply