Solved

Import Data

Posted on 2009-06-30
1
230 Views
Last Modified: 2012-05-07
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?
0
Comment
Question by:lrbrister
1 Comment
 
LVL 17

Accepted Solution

by:
pssandhu earned 500 total points
ID: 24746709
Hi, Check this post out:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_24512088.html
Yuo can create a scheduled job under SQL Server Agent to schedule this on a weekly basis.
P.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now