I have tried above thing but I am getting following error:
when I compile my application I get following errors:
Error Code :-1073450910
Sub Component :- Script Component [43]
Description :- System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.CreateUserComponent()
Error Code :-1073450901
Sub Component :-DTS.Pipeline
Description :- "component "Script Component" (43)" failed validation and returned validation status "VS_ISBROKEN".
So what can be done to solve this?