Ok Gurus,
Here is an interesting situation, I have a coworker that has a flat file
with no column headers that needs to be imported or appended into a
table in SQL Server 2005. Since the file has no column names each time
during the import it inserts col1, col2,col3 as the column names,
erasing the already existing colum names. I am trying to keep this
simple and not use ssis as this will confuse the endworker with having
to load more venues of software... In other words is there a way to
import a flat file with only text and do a sort of select into
situation?? ie using a truncated table as the import destination without
recreating the table each time in order to maintain the existing column
names??

thanx much
Wisord

*** Sent via Developersdex http://www.developersdex.com ***

OK, help us out here.
You say it has no column names. Are the columns in the same order each time?

What's the reason for NOT using SSIS? Sounds perfect for this job!
--
Todd C
MCTS SQL Server 2005


"Bill Orova" wrote: