Change the File Name property of a Text File Connection from Activ

#1

I have a requirement to populate a table from a file whose name changes every
time it is run. I can determine the file name using an ActiveX VBScript and
would like to then point the Text File Connection to it. How would I do
this? Or is this the best way to do this?

I am learning but my DTS skill is limited!

Michaele

#2

Hi Michaele,

"Snake" wrote:

Quote:

I have a requirement to populate a table from a file whose name changes
every
time it is run. I can determine the file name using an ActiveX VBScript
and would like to then point the Text File Connection to it. How
would I do this? Or is this the best way to do this?

this is a common way and there is already a template showing this.
http://www.sqldts.com/default.aspx?200

HTH
Helge

#3

No problems "Snake"

You need to set the DataSource Property of the text file connection
object to the name of the file

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

Allan

"Snake" <Snake (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have a requirement to populate a table from a file whose name changes every
time it is run. I can determine the file name using an ActiveX VBScript and
would like to then point the Text File Connection to it. How would I do
this? Or is this the best way to do this?

I am learning but my DTS skill is limited!

Michaele

#4

Thanks!

"Allan Mitchell" wrote:

Quote:

No problems "Snake"

You need to set the DataSource Property of the text file connection
object to the name of the file

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

Allan

"Snake" <Snake (AT) discussions (DOT) microsoft.com> wrote in message
news:Snake (AT) discussions (DOT) microsoft.com:

I have a requirement to populate a table from a file whose name changes every
time it is run. I can determine the file name using an ActiveX VBScript and
would like to then point the Text File Connection to it. How would I do
this? Or is this the best way to do this?

I am learning but my DTS skill is limited!

Michaele

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Change the File Name property of a Text File Connection from Activ

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Change the File Name property of a Text File Connection from Activ - 05-25-2005 , 01:07 PM

Re: Change the File Name property of a Text File Connection from Activ - 05-25-2005 , 01:36 PM

Re: Change the File Name property of a Text File Connection from Activ - 05-25-2005 , 01:39 PM

Re: Change the File Name property of a Text File Connection from A - 05-25-2005 , 05:37 PM