I am able to import one pipe delimited file at a time with the script below but can't get it to import multiple files at once. I tried to use a wildcard in the file name but it won't allow it (ie. *.txt or eJ*.text).
Any assistance that you can provide would be greatly appreciated.
BULK INSERT databasename.tablename
FIRSTROW = 2,