I have problem in scheduling the dts jobs in SQL Server 2005.
I have migrated from SQL Server 2000 to SQL Server 2005 along with 10 dts jobs. These dts jobs work fine when I execute in SQL Server Management Studio. When I schedule using SQL Server Agent, it fails. I tried this using windows authentication and also SQL Server user. When I look into the history, I am not able see any meaning ful message. I says "The package execution failed. The step failed". These dts pacakges has dos commands like pkunzip, xcopy, have VB code and transformations.
I created a package using SQL Server Business Intelligence Development Environment. and tried using dtexec and dtsrun. But it not working.
I have migrated these applications using windows authentication. When I migrate using user accounts, I get error code 0x80040E14 (Access to Integration Services Package is denied).
Can someone give me the right solution? This is very urgent.