DTS - Need to Set Destination Filename dynamically

I have a stored procedure that (after selecting, incrementing and updating)
returns the next sequential filename.

I haven't been able to plug it in to the destination textfile filename in my
DTS package.

I know it has something to do with Dynamic Properties and I can navigate to
the property I want to set, but just can't seem to get the result of my
stored procedure into the filename.

I know somebody must have done this before.

Thanks
JoeOne method is to assign the file name value to a global variable in an
Execute SQL task that executes your proc. You can then use a Dynamic
Properties task to assign that global variable value to the desired
property.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Joe Hurzeler" <joe.hurzeler@.verizon.netwrote in message
news:Xns988590E745995Grok@.199.45.49.11...

Quote:

Originally Posted by

>I have a stored procedure that (after selecting, incrementing and updating)
returns the next sequential filename.
>
I haven't been able to plug it in to the destination textfile filename in
my
DTS package.
>
I know it has something to do with Dynamic Properties and I can navigate
to
the property I want to set, but just can't seem to get the result of my
stored procedure into the filename.
>
I know somebody must have done this before.
>
Thanks
Joe