Hi,

Apologies for the delay in replying.

Both those solutions were very helpful.

Thank you !!

OK, here it is;

I'm trying to get the Customers who did NOT order Products '211' & '73' in their last 3 Orders.

I've tried firstly to get all the Customers last...

MORE INFO

I have a Cube file with 24 months of data & one field has Revenue amounts.

I want to nominate 3 consecutive months & add those months Revenue data together.

Rather...

Hi Henrico,

I want to add the Revenue for all the 3 months for a Quarter calculation & use this amount in a calculation.

So I was thinking of using a function...

I should mention that the 'Size' field is in the 'Data Mapping' option as you select a destination table for the data to transfer to.

Cheers

I found the answer on how to fix this but not yet why it happens.

I used the Import Wizard to create a Package & then looked at how it was...

Hi David,

I have 3 Nodes now (Including the data Conversion Node) in this Project.

The first is the ADO.NET source to connect to a Data Warehouse

Second is the Data Conversion node...

PS, I thought my solution of using a Data Conversion Node to change the data type to varchar was achieving this.

What other options do I have?

Thanks SSCrazy, but I can't use the OLEDB source as it won't connect to my database whereas ADO.NET does.

So I guess I need a workaround for this.

Any ideas?

Thanks

Reason for the error continued...

I found that ESRI .shp (Shapefile) maps for Australia that held very granular data such as Postcodes were naturally bigger in Filesize than maps that had...

I've found the reason why I haven't been able to use these .shp files.

Their size was the problem, they were too big to use in the SSRS (tool of BIDS