Add and specify the query as you would with any SQL query.Right-click on any empty space in the first frame > Select "Add Table.".Select the "Shared Data Source" you just created > Next.Right-click on "Reports" in the Solution Explorer > select "Add New Report".Give the DataSource1 a more memorable name.Right-click on "Shared Data Sources" in the Solution Explorer > select "Add New Data Source".Still within Business Intelligence Development Studio (BIDS).Expand the data connection you just made and expand "Tables" just to see if the connection is working properly.Enter credentials if necessary and click on "Test Connection".Select the data source from the dropdown (the one you just created earlier should be listed).Select "Microsoft ODBC Data Source" > OK.Right-click on "Data Connections" > select "Add Connection".Open Business Intelligence Development Studio (BIDS).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |