Thanks so much

Regards

Usha

Hi,

1.Add a data flow task.

2.In data flow,select flat file source

3.Give a name for connection manager.

4.Click on browse,select the file file c:\data,

5.Select the checkbox if the csv has column names as...

Hi

I did the following steps:

Add a variable in variables pane.. call it "MaxVal" and select

the right datatype..

Drag&Drop an Execute SQL Task and then configure it with following...

Hi

Thanks so much for your reply.But the value of variable is not getting updated after execution.I can view the new value in watch window when i debug.

Regards

Usha

Hi

I was able to fix the previous issue.I registered dll for dts again.Now regarding Winzip,I have winzip command line utility in Execute Process task.If I run it using Execute button...

Thanks for your reply.I tried re-starting SQL Server Agent.But the issue is  not yet fixed.

Hi

I have got the license for winzip tool.Now am facing another issue.

Thanks.Will try and let you know the result.

Thanx for your help.I ll try to fix the prob and let u know.

Usha

Thanx so much.