Our firm needs to analyze some financial data for a client. They gave us a SQL database file in ANSI format. Is there a way to import this data into SQL 2005?
Thanks,
Steve
If the data is in a 'standard' format, and If you have a good data map, then you 'should' be able to use SSIS, or the IMPORT Wizard, to import the data into a functioning SQL Server.|||Arnie,
Thanks for the reply. Do I need to contact the client to get column types and widths, etc?
Steve
|||I would definitely want some way to undertand what data is in the data file, and how it is organized. So that sounds like a good plan. -Unless you can open the datafile and inspect the format.
No comments:
Post a Comment