DTS Export SQLto Access

#1

I am trying to export records from a table in SQL to MS Access for specific
field (AccountID) in my table. I need to dynamically pass the value to the
package when triggering the package from an asp page. I am able get this
work statically but am having trouble making this happen dynamically. I have
been looking at the dynamic properties task but cannot figure out how to use
it in this scenario.

--
Daniel Higdon

#2

Create a global variable that can hold the AccountID. Set teh variable from
ASP after loading and before calling execute.
Change teh SQL to use a paarmeter placeholder (?) in the DataPump Task, then
click parameters. Map the variable to "Parameter 1"

SELECT ColumnName FROM AccountTable WHERE AccountID = ?

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

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

Quote:

I am trying to export records from a table in SQL to MS Access for
specific
field (AccountID) in my table. I need to dynamically pass the value to
the
package when triggering the package from an asp page. I am able get this
work statically but am having trouble making this happen dynamically. I
have
been looking at the dynamic properties task but cannot figure out how to
use
it in this scenario.

--
Daniel Higdon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Export SQLto Access

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Export SQLto Access - 04-20-2005 , 04:49 PM

Re: DTS Export SQLto Access - 04-21-2005 , 03:35 AM