"Kevinoh" wrote:

> Thanks for your posts and suggestions. I was able to adapt the previosly
> mentioned script, so that I create tables with the same names as the files as
> I iterate through the directory. This has worked perfectly in one
> subdirectory, and partly in another.
>
> However, it is now failing due to the "Column deliminator not found" error
> (Error Source: DTS Flat File Rowset Provider) on some files. Curiously, I
> have been able to import these very same files using the DTS wizard, without
> any problems.
>
> I've checked these settings in the Data Pump task, and they haven't changed;
> nor is there any difference in the files that I can see. Any advice as to how
> to troubleshoot?
> --
> Kevinoh
>
>
> "Allan Mitchell" wrote:
>
> > John
> >
> > The original poster also wanted to create the tables as they went based on
> > the defintiion of the text file encountered. To have this automated means a
> > rebuild of the Data Pump task on each iteration as mentioned in my reply.
> > The looping around the files is relatively easy with this article.
> >
> > Looping, Importing and Archiving
> > (http://www.sqldts.com/default.aspx?246)
> >
> >
> >
> > "John" <john36356@community.nospam> wrote in message
> > news:OxwGo$cpFHA.1044@tk2msftngp13.phx.gbl...
> > > The easiest solution would be to use a couple of ActiveX script tasks and
> > > FileSystemObject around your transform. You can iterate through the
> > > directory, on each iteration taking the filename and assigning it to a
> > > global variable and adjusting your textfile's .DataSource property to the
> > > name of the textfile and so on. Similarly for the table name. Once you
> > > have used a transform data task to import the file, use another activeX
> > > task
> > > to delete the filename contained in the global variable. Repeat the loop
> > > until there are no more files in the directory; at that point disable
> > > remaining steps and exit package with success.
> > >
> > > Hope this helps,
> > > John Glass
> > >
> > >
> > > "Kevinoh" <Kevinoh@discussions.microsoft.com> wrote in message
> > > news:811A77D4-CECF-4211-8B1F-4319A8E145E3@microsoft.com...
> > >> Hello,
> > >> I'm got a subdirectory containing a large number of flat files. I want to
> > >> use DTS to recursively import them into a database, using a DTS package
> > > that
> > >> iterates through the subdirectory, creating tables with the same names as
> > > the
> > >> files being imported. I'm using SQL 2000 on W2K machines. Can someone
> > > point
> > >> me to a good example of this? Thanks.
> > >> --
> > >> Kevinoh
> > >
> > >
> >
> >