Posted by Dan Guzman on 11/24/06 22:18

One 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.net> wrote in message
news:Xns988590E745995Grok@199.45.49.11...
>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

• Next in forum: Re: HDD still full after shrinking transaction log
• Prev in forum: Re: Which Replication Method To Use
• Thread view: Re: DTS - Need to Set Destination Filename dynamically

[Reply to this message]