Converts SQL Server Integration Services raw file to hash objects. Supports raw files generated from SQL Server 9, 10, 11, 12.
Install:
gem install sql-server-raw-file
Usage:
# begin example 1
require 'sql_server_raw_file'
File.open('/path/to/sql/raw/file') { |raw_io|
raw_obj = SqlServerDts::RawFile.new(raw_io)
# ...
puts raw_obj.version
puts raw_obj.header
# ...
until raw_io.eof?
# ...
puts raw_obj.read_line
# ...
end
# ...
}
# end example 1
# begin example 2
require 'sql_server_raw_file'
SqlServerDts::RawFile.new('/path/to/sql/raw/file') { |raw_obj, raw_io|
# ...
puts raw_obj.version
puts raw_obj.header
# ...
until raw_io.eof?
# ...
puts raw_obj.read_line
# ...
end
# ...
}
# end example 2
More detailed examples in ./fixtures/fixture_sql_data_and_header.rb
Visit to sql-server-raw-file homepage