Posted by Joe Hurzeler on 11/24/06 22:14

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: Which Replication Method To Use
• Prev in forum: Re: Which Replication Method To Use
• Thread view: DTS - Need to Set Destination Filename dynamically

[Reply to this message]