June 25, 2008 at 7:12 am
I am looking for a solution to doanload the zipped file from internet, unzip it and dump in to a table. Please help me.
June 25, 2008 at 5:42 pm
What it has to do with T-SQL?
_____________
Code for TallyGenerator
June 26, 2008 at 7:15 am
I have to do that using SQL Sever
June 26, 2008 at 4:12 pm
June 27, 2008 at 7:00 am
It might be easier, after installing some/any zip package on the server, to simply invoke if from t-sql (using xp_cmdshell) or the command line.
June 27, 2008 at 7:56 am
I tried something similar with sp_OAxxx and OLE object "MSXML2.ServerXMLHTTP". In spite of MS's insistance to have removed the size limitations in SQL2005 of VarChar, nVarChar,... etc. you will still encounter a problem when attempting to return data from an HTTP request that is larger than 8000 bytes (i.e., your ZIP file).
This could just be a problem with the old (deprecated) Extended Stored Procedure APIs, but, at any rate, the problem still exists with a valid access method (sp_OAxxx).
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply