Hi,

I've dts package where i import a textfile with over a 1000 colums. Only the
first six columns i use to import to a normalized table (never mind the
other columns, i'll worry about them later).

My question is, how can i import multiple texfiles based on my dts package.
I don't want to manually import several hundreds of textfiles.

Can anyone help me on this?

Same format?

I would look at this article.

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

"Jason" wrote:

Hi,

Thnx for the link, it was very useful. However i can''t manage to apply it
to my situation. Do you know a another exaple to import multiple file which
has different names. All files goes to the same destination table.

Greetings,

J
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote