pass FIELD dynamically to title of text file in DTS

From: "TG" <jtammyg@xxxxxxxxx>
Date: 17 May 2006 09:18:37 -0700

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

.

Follow-Ups:
- Re: pass FIELD dynamically to title of text file in DTS
  - From: Allan Mitchell

Prev by Date: Re: Sybase Source. What "data flow source" to use?
Next by Date: Re: Deleting SSIS packages..
Previous by thread: Re: Sybase Source. What "data flow source" to use?
Next by thread: Re: pass FIELD dynamically to title of text file in DTS
Index(es):
- Date
- Thread

Relevant Pages

Re: pass FIELD dynamically to title of text file in DTS
... 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 ... I have a DTS package that exports a table to text. ... where 55 is the carrier id ...
(microsoft.public.sqlserver.dts)
dts export / Incomplete file format information
... I'm attempting to create a DTS package that exports data from a stored proc ...
(microsoft.public.sqlserver.dts)