Hi,

Thanks for you suggestions.

I have solved the problem by using the Format function while reading the data from the excel file.

In the Excel Source Editor - SQL command text while...

Hi Koen,

I have attached the screenshots of the job step configuration.

I also have tried executing the package through CMDExec which also failed.

Please let me know where I'm going...

Yes. I'm using Integration services Job step in calling the package.

Hi,

Now I'm having problem while scheduling the package to run through the SQL job. The package is running successfully through the execute package utility but it is always failing through...

Hi Koen, Preethi,

Thanks for your help. The problem is with the 64 bit environment only as mentioned. I have Set the Run64BitRuntime property to false and it started working as...

Hi,

I have set the delay validation property to true on the package as well as the connection and tested. It fails there as well. I have another similar packages...

Hi,

That solved my problem. Thanks for the simple solution :-).

Cheers,

Krishna Chaitanya