Similar to
I have an SSIS package with a script task which is an excel file And makes it fill with the data of the SQL stored procedure (by Microsoft.office.inter.excel). It works great when running through the SSIS catalog and running the manually deployed package, but when I schedule a task to run automatically through SQL Server Agent, the package script fails in the work phase lives. I am working as a proxy account, which is similar to the account that I am logging on to the server when testing (and similarly as the manual works on running packages).
Understand that even if the job is using a proxy, any desktop interaction occurs within the profile context of the SQL Server Agent login because the profile is not actively logged in, so interaction fails it happens. While digging in more, the package named "Interactive mode" has a boolean system variable set to "false". I have felt that if I can really change it, then everything will be laughing. The problem is that the variable is accessible only in the form of "readonly" for my script work ...
Is there any way to set up a system: Interactive Modified Convertible Manual in an SSIS Package Runtime from time to time or program? Please help! I am running these scheduled jobs now to run manually, which is a big pain.
Thank you.
I encountered this problem a few months ago and it came to know that the execution option is to use 32 bit runtime It is necessary to set up if you are using SQL Server 2008 R2, you can open your work and double click on the step. This is under the Performance Options tab 
If you have errors If you are interested, then you may want to consider changing the package so that it uses the file system function to change the name of the Excel document / to re-store the data flow so that you take the data from your stored procedure to your Excel document. Could. Depending on your data, you may need to add a data conversion step in the middle. Here's a good article on the topic:
Edit: I have not used SQL Server 2012 yet, but according to MSDN , It seems that the option is under the Configuration tab, here's the article:
Comments
Post a Comment