Hi, I tried to run dtexec /SQL command to execute my SSIS package. I'm getting the following error. Please help. Could not load package "Listener" because of error 0xC0014062. Description: The LoadFromSQLServer method has encountered OLE DB error code 0x8\ 0040E14 (Only the owner of DTS Package 'Listener' or a member of the sysadmin r\ ole may create new versions of it.). The SQL statement that was issued has fai\ led. Thanks, Amit

Seems this post answers your inquiery: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/7c0d7003-7a78-470d-b6bc-6a905545c5acArthur My Blog

Arthur I appreciate your help. but I guess that post discusses about a different issue (Login time expired) and I'm getting Error code 0x8\0040E14 (Only the owner of DTS Package 'Listener' or a member of the sysadmin role may create new versions of it.) Thanks once again tho. Amit

Hi Amit, 0x80040E14 means DB_E_ERRORSINCOMMAND. It is OLE DB error, and means the command text contained one or more errors, typically a syntax error or unexpected keyword. The error string should contain the unexpected token. Actually, while loading package from SQL Server, the SQL Server Integration Services(SSIS) will create a connection to the SQL Server, and then use the stored procedure [sp_ssis_getpackage] to get the pacakge. At the begining of the stroed proceduce, there are some codes that are used to check if the current user has the permissions to load the pacakge. If the user is not a member of "db_ssisltduser", error 14307 will be raised. If the user is not a member of "db_ssisltduser", error 14586 will be raised. So, in this case, please first check the command is correct. Then based on the error message "Only the owner of DTS Package 'Listener' or a member of the sysadmin role may create new versions of it", please check if there is error 14307 or 14586 in the SQL Server error log. If so, please add the user to proper roles. For more information, please see: SQL Errors: http://msdn.microsoft.com/ja-jp/library/cc431524.aspx Using Integration Services Roles: http://technet.microsoft.com/en-us/library/ms141053.aspx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Jin, Thanks for your reply. I found the problem. You are right. It was a permission issue. Amit "So, in this case, please first check the command is correct. Then based on the error message "Only the owner of DTS Package 'Listener' or a member of the sysadmin role may create new versions of it", please check if there is error 14307 or 14586 in the SQL Server error log. If so, please add the user to proper roles." Amit Patel