Hi Arun

I have the below proc but the problem with proc when it does the insert on missing profiles step it's fails with duplicate key and i understand that, what...

Thanks for your help!!

Hi Arun

I think i'm the slow one, i need to select from the source table to format the required data. Using that declare statement created early and it works but...

Thanks,

Do i have to type each name that needs to be splitted?

Tx, i will test the scenario.

Dont worry guys, i've sorted my problem

Tx

What i'm trying to say is:

I'm selecting data from the same source (e.g AdWorks db) then output the data to csv format to different network path

tx

Thanks for suggestions, i've used a script sent by hoosen.;-)

Hi

Still get the same error

Ta!!

Thanks for your answer

Currently i hold MCITP (DBA) for SQL 2005

Now i need to advance my skills in BI that means i need to take exams for BI

My question is does Microsoft give...

Thanks for your response

what i meant was i'm qualified DBA but i need to certify for BI do Microsoft accredite you to write 446 PRO or write the whole exam...

Hi

When i execute spaceanalysis.job it fails with the below or is it me

Msg 206, Level 16, State 2, Procedure sp_add_jobstep, Line 0

Operand type clash: int is incompatible with uniqueidentifier

That's good stuff

Thanks for your response

It only says the job was invoked by user domain\test but the whole package works fine.

Does it have to do with SP2?

Tx!!