You can download the AdventureWorksDW sample database from the CodePlex site. For demonstration purposes we will use the AdventureWorksDW database. Upon launching SSMS you will be prompted for a connection connect to the Database Engine. To begin launch SSMS by clicking SQL Server Management Studio from the Microsoft SQL Server program group. In this section we will go through the Export Wizard and export data from a SQL Server database to an Excel spreadsheet. You can choose from a variety of source and destination data source types, select tables to copy or specify your own query to extract data, and save your work as an SSIS package. SQL Server Management Studio (SSMS) provides the Export Wizard task which you can use to copy data from one data source to another.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |