I have an xls file that I want to import into a table within sql2000. I have built a DTS that does a simple column copy with a lookup to import the data and everything works fine, locally.

However when I try and set up the dts on the hosts sql server it only gives me the option of connecting to a local .xls file....can I not connect via ftp or something to import the file?

any help appreciated...my first time with DTS so be gentle...lol

John Pether

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

DTS will see the file as it would from the client.

So even though the package may reside on a server in New York, If I open it
up in London and ask about the Excel spreadsheet it will look from my
perspective so if the sheet is defined as c:\MySheet.xls it will look on my
local drive. UNC paths are generally better for things like Excel/Text file
locations.

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"John Pether" <john@<nospam>dotnetsites.net> wrote

data and everything works fine, locally.
via ftp or something to import the file?

ok,

what i wanted to do was ftp the excel file to the ftp folder each day and have the DTS import it from there....as it will be a daily import and the sheet will be sent from different locations. Are you saying that DTS can only import an xl file from a client connected via enterprise manager?

This would cause a problem because the customer uploading the file does not have sql installed locally.

Any suggestions on how I should proceed?

Thanks for your help

John Pether

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

ok

thanks for the pointers, I will have to contact the hosting company and see if it can be sorted, i doubt that sql and the website will be on same machine but probably same network so no reason why it cant be done.

Just whether they will do it.

Am I approaching this the right way or are there other options I should be considering?

Thanks again

John Pether

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...