I am converting a 2000 DTS script to SSIS and am having a problem in figuring
out what approach to use in a specific task that I have. I previously did
this with a transform data task.

I am tring to copy data from an analysis service cube to sqlserver2005 using
SSIS.
As I understand it I shoud use the data flow task for a control task then
select a data source in the data flow task area. The problem seems to be
that none of the data flow sources allow me to select the anaylsis service
connection that I have previously made, it only shows me the SQL server 2005
db connection, both connections where tested succesfully. So how am I
suppose to data transformations if I can select the correct source? I did
see in control flow toolbox that there is a Analyasis Service DDL task, am I
suppose to use this and if so how do I open its output in data flow. If any
one has a simple example it would be apreciated.

2nd part of question:
I did try to use Analysis Service DDL task, but I could not get it to
recognize my query statement. Below is the query statment that I used in my
DTS script.

with member [Measures].[TimeDisplayName] as '
[Discharge].Currentmember.Name+"-"+[Discharge].[Parent.Name'
Select { [Measures].[TimeDisplayName], [Measures].[CaseCount],
[Measures].[Admit Feeding]} on Columns,
CrossJoin({[Facility].[Regcode].Members,[Facility].[Natcode].Members},[CMG].Members) ON rows
FROM [udspro_region]
WHERE [Discharge].[All Discharge].LastChild.LastChild

brian_harris wrote:
I have not tried this all the way through, but looking around it would
seem the first stage is to create a connection, such as the OLE-DB
Connection, using the MS OLE-DB Provider for OLAP Services.

You could then consume this with the OLE-DB Source.

Similarly you could use an ADO.Net connection and the DataReader Source.


The DLL task would only support DLL judging by the name, but what you
have is DML. It is not for getting data out, so stick with the Data Flow.


--
Darren
http://www.sqldts.com
http://www.sqlis.com