Re: Dynamic Property @ Text File Source

#1

Hello Eric,

You must add the Text File source first in order to be able to set its property
through the DP task. The value is set at Runtime and the design time value
will not change.

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

I need some assistance setting up a global variable that will be used
to specify the path of a text file as my data source. I have
accomplished this in the past, but cannot duplicate. In what order do
I add the Dynamic Property and the Text File (Source) - or does it
even matter?

Every time I set the data source value for the txt file within the
Dynamic Properties task to use my global variable, it still retains
the 'hard coded' Default Value which was required to add the Text File
(Source) to my package in the first place. At the same time, after
setting the Data Source to use my global variable, if I open the Text
File (Source), the FileName is still hardcoded whereas it should be
blank. TIA --

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

Re: Dynamic Property @ Text File Source

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

Re: Dynamic Property @ Text File Source - 04-17-2006 , 08:19 PM