Re: pass FIELD dynamically to title of text file in DTS

Hello TG,


OK So long as you can get those values from the table and map them to Global Variables then we can still do this.

You need to dynamically change the file name

How can I change the filename for a text file connection?
(http://www.sqldts.com/default.aspx?200)


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi!

I have a DTS package that exports a table to text.

I need to find a way to look into the table and get the carrier ID and
insert it into the title of the text file to be exported to.

the title should look like this:

E55N6050.log

where 55 is the carrier id

N is the region

6 is the last digit year

05 is mm

0 is the sequence.

How would you do this?

Thank you in advanced.

TG



.

Relevant Pages

  • Re: Dynamic text exporting
    ... do it in a macro (with a static file name) and convert it to a module; ... > Is there a way to dynamically change the file names of text exports. ... example the file name is Reel 500 and I want to put that in front of "Time ...
    (microsoft.public.access.externaldata)
  • pass FIELD dynamically to title of text file in DTS
    ... I have a DTS package that exports a table to text. ... where 55 is the carrier id ... is the sequence. ...
    (microsoft.public.sqlserver.dts)
Loading