• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 309
  • Last Modified:

Setup auto CSV import MSSQL 2005

Is there an easy import method for a CSV into MSSQL db 2005, ideally want this to be setup as a job that runs periodically

Any pointers welcome

thanks

dave
0
david_88
Asked:
david_88
  • 2
  • 2
1 Solution
 
dodge20Commented:
I would create a SSIS package to accomplish this. Then you can schedule the job to execute the .dtsx file. If you are unfamiliar with creating SSIS packages post back and we can try to walk you through it.
0
 
david_88Author Commented:
sounds promising ow does it work
thanks
0
 
dodge20Commented:
I would suggest you start with this tutorial and modifying it to fit your data.
http://technet.microsoft.com/en-us/library/ms365302.aspx

Here is another tutorial
http://www.accelebrate.com/sql_training/ssis_tutorial.htm
0
 
david_88Author Commented:
thanks will have a good read
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now