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...?

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 (AT) hotmail (DOT) com> wrote

Thanks for the input

What do you mean add them to source control ?

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

You can book the files into SourceSafe or ClearCase or whatever else source control package you use.

--

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 (AT) hotmail (DOT) com> wrote