This is the query i was trying to do...

i was trying to get vend_i and dept which has max(wgt) when grouped by vend_i and dept

select vend_i,dept,max(tot_wgt)

from

table1

group by vend_i,dept

Thanks for the help....

Tried Enabling Identity Insert and it worked..

Stored Proc is for deleting the data from a table.

i have used the cmd.commandTimeout property...

Even then,it is giving the same error..

Thanku 4 reply Jack !!!

And I m sorry..i couldnt reply u back...

Where can i change tht default setting for timeout...

In the package,there are few script tasks and Execute Process tasks..

' Microsoft SQL Server Integration Services Script Task

' Write scripts using Microsoft Visual Basic

' The ScriptMain class is the entry point of the Script Task.

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Public...

Unloads the data from a table ....

shithij,

I want this output in SQL Server Business Intelligence Studio...