One more question i know the configuration file doesn't store the Username and Password information of the connection string but i guess if u select the option Encrypt sensitive data...

Thanks

Here are some of the error message when the package was run

Error: Columns "Derived Column T_TIME" AND "T_TIME" cannot convert between unicode and non-unicode string data types.

(Here the name of...

I am pretty sure its the issue with the data type.......Can you help me in creating the Expression for the derived columns???

Thanks,

Pradeep

One more question...I have a query with high number of statement executions but i believe the query is not stored in cache....How do i make sure that query is stored...

Thanks for the info.....So in short the queries with estimated execution plans in the cache run faster

They are not stored procedures.....they are just statements