Post reply

error executing SSIS packages as sql job

  • August 3, 2009 at 9:05 am

    #385103

    Hi,

    I have created a SSIS package and I am trying to run this using sql job. I am getting this error in the job log when I try to run it. The package contains a script task and that is where it is failing.

    Source: Check if File Exists Check if File Exists Description: There was an exception while loading Script Task from XML: System.Exception: Cannot construct a path for temporary storage under C:\Users\administrator\AppData\Local\Temp\. at Microsoft.VisualStudio.TemplateWizard.Wizard.GetTempDirPath() at Microsoft.VisualStudio.TemplateWizard.Wizard.Execute(Object application Int32 hwndOwner Object[]& ContextParams Object[]& CustomParams wizardResult& retval) at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.InitNewScript(String languageID String projectname String projectext Boolean bCleanupOnClose) at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.InitNewScript(String languageID String projectname String projectext) at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.MigrateVSAScriptTask(XmlElement elemProj IDTSInfoEvents events) at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.LoadFromXML(XmlElement elemProj IDTSInfoEvents events) End

    Please let me know.

    Thanks,

    sridhar.

  • August 12, 2009 at 3:05 pm

    #1038331

    Are you using script task just to check if file exists?

  • August 13, 2009 at 7:48 am

    #1038687

    yes I am using the script task to check if the file exists. Initially the package is written using visual studio 2005 version. so it is generating bunch of warnings in the event log and also creating log files with these warnings. so if the C:\ drive where our system databases exist doesn't have enough space, it is giving that error message. If I clear some space, the package runs fine but it still generates warnings and creates log files. so I converted the package to 2008 version. After that, there are no warnings and no creation of log files. everything is working fine.

    Thank you for the response.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply