sql server 2008 - SQL code to download a file from an FTP -

-

does have way can download file ftp using sql server 2008 (don't want use ssis)?

is there better way using sql?

if have xp_cmdshell access can use http://www.nigelrivett.net/ftp/s_ftp_getfile.html


Comments

Post a Comment

Popular posts from this blog

python - ('The SQL contains 0 parameter markers, but 50 parameters were supplied', 'HY000') or TypeError: 'tuple' object is not callable -

-
import pyodbc,nltk,array cnxn = pyodbc.connect('driver={mysql odbc 5.1 driver};server=127.0.0.1;port=3306;database=information_schema;user=root; password=1234;option=3;') cursor = cnxn.cursor() cursor.execute("use collegedatabase ;") cursor.execute("select * sampledata ; ") cnxn.commit() s=[] j=[] x=[] words = [] w = [] sfq = [] pos=[] entry in cursor: s.append(entry.injury_type),j.append(entry.injury_desc) nltk.tokenize import punktwordtokenizer nltk.corpus import stopwords tokenizer = punktwordtokenizer() english_stops = set(stopwords.words('english')) in range(0,26): # filter stop words tokenizer.tokenize(j[i]) w.append([word word in tokenizer.tokenize(j[i]) if word not in english_stops]) in range(0 , 26):#converting tokenzied text ito string sfq.append(" ".join(w[a])) replacers import regexpreplacer replacer = regexpreplacer() in range (0,26):#pos tagging replacer.repl...
Read more

objective c - Language Translation API for iPhone -

-
i want implement language translation feature in iphone app, there api free can use, or other way this. google's translate api not free anymore. so, if want use free language translation api, here links: mygengo translation api: http://mygengo.com/api/ microsoft translator apis: http://www.microsofttranslator.com/dev/ speaklite translate api: http://www.speaklike.com/access-professional-translation-via-api/ webservicex translate api: http://www.webservicex.net/ws/wsdetails.aspx?wsid=63 this helpful: http://alwawee.com/wordpress/2011/07/03/objective-c-wrap-over-microsoft-bing-translate-api/
Read more

jasper reports - Fixed header in Excel using JasperReports -

-
how can create excel report fixed header using japserreports? mean need header fixed when scroll excel file. this possible adding couple properties in jrxml file each report. take @ advanced excel features freeze panes. if wanted freeze after first column header (down left side basically) this: <statictext> <reportelement style="sans_bold" mode="opaque" x="0" y="60" width="104" height="20" forecolor="#ffffff" backcolor="#666666"> <property name="net.sf.jasperreports.export.xls.auto.filter" value="start"/> <property name="net.sf.jasperreports.export.xls.column.width" value="110"/> <property name="net.sf.jasperreports.export.xls.freeze.column.edge" value="left"/> </reportelement> ...
Read more