Hello,

I am working transforming data from multiple Excel files to SQL Server 2000.
Here is the setup:
1. My SQL Server is on a diff computer named DBServer
2. My computer is MyComp
I open the DTS in Enterprise manager from my computer and setup the DTS
package. When i setup connection to Excel, i need to select the Excel file,
the path I enter is ("c:\data\file.xls")
All is ok, and I run it successfully. I saved the package and over.

If i run this package from my computer then its ok, what if I got to some
other computer and run this? where will it find the file from (my comp is
switched off)? So the question is can I select a path (to excel file ) on
the DBServer? It doesnt allow, it picks from the local computer only. I copy
the file to DBServer and If i share the folder from the DBServer and connect
as \\DBServer\Data\File.xls it works. but is it appropriate (or the only way
out?) It means i need to copy all the files to server in order to access
them?

Thanks in advance
--
Ashok Gupta - ashi
This posting is provided "AS IS" with no warranties, and confers no rights.

Thanks for the reply.
So you mean to say I sd be using \\computer\path\file.ext type names for
location , right?
One more thing, if the the dts runs as a sheduled job in sql server in that
case the files will be searched relative to the sql server.

--
Ashok Gupta - ashi
This posting is provided "AS IS" with no warranties, and confers no rights.
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Yes. Scheduled = On the server

http://support.microsoft.com/?kbid=269074

--

----------------------------
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



"Ashok Gupta (sujashi) >" <<ashokghr/hotmail/com/> wrote

Right Click on the Data Transformation Folder in EM | Open Package |
Navigate to the file and double click it | Enter the password given for it
on the website.



--

----------------------------
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



"Ashok Gupta (sujashi) >" <<ashokghr/hotmail/com/> wrote

Well Well, I scanned almost all the menus, sub menus there but seems like
that got skipped.......amaging.

Thanks

--
Ashok Gupta - ashi
This posting is provided "AS IS" with no warranties, and confers no rights.
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote