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
Managing objects is done in SSDT (SQL Server Data Tools). SSIS is done in SSDT-BI. Confusing right?
SSDT is a seperate but free download. Once you have installed this, you can manage your database projects in Visual Studio. However, you cannot add them to the same project - as Phil mentioned - but you can add different projects to the same solution. Doesn't necessarily make it a good idea though.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP