Basic: Passing Variable Question

#1

I have a DTS package where I declare a date (variable)
using Active X. I then call a table to be written to
Excel.

I want to pass the variable to Excel (Connection
Properties) filname for output (dynamic file name based
on date).

I don't know how to escape this variable. Any help would
be greatly appreciated?

Thanks...

#2

You could try creating the complete excel file name as another Global
Variable at the same time, then use Dynamic Properties to set the name of
the Connection Property.
If you are in script look up BOL and using GlobalVariables eg:
'Declare the package and global variable objects.
Dim objPackage As DTS.Package2
Dim objGlobal As DTS.GlobalVariable
.. . .
'Define the global variable.
Set objGlobal = objPackage.GlobalVariables.New("ALuckyName")
objGlobal.Value = "SevenSevenSeven"
objPackage.GlobalVariables.Add objGlobal

"Mike Anderson" <manderson (AT) nationalcarenetwork (DOT) com> wrote

Quote:

I have a DTS package where I declare a date (variable)
using Active X. I then call a table to be written to
Excel.

I want to pass the variable to Excel (Connection
Properties) filname for output (dynamic file name based
on date).

I don't know how to escape this variable. Any help would
be greatly appreciated?

Thanks...

#3

In message <ui3M4d7nEHA.2804 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Mary Bray
<reply (AT) tonewsgroup (DOT) com.NOSPAMPLEASE> writes

Quote:

You could try creating the complete excel file name as another Global
Variable at the same time, then use Dynamic Properties to set the name of
the Connection Property.
If you are in script look up BOL and using GlobalVariables eg:
'Declare the package and global variable objects.
Dim objPackage As DTS.Package2
Dim objGlobal As DTS.GlobalVariable
. . .
'Define the global variable.
Set objGlobal = objPackage.GlobalVariables.New("ALuckyName")
objGlobal.Value = "SevenSevenSeven"
objPackage.GlobalVariables.Add objGlobal

"Mike Anderson" <manderson (AT) nationalcarenetwork (DOT) com> wrote in message
news:26d201c49f50$2a0ad6d0$a501280a (AT) phx (DOT) gbl...
I have a DTS package where I declare a date (variable)
using Active X. I then call a table to be written to
Excel.

I want to pass the variable to Excel (Connection
Properties) filname for output (dynamic file name based
on date).

I don't know how to escape this variable. Any help would
be greatly appreciated?

Thanks...

Same principal as Access shown here, to do this in script-

How can I change the filename for an Access Connection?
(http://www.sqldts.com/default.aspx?201)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

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

Basic: Passing Variable Question

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

Basic: Passing Variable Question - 09-20-2004 , 03:26 PM

Re: Basic: Passing Variable Question - 09-21-2004 , 03:46 AM

Re: Basic: Passing Variable Question - 09-21-2004 , 06:58 AM