Could you tell me how to add database objects to BIDS Projects.
I am working on SSIS and have seen a project where the database object definitions such as the table names and the stored procedures are all listed in the project.
I have attached a small screen shot of the project explorer to show what I am trying to describe.
Hope you can help.
I'm pretty sure that you cannot have a single project which is a mix of SSIS packages and database objects.
However, I see no reason why a single solution should not contain an SSIS project and a database project. Though I wouldn't necessarily recommend doing that.This link
shows you how to import the schema from an existing physical database into a VS database project. You may learn some 'bad' things about your database along the way ;-)
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.