fantastic mate thanks

should the dates be on the fact table or the dimension table?

thanks for the replys 🙂

thanks very much for the reply, do you mind explaining a bit please

thansk

I create a key on the table dimdate and arrange the dates on the tblApplication with the format/datatype and then create a relationship in the cube designer?

or do I add multiple fields to the table

so for example tblApplication has the fields

ApplicationDate

ApplicationMonth

ApplicationYear

and I create a hierarchy using the existing fields?

thanks for the reply

how do I link each for the date fields to the date dimension?

Lynn Pettis (6/10/2016)

---

You should start looking at the collation of character columns within the database looking for conflicts. From the one error message you posted it looks like there...

I apologise for my incoherent posts

the problem is solved

I restarted visual studio and it wanted to resolve the collation errors its self this time before it updated the objects...

so I have procs on prod, id like to move to UAT

and I cant because of these Collation errors

yet the collation set up on both servers seems to be the...

but general cannot resolve collation conflict errors

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the UNION operation.

I have 2 servers PROD and UAT

all dev has been done on Prod recently, ive just started here and I want to do my dev on UAT (no dev environment)

first...

it is getting data from text files and putting it back in other text files

the text files were on the file server and I moved them to the sql server...

thanks for the replies

I have built a ssis package with a for each loop from a result set

all working swimmingly

thanks again