Not really sure what you are trying to do.

If Products 1,2,3,4 are cheeses and Products 11,12,13 are butters then you could add a column to the relational data base...

If the user is doing this as a one off then it can be done (although there may be a lot of scrating of head).

If there is some sort...

Have a look at dense_rank. I think that is what you are looking for.

Gives you a way of assigning a value of importance to data. Have used it beofre...

Create a package. Create a connection to the Excel file. Create an OLE DB connection for where the data is going to go. The Excel connection will contain the directory...

Obviously if you are having network issues this will affect the performance. Sometimes the first person to run a query against a cube will be caching the query for the...

to extract this to a 'Noddy' style answer.

Data Mart is a database

Cube is a method of storing OLAP data. You could call it a OLAP table.

OLAP means anlytical rather...

Find a web site with examples . Google SSIS Junkie and check out Jamie Thomsons blog site. There is intelliesens in the editor and it does not take long to...

Metadata being out of date

I believe this happens your package looks at a table and retrieves a column that is a varchar(2), then close the package change the table definition...

Couple of thoughts. I am assuming that SQL server and SSAS are on the same remote server. If you can get onto the server then open SSMS on the...

I agree with Dave J. He has the right approcah. The transformation task are not required. Step back from SSIS and think of what you want to do in sql.The...

I have considered such a problem. I have thought of using sql command from variable for the data source and open rowset from variable for the destination.

If I was...

Couple of options. Why not use System variable PackageName. I use a package level variable LogFolder that contains a string value such as "c:\logging\". Then the connection can be set...

Many thanks for that I will certainly look into it. My frustration was that we were only shifting 3.3 million rows and it just ground to a halt.

I believe that...

Thanks,

but got multiple rows for tables so changed it slightly:

SELECT table_name,table_rows FROM (

select so.name as table_name, si.rowcnt as table_rows,ROW_NUMBER() OVER (PARTITION BY SO.NAME ORDER BY si.rowcnt DESC) AS RC

from sysobjects...

Jerry I think I need a clearer explanation of what you are doing

I am guessing you are taking in three data feeds that want to end up as three...