I will need to create a DTS to import an excel file. I will need 2
parameters( excel file name and an ID)
How do you create the package with these variables.

Thanks

There are a few ways and you have not told us which version of SQL Server
DTS so here goes with a few ways .

2000:

Dynamic Properties Task
DTSRUN with the /A switch (assign values to Global Variables which you then
assign in the package to a property)
Object Model

7:

Datapump task
Object Model

Have a look at the site www.SQLDTS.com. Here we have examples of a lot of
things in DTS

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Daniel" <daniel.brochu (AT) hp (DOT) com> wrote

Hello,

How is the issue going on your side? Does Allan's suggestions meet your
requirements? Let us know if you need further assistance.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

v-yshao (AT) online (DOT) microsoft.com ("Yuan Shao") wrote in message news:<#LJ5LhU9DHA.2100 (AT) cpmsftngxa07 (DOT) phx.gbl>...
I am using SQL 2000
I replaced the file Name with the variable.
When I ran the DTS, I got the following error:
The Microsoft Jet database engine could not find the object (sheet
name). Make sure the object exists and you spell its name and path
correctly

Hello,

Thanks for your feedback. According to the error message, it seems that the
file cannot be found. Please check if the file name and the path are
correct. In the meantime, please check and see if the file is existed in
the folder which you located.

Does it fix your problem? If not, I would like you to provide the detailed
information regarding the DTS package and the variable so that I can fully
understand the problem and perform further research.

I am looking forward to hearing from you soon.
Best regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

v-yshao (AT) online (DOT) microsoft.com ("Yuan Shao") wrote in message news:<jnV8Emf9DHA.3736 (AT) cpmsftngxa07 (DOT) phx.gbl>...
Yes the file exists. If I put file file name it is working fine. When
I replaced the file name with the variable containing the filename I
got this error