When I try to see the generated code of one of my SQL Agent Jobs, that simply runs a SSIS package, I get the text "Specified cast is not valid" displayed in the main area.
and sometimes the following error message is displayed:
The script generation works fine on SSMS, so I've made some quick investigation and found that Toad fails to generate the T-SQL code for jobs that use some proxy account. I've attached a simplified version of my job. To reproduce the bug just run the code twice: with and without the proxy clause
--,@proxy_name = N'ssis_user_proxy'
and try to generate the job T-SQL script.
*Note: You may need to create some new & valid proxy to your db server.
The problem affects Toad for SQL Server 6.6, as well as the latest beta 188.8.131.52 .
job_sql_problem.sql (2.26 KB)