hi lookup but how can i add new column to the script component i just had read variable write varibale and expression but i couldnt find anyhting to add...

hey tim plz could you give me some good links or pdfs to learn abt scripting ...beacuse i am not familiar with the script you wrote like dim as such...

thkz tim n micheal ..gotch u

HI MICHEAL AND TIM..TJKZ FOR UR INFO..BUT I AM NEW TO SSIS SO I DOUBT IF I JUS WANT TO HAVE A LOOKUP THEN HOW COULD IT MATCH ...

IF IN...

hi david ..could plz explain me or attach a screen shot of ur DF u created so that i can understand easily ...thkz in advance

yeah may be tats the reason its been taking long time i didnt know that thanks micheal so i belive it better to update the data than using...

if i dont want to change the data can i use the same replace in a join condition like

on d.abc= c.replace('abc'----i could not get that could you please let...

i dont have any knowledge on dts i started working directly on ssis this is my first project and

even i was about to say the same solution which...

i think the problem is that in the second row you have jus two columns thats where the error occurs so it consider two columns of the second row ...

thats what if the delay validation is set to false it validates 2 times ...on ei s before the execution during pre-execution and whill executing the package anyway i am...

may be go through this gyannedra u shall get an idea i m sure

http://wiki.sqlis.com/default.aspx/SQLISWiki/DelayValidation.html

gotchu thkz a lot

I'm sorry, I don't believe I understand what you are trying to say.

If you are asking why I want to turn that validation when I open a package to continue...

thkz got it but a small doubt agaian where can i see how much of the memory is used in the execution results or where can i see that...

but george thanks for ur info but it doesnt show up for me in BIDS when i open the package it jus shows ready thast it ...,may be it has...