"...The column status returned was: "The value violated the integrity constraints for the column....",
To avoid the above error create a conditional split tasks with the following command:
"ISNULL(Hardware) || LEN(Hardware) == 0"
Tuesday, January 18, 2011
Exclude empty rows in excel sheet while extracting data via SSIS
While extracting data from excel using SSIS tasks, we may come across the below error message due to the presence of empty rows:
"...The column status returned was: "The value violated the integrity constraints for the column....",
To avoid the above error create a conditional split tasks with the following command:
"ISNULL(Hardware) || LEN(Hardware) == 0"
"...The column status returned was: "The value violated the integrity constraints for the column....",
To avoid the above error create a conditional split tasks with the following command:
"ISNULL(Hardware) || LEN(Hardware) == 0"
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment