I have files that are dropped off at a certain folder all day long. They
all have a .txt extension.

All files have the same format. Does anyone have solution that processes
all files in folder using BCP to a SQL table.



Thanks.

You could use this

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Andy" <Hoosbruin (AT) Kconline (DOT) com> wrote

I looked at that solution but doesn't it need to know the name of a
specific file to start looping ?

The text file(source) seems to be where you need an actual filename. I
maybe missing something but I need to point at a directory and pickup
all files that end in .dat.

I haven't used GV's to date and that could be where I'm having trouble.




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

To set up the package you need a file of same structure as those you intend
to import. After that i.e. at runtime then the loop provides the filenames.



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Andy" <Hoosbruin (AT) Kconline (DOT) com> wrote