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

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 Allan!

I saw that, but somehow it goes not show me how to retrieve the field
from the table.

I am not a programmer so I have no idea how to do that.

Maybe you can put a example.

Thank you!

Tammy

Hello TG,

So you are going to have to read the values from the table into a variable
or two so have a look through this article.

http://www.sqldts.com/default.aspx?277,8

The type of statement you want is a SELECT statement

You will also be configuring the Output Parameters on this page.


Let us know how you get on?

Is there no-one where you work that can help?

I cannot tell you what the SELECT statement will be because I cannot see
your table design with sample data


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