"Michael Vardinghus" <michaelvardinghus@hotmail.com> wrote in message news:%23QsP4nFQFHA.1500@TK2MSFTNGP09.phx.gbl...
> Hi All
>
> I'm aware that you can do something with the naming conventions so it's
> easier to spot which packages concerns the same topic but do you save them
> on the sql server or as structured storage files ? With structured storage
> files I can get a folder structure to give me another step to make it
> hierachical but then you need to know where to find them..
>
> Which way to go...?
>
>

"Michael Vardinghus" <michaelvardinghus@hotmail.com> wrote in message news:OCoQCbGQFHA.576@TK2MSFTNGP15.phx.gbl...
> Thanks for the input
>
> What do you mean add them to source control ?
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:uY7hyuFQFHA.1396@TK2MSFTNGP10.phx.gbl...
>> I personally store them as .dts. I can then add them to source control, I
> can move them around easily and if for no other reason we
>> are not allowed to store packages on the server.
>>
>> --
>>
>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>> www.SQLDTS.com - The site for all your DTS needs.
>> www.SQLIS.com - SQL Server 2005 Integration Services.
>> www.Konesans.com
>>
>>
>> "Michael Vardinghus" <michaelvardinghus@hotmail.com> wrote in message
> news:%23QsP4nFQFHA.1500@TK2MSFTNGP09.phx.gbl...
>> > Hi All
>> >
>> > I'm aware that you can do something with the naming conventions so it's
>> > easier to spot which packages concerns the same topic but do you save
> them
>> > on the sql server or as structured storage files ? With structured
> storage
>> > files I can get a folder structure to give me another step to make it
>> > hierachical but then you need to know where to find them..
>> >
>> > Which way to go...?
>> >
>> >
>>
>>
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:uY7hyuFQFHA.1396@TK2MSFTNGP10.phx.gbl...
> I personally store them as .dts. I can then add them to source control, I
can move them around easily and if for no other reason we
> are not allowed to store packages on the server.
>
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - SQL Server 2005 Integration Services.
> www.Konesans.com
>
>
> "Michael Vardinghus" <michaelvardinghus@hotmail.com> wrote in message
news:%23QsP4nFQFHA.1500@TK2MSFTNGP09.phx.gbl...
> > Hi All
> >
> > I'm aware that you can do something with the naming conventions so it's
> > easier to spot which packages concerns the same topic but do you save
them
> > on the sql server or as structured storage files ? With structured
storage
> > files I can get a folder structure to give me another step to make it
> > hierachical but then you need to know where to find them..
> >
> > Which way to go...?
> >
> >
>
>