Is it possbile to use this function to join two tables .I mean joining on Fname by using soundex function

Thanks guys

Sorry for not mentioning properly....The number is a ..I m not rounding it off...i just want to remove that decimal....for ex if the number 789.90 .....after removing decimal it should...

Thank you very much

In the attach database dailog box i can see only ADD button .When i click tat button and directed to .mdf file and after that i clicked OK .....then i...

How can i change that could you please guide me

In Msgbox when i pass the string to variable it showing

C:\Information Technology\Dral\Darl_ENC.Zip

After completion of this task when it comes to procees execute task

I am getting an error message

Incorrect FilePath:C:\INFORMATION...

I am not sure how to pass the command line .I am using windows 2003 server, and winzip 8.1 version.I heard that this OS doesnt support command line to unzip...

I did but it is giving me an

error:Invalid FileName:@@[User::strSourceFileZip].Zip

Executable:C:\Program Files (x86)\WinZip\WINZIP32.EXE

Arguments: -e @[User::strSourceFileZip]

WorkingDir:U:\InformationTechnology\Datawarehouse\Do

Is there any thing i need to add

Thank you very much for your answer...........Is there any other way i can open the zip using ny ssis task......I have tried using with scrit task but......iam not getting the...

Msg 2812, Level 16, State 62, Line 2

Could not find stored procedure 'master..xp_varbintohexstr'.

The statement has been terminated.

I dont have any idea wat this SP does

exec sp_addextendedproc N'xp_varbintohexstr', N'xprepl.dll'

Did you wite that variable in readwritevariable in script task editor..

ReadWriteVariables:Globalvar1,globalvar2

The variable which you want to change the value at run time

Public Sub Main()

Try

Dim gvLogFile As String

...

You need to rewrite this in script task using VB.Net.You cannot migrate this kind of activeXscript to SSIS

I did that But still i am unable to assign the values