Hi I have problem with an insert statement in the DTS. I’m splitting a value when d = 10 then insert the values in b and c under the value d 4, then delete the value d 10. My problem is that in the transform data task property window under the tab “transformation” I can’t pick the source data it doesn’t show, it’s totally blank. When I delete the insert part (only using the select statement of the code) then I’m able to pick the Source data and connect it with the Destination code. Have anyone experince this before. I’m totally out of ideas by this point, so if anyone can help me out would be greately appreciated. Thanks/rSo here is the code.insert into table1 ( a,b,c,d)Select a, b ” * 0.6”,c “ * 0.6”,,d ”4”From table1Where d =’10’Delete from table1Where d =’10’
Problem with an Insert statement
Posted - 2006-06-23 : 15:39:21