I am used to working in an Intranet where I have access to all the
pieces, but now I am working with the Internet and am stuck.  I receive
various datafeeds in the form of a CSV file and need to get that data
into a SQL Server database on my host.  On my development machine I put
it in Access for testing my code.  But now that I am done testing I
have to get the data to the real database online.

I don't know how to get the access/CSV data into Sql Server on the
Internet.  I'm not sure where to start. 

Thank you for any help.

Hi,

it depends on how your mechanism is to import the data into the
database. If you use the enterprise Manager and DTS to import, just try
to do the same as on your current server, trying to host your file
somewhere and specify it with the http adress where it is hosted on.
(Don´t know if htp is supported in DTS)

Another option would be to copy the file via FTP to your server and
specify the local path for importing the data, wheter using DTS or a
linked server to import the data. There are several options to do this,
but its hard to evaluate one without knowing more details.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Do you mean ftp the local .mdf and .ldf files from my development
machine to my Internet server?

Hi

May be look at replication?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replsec_5ad0.asp

John

Show quoteHide quote

Hi

One method would be to have a scheduled job that runs a DTS package that
will check for files in a give directory and then load them up. You could use
FTP (possibly through a ASP component) to move your files to the location. If
you schedule you job to run periodically then it could pick up the file
without further intervention or you could start the job off manually (say
through a button on your ASP page). As the location that the file is
deposited is probably on the IIS server and not the database server, you will
need a method that will securely allow your database server to see this
directory without compromising the database server.

John



Show quoteHide quote

Stop & Start SQL Server for using scm
expectations for SUM query on 50+ million rows
Internal SQL Server error
Trusted Connection failing
Memory allocation in MS-SQL 2000 instances
Windows says SQL is installed, but it's not!
Why do Ado.net don't use execution plan that Query Analyzer
Move 2000 to 2005
Query suddenly becomes very slow
Stored procedures in master database SQL Server 200/2005