Import Data

Hey guys,
  I have a .txt file that I need to do a bulk import on weekly.
It has 30 fields and the file is fixed length.
field 1 is fixed length = 4
field 2 is fixed length = 2
filed 3-30 are each fixed length = 42

How can I set this up for a bulk import?
Who is Participating?
pssandhuConnect With a Mentor Commented:
Hi, Check this post out:
Yuo can create a scheduled job under SQL Server Agent to schedule this on a weekly basis.
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.