DTSs, OLAPs, and VSS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GreenfieldM - 21 Apr 2004 16:07 GMT

Does anyone know if DTSs from SQLServer can be exported
and saved in VSS for versioning? Same question about OLAP
Cubes contained in Analysis Services.

Thx!

Reply to this Message

Joe Masters - 28 Apr 2004 06:12 GMT

I think only stored procedures can be versioned with the integrated SQL
Server support. If you export to text files, you can certainly add them with
the VSS Explorer.

Joe

> Does anyone know if DTSs from SQLServer can be exported
> and saved in VSS for versioning? Same question about OLAP
> Cubes contained in Analysis Services.
>
> Thx!

Reply to this Message

GreenfieldM - 06 May 2004 17:38 GMT

Thanks, Joe. I discussed the DTS issue with our DBA, and
there is a way to export the package, and store it off to
VSS.

Also, I was reading a book called "SQLServer 2000 Resource
Kit", and there is a MetaDataScripter utility which allows
you to export an OLAP definition as a text file, which can
be put into VSS. The cool thing is that you can recreate
the OLAP cube from the definition, and then reprocess the
cube, and *voila* you're back in business.

MG

>-----Original Message-----
>I think only stored procedures can be versioned with the integrated SQL
[quoted text clipped - 10 lines]
>
>.

Reply to this Message

DTSs, OLAPs, and VSS

Free Magazines