loveindia Posted December 2, 2013 Report Posted December 2, 2013 SSIS lo aithe Object variable create chesi andhulo flat or excel file nunchi load chey first.Then a temp object variable meedha delete statement ray.Then finally load into the destination table. Nani man.. good stuff man..
SwamyRaRa Posted December 2, 2013 Report Posted December 2, 2013 Simple man.. neeku sql lo kaavalaaa or ssis lo kaavala?? Evening naa website lo post vesta same daani meeda.. enjoy.. www.sqlsaga(dot) com Meanwhile look into it for any other questions you have man.. dont forget to like on facebook.. :-P done
loveindia Posted December 3, 2013 Report Posted December 3, 2013 Answer Posted at sqlsaga (dot) com... check chesko man..
pachimirchi Posted December 3, 2013 Report Posted December 3, 2013 mundu o new excel sheet create chesko -- Create table [NewSheet1](Id int,Name varchar(10)) andulo data insert chey-- Insert into [NewSheet1$] select * from [Sheet1$] where id is not null id column is our primary key here.. ssis lo sql task use chey..
Recommended Posts