Hi,

All you need to do while configuring the pivot key is maintain the same value of key for the columns you want to merge and pivot.

say you have column 1...

Can you tell me the cache setting you have set.I didnt enable the memory restriction so i believe i m not usuing cache and dats why i cannt see the...

Could you elaborate on it.How you join staging to dimension.

I have the same process .I get the data into the staging and from staging i load the dimension and the...

to verify i ran the package with one lookup it works.however when i have 6 lookups it doesnt move at all

I dont see any progress any where.Cache is set to use limited memory.

http://msdn.microsoft.com/en-us/library/ms141713.aspx

this has everthing

saurabh

this one is a handy script as well.for now i got throught that problem.but surely i can use it at many palces.

thanks a lot

Hey Lynn ,

You my man.It worked wonders.

THANKS A TON MAN

I will be more happy to provider you the DDl and the Data,

I ahve working on this since yesterday with no results.I will appreciate if you can help.

My table has...

Thanks guys for such a quick response,

actually the function might work,i used some myself .

the problem is the result set has to use a group by because i need to...

Thanku all.

I got it to work.

if anybody finds the same problem.I can walk you thorugh

thanks a lot

you are about user data type.exactly right but i some how managed it buy breaking it into two part and concatenating the '20' part for the year that...

Hey thanks a lot for the script

it is very handy.

thanks fro the reply.

Let me rephrase the question.

Is it possible to store say soemthign like 107 as date .meaning it doesnt have any date .just month and year.

can i format...

I may not be getting whats exactly happening .

as i knw .column 20 from the the flat file has to go as DT_I4 in the SS.which u werent able to...