Yes, but you would either be pulling in all cells and finding the cell you want based on it's row / column, or you would be using a script task...

I did not fully follow your question.

The SSAS migration does create a 2005 version of your 2000 AS database. The 2005 version will typically not process until you resolve...

Excel does not bring back exactly what is being displayed. In many cases, it brings back everything in a single row or in a single column and then does...

After making some test data myself (it would have been nice if you posted test data something like I have provided), this was pretty easy.

This assumes that the Status values...

The job agent does not support running the same job at the same time, so if you need to support multiple users simultaneously running the package you have a major...

You need to be much more specific. What are you trying to use the web service for?

Here are three options:

The easiest solution would be to write your parameter information to a table and use an Execute SQL Task to get the information from the table into...

You are on a SQL Server site in a SQL 2005 Analysis Services forum. This is an inappropriate place for Oracle questions.

MS has also published several sample projects and some controls for cube browsers. MS Access also has a cube browser control. Excel with Sharepoint and Proclarity (which is...

Good point, my solution should probably order by the Code field in the APPLY, rather than by the Alpha numeric. The other points were why I did not parse...

There are probably hundreds of articles about it. Ignore the fact that you are using the Integration Services project type. The source control integration is part of Visual...

You can specify a Job Agent job to run when the Agent starts. If your agent starts when the server starts, you could just have a job that deletes...

You will have to insert parent records before child records. This will typically force you into a multi-step process.

One of the easiest ways to manage this is to import...

First - yikes - this is quite the design. Change it if at all possible.

Barring getting away from this multi-value column, you need to split the data into a...

SSIS is a developer-centric approach rather than the DTS administrator-centric approach. Although this is a shift, it does not have to be a painful one.

You should have your source...