"csl" <cslatta@carolina.rr.com> wrote in message
news:1704901c420db$a424ac50$a001280a@phx.gbl...
> I have seen the import examples from sqldts
> (http://www.sqldts.com/default.aspx?246) but was wondering
> if there is anyway to automate the importing of multiple
> text files with each text file going into a separate SQL
> table. The format of the text files are all the same.

>I have seen the import examples from sqldts
>(http://www.sqldts.com/default.aspx?246) but was wondering
>if there is anyway to automate the importing of multiple
>text files with each text file going into a separate SQL
>table. The format of the text files are all the same.

"Darren Green" <darren.green@reply-to-newsgroup-sqldts.com> wrote in message
news:Nq4Il4BG2EfAFwAV@sqldts.com...
> In message <1704901c420db$a424ac50$a001280a@phx.gbl>, csl
> <cslatta@carolina.rr.com> writes
> >I have seen the import examples from sqldts
> >(http://www.sqldts.com/default.aspx?246) but was wondering
> >if there is anyway to automate the importing of multiple
> >text files with each text file going into a separate SQL
> >table. The format of the text files are all the same.
>
> If the text files are all the same format then I don't see why the
> article you mentioned could not be used for this. You currently change
> the source filename, so at the same time you could change the
> destination object name.
>
> I think Allan must have missed the comment about being the same format.
>
> --
> Darren Green (SQL Server MVP)
> DTS - http://www.sqldts.com
>
> PASS - the definitive, global community for SQL Server professionals
> http://www.sqlpass.org
>