I have around 10 txt files....I want to bcp them into a single table
dtproperties.....is there a way to do that?...I want to do something
like this...

bcp db.owner.table in *.txt

Simply build a Loop on the directory and do it that way. We have an example
here

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

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"sudha" <saisudhas (AT) hotmail (DOT) com> wrote

I was just trying to get your example (Looping...) to work and it gives me Source File Directory and Archive File Directory not found, errors. I have specified the correct file as source and the correct destination. What's the problem? Can I post something to make this more clear as to what may be wrong

Thanks

The source and destination directories are just that, directories, not
files. Do you have permissions to those directories?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Paul" <anonymous (AT) discussions (DOT) microsoft.com> wrote

specified the correct file as source and the correct destination. What's
the problem? Can I post something to make this more clear as to what may be
wrong?