Hello all,
I want to be able to upload an excel file with the fields layed out a
certain way and create a database and a table and insert the rows from the
excel file into that table. I have everthing set up do do that except I
have to go into enterprise manager in order to import the excel file to a
database. After it is imported into a temp table I run the code to place it
where it needs to go.

How would I use the DTS through code and a file upload html control to get
this excel file into the temp db and name the table?

Thank-you,
Eric

You can easily build the package | Save it

You can then call the Package through code using the object model if you
wish.

Things to be aware of though

DTS is client side so resources are relative to the box executing the
package. e.g. A reference to a file on your X drive may mean next to
nothing to any other PC except yours.

Here are some resources for you to look at

Execution
(http://www.sqldts.com/Default.aspx?104)

Administration & Management
(http://www.sqldts.com/Default.aspx?105)

And

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

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


"Eric Throckmorton" <eric (AT) contractorsunlimited (DOT) com> wrote