import multiple accessfiles in dts

[Ezekiël]

Hi,

How can i import multiple accessfiles in sql server 2000 by using a dts
package?

The dts package should import files with the most current date in a
directory (not today's date). The date can be found in the name, e.g.:
<companyname>_2 0041214.mdb.

Also i would like to use the companyname from the filename to fill in a
empty column called companyname, so i can import all files into one
normalized table.

The files are placed in on a root drive.

If someone can help me on this i would be very happy.

Thnx.

[John Bell]

Re: import multiple accessfiles in dts

Hi

The following should get you started:

http://www.sqldts.com/default.aspx?292

http://www.sqldts.com/default.aspx?248

http://www.sqldts.com/default.aspx?201

You can store the company name in a global variable, then use an activeX
transform to populate a column from that global variable.

http://www.sqldts.com/default.aspx?279,4

John

"Ezekiël" <ezekiël@lycos. com> wrote in message
news:41c281c0$0 $45956$a344fe98 @news.wanadoo.n l...[color=blue]
> Hi,
>
> How can i import multiple accessfiles in sql server 2000 by using a dts
> package?
>
> The dts package should import files with the most current date in a
> directory (not today's date). The date can be found in the name, e.g.:
> <companyname>_2 0041214.mdb.
>
> Also i would like to use the companyname from the filename to fill in a
> empty column called companyname, so i can import all files into one
> normalized table.
>
> The files are placed in on a root drive.
>
> If someone can help me on this i would be very happy.
>
> Thnx.
>
>[/color]