File import with no column names


I would like to import a file into a Database table. The file has no column headers and 160 columns. The columns will remain in the same position in the file. Currently, I am doing this by manually mapping the columns using the Import process in SQL. As this is going to be a regular requirement, is there a way to automate this process?

Any guidance would be appreciated.

Who is Participating?
Vitor MontalvãoMSSQL Senior EngineerCommented:
Which edition of SQL Server are you using? If isn't an Express Edition in the last step of the Import Wizard instead of press run you can press save the package so you can create a SQL Server job to run the package in a scheduled way.
Walter RitzelSenior Software EngineerCommented:
I believe the best way is to use SSIS for that. Everything is configured once, and you can run whenever you want.

Reading suggestion:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.