Thanks,

Its working:-)

Thanks for reply,

It is in existing table and i can not change it.

consider there is column A which have datatype Nvarchar

and while selecting if it is numric value i have...

Thanks!! can you give one example

What is difference in ExecutionLog2 and ExecutionLog3 view?

Can we see that particular table in database is affected by which ssis task or which job perform on that table??

thanks:-) and what about Datasource table

What about subscription table does it hold data temporary or as soon as subscription deleted the related record deletet from subscription table??????????

:-)Is it possible to change the value of "ExecutionLogDaysKept"?If possible how to change