Setup auto CSV import MSSQL 2005

Posted on 2009-02-10
Last Modified: 2012-06-27
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


Question by:david_88
    LVL 11

    Expert Comment

    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.

    Author Comment

    sounds promising ow does it work
    LVL 11

    Accepted Solution

    I would suggest you start with this tutorial and modifying it to fit your data.

    Here is another tutorial

    Author Closing Comment

    thanks will have a good read

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    755 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

    20 Experts available now in Live!

    Get 1:1 Help Now