Thx guys,first problem solved but Things got a little more complicated. I want to include a case when clause with the sum function in the Set statement as follows (disregard...

the import is done by starting a job which uses a package containing the code to import the data.