Hi all,
I have created a DTS package in SQL Server that takes Excel file and updates the database. The problem that i run into is - sometimes XLS file does not have any records in the table, and in this case i do not want DTS to execute and update the database.
The question is how to check ( i think usign Active X) if the exel table has any values in there or if it is blank?
a lot of thanks in advance,
Dmitry
yeah, and by the way,
when i execute the DTS i can see how many records are taken from XLS and copied into the database, if i can just somehow check that number, retreive that varible... that would solve the problem.
thanks again,
Dmitry
|||It is often a good idea to import data into 'holding tables' (duplicate schema to the production tables), do whatever data cleanup/manipulation is required, and then move the data to the final tables.
With that process, it is easy to determine rowcount, duplications, etc, before running other code.
|||ok...sounds ok, i have never done them before though... can you link an example or something..
many thanks
No comments:
Post a Comment