SQLEXPRESS 2008 And SSIS Package Scheduling issues
We have a SQLExpress 2008 software, that tracks lab attendance times when students login to a computer lab workstation. I am testing this new version, our current software is using DTS (SQLEXpress 2003). In order to use SSIS package I installed MS SQL Management Studio 2008 R2. I was able to create the SSIS package and when I test it, it works. My problem is, when I added to the Sql Agent schedular (there are two DB CITRACKDB and MSSQLSERVER) SQL Agent only appears on the MSSQLSERVER. I recieve the foollowing errors: Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted 08/03/2011 18:17:50,DaIly CITrack Export,Error,0,ISTEST01,DaIly CITrack Export,(Job outcome),,The job failed. The Job was invoked by User ISTEST01\Administrator. The last step to run was step 1 (Execute Citrack Package).,00:00:01,0,0,,,,0 08/03/2011 18:17:50,DaIly CITrack Export,Error,1,ISTEST01,DaIly CITrack Export,Execute Citrack Package,,Executed as user: RCCD\ISTEST01$. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 6:17:50 PM Error: 2011-08-03 18:17:50.94 Code: 0xC0011007 Source: {F3E48D01-2A89-4DDC-83ED-51983E9FE610} Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted. End Error Error: 2011-08-03 18:17:50.94 Code: 0xC0011002 Source: {F3E48D01-2A89-4DDC-83ED-51983E9FE610} Description: Failed to open package file "C:\Users\Administrator\Documents\Daily Citrack Export.dtsx" due to error 0x80070005 "Access is denied.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format. End Error Could not load package "C:\Users\Administrator\Documents\Daily Citrack Export.dtsx" because of error 0xC0011002. Description: Failed to open package file "C:\Users\Administrator\Documents\Daily Citrack Export.dtsx" due to error 0x80070005 "Access is denied.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format. Source: {F3E48D01-2A89-4DDC-83ED-51983E9FE610} Started: 6:17:50 PM Finished: 6:17:50 PM Elapsed: 0.032 seconds. The package could not be found. The step failed.,00:00:01,0,0,,,,0
August 3rd, 2011 9:41pm

This may be the issue because of User running SQL Server Agent Service doesn't have the access to location where Package is stored Check SQL Server Agent Service Properties ( LOG ON ) which user name present and whether same user has access to file location where you have stored the package . HTHShailesh , Please mark the post as answered if it answers your question.
Free Windows Admin Tool Kit Click here and download it now
August 4th, 2011 2:09am

SSIS is NOT included in SQL Express Edition, nor is Agent. I'm assuming CITRACKDB is your Express instance, and that's why you can't execute the package. You have no other option than to upgrade to a Standard Edition, or process the information remotely on a server with a higher edition. Talk to me now on
August 4th, 2011 1:59pm

I imported the SQL Express SSIS package into SQL 2008 R2 Integrations Services and the log on for the SQL Serve Agent is ISTEST01\Administrator same as SLQ Express database
Free Windows Admin Tool Kit Click here and download it now
August 5th, 2011 1:48pm

I'm not sure what you're trying to say there. You asked why you couldn't see Agent on your Express instance... that's cause it's Express. Talk to me now on
August 5th, 2011 2:27pm

I imported the SQL Express SSIS package into SQL 2008 R2 Integrations Services and the log on for the SQL Serve Agent is ISTEST01\Administrator same as SLQ Express database your case doesn't make sense! do you want to create a package under SQL Express? if yes , you can not! Todd explained it as well. if you mean anything else explain more. what do you mean by "importing the sql express SSIS package into sql 2008 R2 integration services" ?! what edition of R2 do you mean? do you have an existing package already? do you want to run it under sql server? you need a sql server version other than express here.http://www.rad.pasfu.com My Submitted sessions at sqlbits.com
Free Windows Admin Tool Kit Click here and download it now
August 6th, 2011 3:14pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics