Hi All,
I want to create DTS package in which
i will have source is MS Access file.
and import the data to my SQL Server
Database.
Now i want to pass full qualified path of
..mdb file thru SP parameter and then
execute the package thru SP itself.
How can i do this ? If any code sample
is there it would be great help for me.
Thanks & Regards
Malkesh

http://www.sqldts.com/default.aspx?210

However, if your MDB file is accessible to the server anyway then you
may want to consider creating a linked server to the database instead
and then importing the data using starndard SQL INSERT statements.

--
David Portas
SQL Server MVP
--

http://www.sqldts.com/default.aspx?210

However, if your MDB file is accessible to the server anyway then you
may want to consider creating a linked server to the database instead
and then importing the data using starndard SQL INSERT statements.

--
David Portas
SQL Server MVP
--

Thanks David,
But my requirement is that, client
will specify source file name which is
Access Database thru Application and
using that file i need to export all the tables
in SQL Server which is fixed (not pass at runtime).
So i need to create a SP and pass that source file path
as parameter. Now how can i pass that parameter in DTS package ?
--
Thanks & Regards
Malkesh


"David Portas" wrote:

You can also have the package dynamically allocate the mdb filename through
a Dynamic Properties task. You can also pass to DTSRUN the /A switch which
will populate a Global variable in the package. The package will then be
built to allocate the files name passed to the Access connection. If you
are using code anyway can you not use the object model to specify the
DataSource property og the Access connection before calling Execute()?

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Malkesh" <Malkesh (AT) discussions (DOT) microsoft.com> wrote

how to do that. As Allan stated, you can also use the DTSRUN exe to
pass a global variable as a parameter.

and parameterize the name as discussed above. If not, then you'll have
to construct the DTS transformations dynamically, using VB for example.

--
David Portas
SQL Server MVP
--