Hello,

This is my situation:

* Windows 2003 Server R2 SP2 SE + MS SQL Server 2008 EE SP3 + Integration Services Locally installed.
* VC 6.0.8
I setup a task to run a SSIS package in a dtsx which is stored locally. The SSIS package has a protection level "EncryptallWithPassword".
VC service has a startup account of a domain user which is a local admin of the server.
If I'm logged with this user in the server, I can run the dtsx package correctly.
If I setup the SSIS task from VC, providing the credentials with the same user account which I'm logged and which VC service is running, I get the following error:

Unhandled error occured: Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: Failed to remove package protection with error 0xC0014037 "The package is encrypted with a password. The password was not specified, or is not correct.". This occurs in the CPackage::LoadFromXML method.
---> System.Runtime.InteropServices.COMException (0xC0014037): Failed to remove package protection with error 0xC0014037 "The package is encrypted with a password. The password was not specified, or is not correct.". This occurs in the CPackage::LoadFromXML method.
at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.LoadPackage(String FileName, Boolean loadNeutral, IDTSEvents100 pEvents)
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral)
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events)
at SSISExecute2008.SSIS2008.ExecutePackage(TaskSSISInfoClass task)
at F4oJgwASw429oqZF67.uULTZ9jRwXrM03ZOxl.wweHX6Wh6(String[] )
Exception in Task: Non zero exit code


If I install the SSIS.zip file that I found in this forum, and replace files under MSSQL2008 folder, the error is the same but with some additional messages at the bottom.
Unhandled error occured: Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: Failed to remove package protection with error 0xC0014037 "The package is encrypted with a password. The password was not specified, or is not correct.". This occurs in the CPackage::LoadFromXML method.
---> System.Runtime.InteropServices.COMException (0xC0014037): Failed to remove package protection with error 0xC0014037 "The package is encrypted with a password. The password was not specified, or is not correct.". This occurs in the CPackage::LoadFromXML method.
at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.LoadPackage(String FileName, Boolean loadNeutral, IDTSEvents100 pEvents)
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral)
at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events)
at SSISExecute2008.SSIS2008.ExecutePackage(TaskSSISInfoClass task) in C:\sourcefiles\code\SSISExecute2008\SSIS2008.vb:line 32
at SSISExecute2008.Main.Main(String[] args) in C:\sourcefiles\code\SSISExecute2008\Main.vb:line 27
Exception in Task: Non zero exit code

Everything is 32 bits.
I've tried to modify ssis package security with the other possible options but package will never run. It seems that it's uncapable of decrypting the password.
I tried to upload the dtsx package to the integration services and run the task selecting the option "Package Located in Database" but task failed too.
No need to say that I could run the package directly in the Integration Service.

Any idea??

Thank you for the report - please test this version:

http://www.visualcron.co....aspx?g=posts&t=2311 

---

Sorry, posted in wrong place ...

OK, success with new version 6.0.9, but only if I run it in file mode. If I try to run the SSIS package located in database I get this error:

Unhandled error occured: Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.
---> System.Runtime.InteropServices.COMException (0xC0014062): The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.LoadFromSQLServer(String bstrPackagePath, String bstrServerName, String bstrServerUserName, String bstrServerPassword, Boolean bLoadNeutral, IDTSEvents100 pEvents)
at Microsoft.SqlServer.Dts.Runtime.Application.LoadFromSqlServer(String packagePath, String serverName, String serverUserName, String serverPassword, IDTSEvents events)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Dts.Runtime.Application.LoadFromSqlServer(String packagePath, String serverName, String serverUserName, String serverPassword, IDTSEvents events)
at SSISExecute2008.SSIS2008.ExecutePackage(TaskSSISInfoClass task)
at aiQcxUIZ97rbBYdhK9.axW3kZO5fk3EDtF4IW.RucuGcrpu(String[] )
Exception in Task: Non zero exit code

Maybe the settings are incorrect. This is how I configure the task:

Ok, that is something else. It is a timeout error. Not sure if the timeout comes from the database or if it just can connect to the instance. It sounds like the latter.

Can you execute with DTExec on the same machine as VisualCron?

---

Yes, I can run the SSIS package in the VC sever correctly using dtexec. I can run in file mode (dtsx) or connecting to the package store (which is the same VC server).
I'm not sure if I'm using the right syntax in the VC task.
For calling a package which is in a package database, is this syntax correct?
server_name\MSDB\package_name

In my case, server name is the local server.

Please try with package_name only.

---

Already tried that. Just package_name, or MSDB\package_name or server\MSDB\package_name. All of them failed.

I've tested in another server with the following configuration:

* Windows 2008 + SQL Server 2008 + Integrations Services locally installed. All of them 64bits.
* VC 6.0.9

Same error. If I try to run the package from VC, I get the timeout error.
If I run it with the DTExec utility, it runs perfectly.
Please, help!!

Try using an IP to the sql server in the SQL Credential that you use.

---

SQL Credential is a domain user ...
I don't understand where I'd write SQL Server IP.

Edit the Credential and specify the IP in domain name.

---

Not working either ...

Just a heads up. SQL Credential:

Domain: IP to database
Username: database username
Password: database password

do you use it like that?

It should not be Windows user.

---

That's how I setup the credential. I attach a document with the screenshot of the credential and the error message.

I think you are getting closer because now you get a (Login failed for user 'srvsql'.). Please check the logs of the SQL server.

---

I think that the error message is meaningless.It has no sense that in different scenarios (servers & operating systems & logins) I get the same error I've read somewhere something about this kind of errors when thrid party products access to the dcom objects.
I will do further research ...

Problem solved.
The credential provided to run the SSIS package when located in a database must be a SQL login. It can't work with SQL domain authentication.

Thanks anyway.

Just a heads up. SQL Credential:

Domain: IP to database
Username: database username
Password: database password

do you use it like that?

It should not be Windows user.

Thanks for the feedback. We tried to make this clear in this post.

However, we could probably add support for using Integrated authentication. If you are interested in that then please add a request about this in the Feature request forum.

---