August 28, 2009 at 2:03 pm
Hi,
I am experiencing an issue with a sql server job which runs a series of SP to import data into a table on a daily basis. The job status is still successful although the tables aren't being updated.
The files .xls are placed in a directory each day by the end user and a Sp grabs the files and places them in a central location. Last week the excel file included additional columns that weren't included in the tables. Once I realized this, I removed the files that didn't import from the staging table and deleted all data from that particular day from the table. Now the staging table is showing all files as being imported and everything is correct but the data is not loading into the final table. Any suggestions??
August 29, 2009 at 10:49 am
Do you have any errors on any of the steps of the job? Expand the job history and post any errors/warnings you may see.
August 29, 2009 at 1:42 pm
Hello,
If you are not getting any errors then …. on a data load process that I recently worked on, the Import SPs logged their completion to a Central Table. If the corresponding record was present then a particular SP would be skipped, so to repeat (or restart) a load for a particular day, these records had to be removed.
Does your data load process contain similar logic?
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
August 31, 2009 at 8:14 am
No errors...the job is listed as running successfully. The data is first loaded into table 1. Table 1 list all of the attributes of the file such as the .xls file name, date import, and #of rows of data imported. The .xls file is then loaded into either Table 2 or Table 3 based on the contents. Table 2 reports are all loading succesfully but Table 3 data is not being loaded. There was 1 .xls file that didn't load to table 1 and showed no rows of data as being imported. The .xls file format was different therefore I removed this file and reran the process which then reloaded the data to table 1 correctly . Every since I did this Table 3 data hasn't loaded at all.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply