No i am not able to change the source.

column_name is not the name of the column, it just mentions the name of the column that is in the source.

Hi ,

thanks for the reply , actually it was nothing to do with the float data type.There were nulls in the source table so i was getting null.I just overlooked...

Hi,

Thanks for the help , i had created a services account and through that i was running the packages now.They are working fine.

Thanks

Thanks for the Help i will put this topic as closed.:-)

My connection string looks like this for excel, so if the user with the services account exists in the server then it should be able to acces the file., i...

i am referring to the service account, the excel file is not password protected. and i think you are right that i need to have my windows account to have...