April 19, 2007 at 6:27 am
We are migrating our DW from SQL2K to 2005. The database and Analysis Services will reside on 2005, but DTS packages will remain on SQL2K. Many packages use the Process OLAP Cube task. In our testing, we are unable to expose the AS 2005 database to the OLAP task in the 2K DTS package so that the package can process the cube.
Can this be done? Any workarounds, if not?
July 28, 2008 at 3:50 pm
Did you ever get an answer to this? We are facing the same issue here.
Chad
July 29, 2008 at 9:19 am
We never found any workarounds. To minimize the amount of work in converting the DTS packages to SSIS, we created SSIS "wrapper" packages that used the "execute DTS 2000 package" task to execute modified versions of the DTS packages that only contained the tasks prior to the OLAP task, followed by the SSIS OLAP task. This worked for us because we had both 2000 and 2005 servers. Once this was completed, we then started on the complete conversions of the DTS packages.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply