Export to Table with variable name in MS-Access

#1

Hello,

I want to create a package which does the following:

1) Use a query with variable value in the WHERE clause (from a global variable content).
I already know how to do this.

2) Output the resultset into a new MS-Access - Table which has the same name as the global varable
content.

How can I achieve this? By an Active-X - Task; or by something more simple?

Thank You

Joachim

#2

You could use an ActiveX script task to create the table in
the access database using either ADO or DAO. Build the
statement to create the table using the global variable.

-Sue

On Fri, 02 Apr 2004 12:03:18 +0200, Joachim Hofmann
<speicher (AT) freenet (DOT) de> wrote:

Quote:

Hello,

I want to create a package which does the following:

1) Use a query with variable value in the WHERE clause (from a global variable content).
I already know how to do this.

2) Output the resultset into a new MS-Access - Table which has the same name as the global varable
content.

How can I achieve this? By an Active-X - Task; or by something more simple?

Thank You

Joachim

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

Export to Table with variable name in MS-Access

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

Export to Table with variable name in MS-Access - 04-02-2004 , 05:03 AM

Re: Export to Table with variable name in MS-Access - 04-02-2004 , 10:34 AM