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 |
|
lemondash
Posting Yak Master
159 Posts |
 Posted - 2010-02-24 : 06:07:03
|
| Morning all,Really hope so body can help me, also at the same time I can explain what I’m trying to. Here is what I’m trying to do, make a call to website URL every day to obtain a .csv file which will have one row of data and insert into a database, the part I can't get working is passing yesterdays date to the URL. I have the URL as a variable and have got yesterdays date as a variable but it just doesn’t work. For some strange reason my URL is not picking up the yesterdays day variable. Any help would be great. I used this as my starting point in creating the SSIS package.[url]http://consultingblogs.emc.com/jamiethomson/archive/2006/05/31/SSIS-Nugget_3A00_-Import-data-from-a-website.aspx[/url] Cheers Lee |
|
|
|
|
|
Http download of a file