Encerrado

SQL DTS

I need to be able to automatically import a text file into SQL Server 2000 from an FTP location. This must be automatically executed on a daily basis (say 3am for example) so I assume the best method to use would be a DTS package. Each file that is imported (as a new table) should replace the previous table. The text filename source is always constant. To summarize:

-source of [url removed, login to view] file is my ftp location

-import [url removed, login to view] into SQL and becomes a table named 'myfile' by default (replaces the previous day table)

Thanks!

## Deliverables

1) Complete script or directions that will 100% work (try it yourself first with some made up data first

2) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

SQL Server 2000

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: dts engineering, data source sql, sql server import text, php sql 2000, sql server script import, import sql ftp, sql server import txt, text sql, import script ftp, sql server ftp import, script sql table, php sql txt, ftp sql table, txt table php, directions location, php sql import, sql txt, php daily import, sql 2000, import txt sql, sql server script, php txt sql, sql server import, summarize script php, sql data txt import

Acerca do Empregador:
( 6 comentários )

ID do Projeto: #2982347

6 freelancers estão ofertando em média $15 para este trabalho

sawamu

See private message.

$14.45 USD in 2 dias
(215 Comentários)
5.9
vw706184vw

See private message.

$17 USD in 2 dias
(89 Comentários)
5.7
barreiro04

See private message.

$12.75 USD in 2 dias
(22 Comentários)
3.7
hendox

See private message.

$17 USD in 2 dias
(1 Comentário)
1.7
dotnetgodvw

See private message.

$12.75 USD in 2 dias
(1 Comentário)
0.0
cpapvw

See private message.

$17 USD in 2 dias
(0 Comentários)
0.0