DTS Query using Global Variable

I am trying to pass one global variable into a DTS package then set other dynamic properties with the Query option. For example if I pass in global variable gstrSourceTextFile = "MyFile" to the DTS package, can I use that global variable in queries say to set the UDL Path of the Destination DB. I […]

Microsoft SQL Server 2000 Resource Kit (With CD-ROM)

Comments posted to this topic are about the content posted at Server 2000 Resource Kit (With CD-ROM).

Data Warehousing

Analysis Services Enhancements

In SQL Server 2000, Microsoft has closed the gap between its multidimensional database offering, OLAP Services, and the rest of the market place.