Friday, March 9, 2012

Import data from a file

I wanna know which and how is the better way to take date from a file and instert into a database in sql server 2005

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