Home Forums Data Warehousing Integration Services SSIS BIDS Add Database Objects to Project RE: SSIS BIDS Add Database Objects to Project

  • August 25, 2014 at 11:59 pm

    #1740920

    AarionSSQL (8/25/2014)

    Hi All,

    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.

    Thank you

    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 😉

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.