Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  DTS dynamic file naming without ActiveX

Author  Topic  feil Starting Member 3 Posts Posted - 2005-12-05 : 11:20:33 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". When I have the package open and execute the Dynamic Properties Task individually, followed by executing the entire package all is well. 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. Can anyone provide a solution based to provide proper file naming based on the sketchy problem definition above? NOTE: I do not know ActiveX. Please do not respond with a solution to use ActiveX unless that is the ONLY way.