I have a DTS package that defines a Dynamic Properties Task, which in turn
has 2 destination properties each of which define a data source generated by
a SQL Query in an attempt to generate dynamic file names for 2 flat files
based on the date/time.

When I have the package open and execute the Dynamic Properties Task
individually, followed by executing the entire package the output files are
named as desired. When the package is executed by itself, and not preceeded
by executing the dynamic Properties Task, one of the data files in not named
correctly. It appears that both destination properties in the Dynamic
Properties Task are not being executed.

The Dynamic Properties Task "points" to a MS OLE DB provider based on a
workflow success. the OLD DB provider in turn "feeds" two transform data
tasks each of which results in a text file(destination) named by the Dynamic
Properties Task. this is where one of the files in not named properly.

How do I get both quries contained in the DP task to execute when the entire
package is executed?

feil wrote:
Is the file connection being used elsewhere? You can have the situation
when task A opens the connection, task B sets the filename, but this is
does not take effect since the connection is open. Try setting close
connection on completion for any tasks before the Dynamic Properties
task, to ensure the connection is closed and ready to read the new
information when re-opened.

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

Entire package "written" with the DTS Designer, no active x, how do you close
the connection after the first query is executed in the DP object?

"Darren Green" wrote:

"...how do you close the connection..."

How do you (via script) close *any* type of connection (flatfile or
access or whatever)?

Currently we've several packages that write to seperate files then we
have to execute command task that "type"s the files redirecting the
output to the final destination.

There's a checkbox on the workflow properties that I think says "Close
when complete" or smt similiar but I'ld like to find the vbscript
syntax for the equivalent.

Use active x to generate Global variable.(this will change your gv value
updated on each run) upon success run DPT. upon sucess run next steps.
This will insure timely and accurate runs.

"feil" wrote: