Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2008-02-26 : 05:21:10
|
| Hi pals,I have a problem in Datflow task.Basically i am having two tables. One in sql server 2005 and another in ORacleSQL Tablecreate table t1( c1 numeric(6), c2 numeric(6), c3 varchar(50), year numeric(4), district varchar(10) )Oracle Tablecreate table app_t1( c1 number(6), c2 number(6), c3 varchar2(50), year number(4), district varchar2(10), constraint cpk primary key (c1,year,district))I am using 2 global variable for passing values to c4 and c5 columns in oracle table.The variable names are g_year and g_district.i am using a dataflow task to move data from sql server 2005 to oracle 9i databaseI am able to load the data from sql server to oracle.Till here it is fine. But the requirement is if i get same data i.e same dist and same year then we need to delete the datain oracle table as "delete from app_t1 where year = ? and district = ?"Immediately i need to issue a commit statement.and thereafter i need to load data for that particular district and year.To accomplish this requirement i am using , An Execute SQL Task to Delete the data from ORacle An Execute SQL Task to COMMIT the transaction Finally i am loading data from sqlserver to oracle using a dataflow task.But i am getting an error as "Value violated the integrity constraints for a column or table.".I think the deletion operation is not getting committed.So what i did was i connected to oracle and deleted the data using above DELETE statementand again come back to SSIS package and ran the package once again, this time it is successfull.Why is it so. Any thoughts on this?Any help would be greatly appreciated.Thanks! |
|
|
|
|
|
|
|
DataFlow task error moving data from Sql to Oracle