I have a lot of data in code called AMOSQL and i want to put all that data in a tsql schema.
the code is like this
set :i2 = new_object(1744,'EVENT');
set :i1 = new_object(1747,'MUON');
add MUON.EVENT->EVENT(:i1)=<:i2>;
set :i2 = new_object(1492,'EVENT');
set :i1 = new_object(1494,'MUON');
add MUON.EVENT->EVENT(:i1)=<:i2>;
set :i1 = new_object(2010,'EVENT');
add EVENT.FILENAME->CHARSTRING(:i1)=<"bkg*.root">;
set :i1 = new_object(1564,'EVENT');
add EVENT.FILENAME->CHARSTRING(:i1)=<"bkg*.root">;
I don't think there is any way importing the data without parsing....
But you can try exporting the data to text/csv/xls files from AMOSQL and then use SSIS/DTS to import the data from text/csv/xls files ....
No comments:
Post a Comment