I have constructed the DTS. And each step in the DTS has been given a name. eg, load_candidates, load_examinations, delete_fact_tables. The problem is that the error log on the DTS...

Thank you all for your answers.

That is why i love this forum, cause people answer to your requests.

Regarding Adrian Nicjhols reply, thank...

Martin,

although i had checked the 'Notify me when users reply' in my post (I am dfalir) it seems that i missed your answer.

I was looking in Google today...

dear david this is exactly what i do, and i get instead of 5 results, 40 results. (les, is the table readers). have you got any other suggestions? how come...

THANK YOU STAX...I WAS USING STUFF WITH CASE TO ACCOMPLISH THIS, BUT IT WAS TOO SLOW...

PS: THANKS JOHN, GOOD POINT BUT NOT APPLICABLE TO MY CASE! 🙂 I AM THE CLIENT!...

YES IT DID HELP MATE, THANK YOU

Thank you both for your help!

Jeff, when i saw your edit, i couldn't help laugh, and think that you are the god of SQL!!!

lol lol lol ..... very very impressive...

Phil,

thank you very much for your time...

My IT manager has actually made the fuss you are talking about. He has also communicated the...

Phil, i need your help on this pls.. let me post you an example.

old MIS system - Table Software

soft pk      Software_desc                                      software_no(code)

1              AutoCAD 2000i (by AutoDesk) (EN)           201

15            MS Access 2000...

Thank you Michael, thank you Ryan.

It took one view and your suggestions, and i was succesfull.! 🙂

Cheers guys! 🙂

Michael,

you are missing the point. Doing your suggestion, i get two records for the same user. This is because in one database i have all the user's info (eg telephone1)...

Thanks Ryan,

you gave me a good idea to think about...The situation is more complicated tahn this but its a start. 🙂

any other ideas welcome..  

Thank you both...problem solved. 🙂

Steve hi, thank you for your help.

it seems i am doing something wrong.

after your suggestion i wrote the following

select

 addr_fk

 ,count(user_fk)

 from

 ecdldb.dbo.UserAddr

group by addr_fk

having count(*)>1

but it returns null records! however i...

Ok Bill, plz help me with this...

i have a table named candidates. This table has a field called [birthdate] that is of type varchar(50). ok? this field has dates inside...