SQL 2005 Can't Import Data Using SSIS as a JOB
Posted on 2008-10-02
I am very new at this so if you answer the question for me you need to be very specific. I am trying to simply import a .csv file into an existing SQL 2005 table. The log behind it is that every day at a specific time the .csv file will be downloaded to the server, and the table in SQL 2005 will be purged of all data. Then I need to run a job at a specific time each day to import the .csv file into the table. When I use SQL Server Management Studio, I was able to successfully import the data manually. The the time of the import, it asked me if I want so save the SSIS job and I said yes. I then wen to jobs to create a job using the saved SSIS job. I tried saving both as a file and in SQL, and neither way works. It simply gives an error message when I try to run the job. What am I doing wrong? Again, I am very new at this, just about 1 day with SQL 2005 so I really need a specific step by step answer. Also, just to add, I tried logging into SQL Management Studio with both the windows account or the sa sql account and created the job using each one and neither worked.