i need to download a file over HTTP and get a xml file then upload it into SSIS.
Only 2 methods are available in SSIS: FTP and web method. How come there is no HTTP transfer task in SSIS? pretty strange.
then i found a script at
http://www.sqljunkies.com/howto/49e823fd-d126-4134-893d-1fd8bd3bd3ba.scuk
What kind of SSIS tasks do i need to perform this operation? I got the script above but I don't know where to key it in.
It goes in a script task.
-Jamie
|||ok i did the script task but how do i pass the variables remoteuri and the local filename to store to the script task?|||Put them into the ReadOnlyVariables property of the script task.
http://www.google.co.uk/search?hl=en&q=task+readonlyvariables&btnG=Search&meta=
-Jamie
|||the readonly variables i shld put
"remoteurl, localfilename"
then how i should set the remote url to http://yahoo.com/test1.xml
localfilename to "c:\test1.xml"?
i look at the urls but not much of help....make me more confused.
No comments:
Post a Comment