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, sql import, sql and c, import sql, data source sql, sql server import text, text file import sql server, php sql 2000, sql server script import, import data ftp sql server, import sql ftp, sql server import txt, text sql, sql server script import data, import script ftp, sql server ftp import, script sql table, data data sql, php sql txt, ftp sql table, txt table php, sql import data file ftp site, import data site php script, directions location, ftp text file sql server server

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