Validation for Not Null Column using SSIS 2008.

n_srikanth4
n_srikanth4 used Ask the Experts™
on
Hi Experts,

           I want to do a validation for the Primary Key column and fail the ETL package if a Null value is detected  in the CSV File for the Primary Key (Not NUll column).

I am loading data from  flat file to table (sql server) using
 SSIS 2008 package. Please help me with the solution.


Regards,

Sreekanth.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Get the data loaded into a temporary table and then run your validation before inserting into main table.

Author

Commented:
good.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial