On Feb 20, 7:19 pm, "brett" <acco...@cygen.com> wrote:
> I've created a new project in SSIS. I've saved the project to
>
> c:\DBProjects\DB1
>
> All of the sql files are located in
>
> c:\DBProjects\DB1\sprocs
>
> When I right click the project name and select to add existing item, I
> point to the sprocs folder and add one sql file. When I look at the
> folder structure, I see the sql file has been copy into
>
> c:\DBProjects\DB1
>
> I'd like to keep all sql files in the sprocs folder. Why does SSIS
> copy them to another folder and is there a way to keep them in the
> original location?
>
> Thanks,
> Brett

On Feb 21, 8:12 pm, "KenJ" <kenjohn...@hotmail.com> wrote:
> Hi Brett,
>
> SSMS keeps all the files in the same directory. I haven't found a way
> to change that behavior. However, when I do want a group of files
> kept in their own directory, I just add another project to the SSMS
> solution (e.g., a project names sprocs). All of the files I want to
> keep separate are now stored in the folder for the new project and
> they are all available through the same solution in SSMS.

On Feb 22, 12:08 pm, "brett" <acco...@cygen.com> wrote:
> On Feb 21, 8:12 pm, "KenJ" <kenjohn...@hotmail.com> wrote:
>
> > Hi Brett,
>
> > SSMS keeps all the files in the same directory. I haven't found a way
> > to change that behavior. However, when I do want a group of files
> > kept in their own directory, I just add another project to the SSMS
> > solution (e.g., a project names sprocs). All of the files I want to
> > keep separate are now stored in the folder for the new project and
> > they are all available through the same solution in SSMS.
>
> I'm not following you. Let's say I have this stucture:
>
> c:\Database\DB1\Stored Procedures
> c:\Database\DB1\Tables
> c:\Database\DB1\Functions
>
> I want a project for DB1 that will have seperate folders corresponding
> to the above folders. But as you mentioned, that can't be done. You
> have to create a project for each folder than store it under the same
> solution. I still can't get that to work. Here's what I do:
>
> Add new project to solution. Point it to the "Stored Procedures"
> folder and give it a name of "DB1_sprocs". I end up with this
>
> c:\Database\DB1\Stored Procedures\DB1_sprocs
>
> and SSIS starts moving all of the sprocs into that subfolder, which I
> don't want. Can you explain how to make this work?
>
> Thanks.

On Feb 22, 9:10 pm, "KenJ" <kenjohn...@hotmail.com> wrote:
> Hi Brett,
>
> Instead of pointing the new project to "Stored Procedures" and naming
> it "DB1_sprocs" try pointing the new project to "DB1" and name the new
> project "Stored Procedures" it will then put all the files for the
> stored procedure project in the stored procedures folder.
>
> Do the same for the tables and functions projects and they will map
> the same way.
>