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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-19 : 08:17:43
|
| Greg writes "I am running MS SQL 2000 and I have a DTS package that performs the following in the order listed below.1) Using Dynamic Process I get the System Date and set the Global Varrible, FileName, to this value.2) I then use the Active-X process to set the Global Varrible, OutPutFileName Name equal to FilePath(global varrible), "PQMMIS" plus the FileName stated above.The Above Items work as the Global Varribles have the Associated values in them.3) I then set the Proporty DestinationObjectName in the Text Conversion(destination) process to the value of OutPutFileName(global varrible) using the Dynamic Process.I have based the workflow for all process upon the successful completion of the previous task.The File name still defaults to the origional filename set in the Text Conversion object when created. I get no errors matter of fact I get successful completion, yet the file name does not chnage.Any Ideas?" |
|
|
|
|
|
Dynamically Changing output file name in Text Destination