0

I have a flat file that will be downloaded to a server every night at 1 AM. I right clicked the data base, then tasks, then import data, then saved the import SSIS package.

When I try to run the package it works the first time then says the table already exists, error executing query, failed with the following error: there is already an object named csvtest in the database.

I guess I need to drop an recreate the table everytime the import runs but I don't know how to do that within the "Execute Package Utility"

I'm getting a bit over my head and lost, any ideas how I can accomplish importing a csv with SQL Server Management Studio automatically with a task?

Improve this question
5
  • If you don't need to do any transformation, then BULK INSERT is a simpler and better option than SSIS. Commented Feb 25, 2014 at 19:54
  • how can I run bulk insert automatically? I can write it in SQL but then what? Commented Feb 25, 2014 at 19:59
  • 1
    you can schedule it in SQL Server Agent Commented Feb 25, 2014 at 20:06
  • thanks... have any good examples or links? Commented Feb 27, 2014 at 15:16
  • a good discussion here: stackoverflow.com/questions/5281617/… Commented Feb 27, 2014 at 15:58
Related questions
3
CSV import in SQL Server 2008
1
Import CSV within SQL Server 2008 Management console
1
SSIS - CSV to SQL Server Data Import Error
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.