Want to clarify datasource is Sybase ASE ODBC Driver.. i need to connect this datasource using SSIS.

Thanks SSC.

Yes i also find that this is the only way to add new column to index.

I dropped it first and then recreated with adding new column.

Thanks Ten for reply.

The link you provided is really nice.

I have resolved that issue..I added the beloe statement for catch block to pass the actual error to client.And this returned...

I am still not able to make any progress.

The steps i am doing:

1st step:Execute Sql task--To get the max(date) mdate from table and assign the madate to user defined variable...

Hi ,

Thanks for reply. Yes it can be done by SP also but requirement is to get it done by SSIS only so any help would be really appreciable.