Error Code 0xC0202009 + connection password

Hi,

I have developed a .dtsx package than runs normally from my computer. When I import it on the server and assign it to a job it always fails.

I tried also to run it directly from the server (remote desktop) and also faild. I exported the dtsx file on server and refresh the db connections and after that workd fine from the server.

Another work-around was to use windows authentication. Then runs normally from the server.

It seems that connection password is lost when importing the report on server. (The import is done in MSDB not in the filesystem)

But I can not design all the jobs on the server (work-around A) or use windows authentication (work-around B)

What is the problem and what can I do

I have also played around with "save sensitive information" but with no results.

Thanks

Answer this question

Error Code 0xC0202009 + connection password

tonyKM

I save package to a flie and import it to SQL server. How is it possible to save directly into SQL Server I did not find out something.

In any case, using "EncryptSensitiveWithPassword" with the file should be working.

Fotis
Stevezilla2000

Right-click on your project and choose "Add Existing Package..."

In the dialog that shows up you can specify a SQL Server as the source

Hth,
Ovidiu
jaw56
Hi

I want to run a package in msdb with windows authentication. Import the package from file system, using "relay on server storage and roles for acces control" and can not still execute the package from managment studio. When I write the password in the connection manager I can execute the package. So I think the problem is in the package's encryption.

I'm logged on the server as local administrator, is it possilbe this user not to have permisions to decrypt packages, but only to execute them. What access I must have to decrypt packages. I made the package on my computer, I have 32 bit sql server, I import it on 64bit server is it possible this to be a problem

What can be the problem, thanks
tiltstern

0xC0014061 means that

The protection level, ServerStorage, cannot be used when saving to this destination. The system could not verify that the destination supports secure storage capability.

Are you saving the package on a SQL Server or to a file You can use ServerStorage ONLY if you save the package on SQL Server

HTH,
Ovidiu
steven_h

Thanks a lot for your answer. One last question. How is it possible to open from BIDS a package stored in SQL server without exporting is first

Regards
Astro_4

Thanks for your reply, but did not help a lot since now.

I have already tryied to use "EncryptSensitiveWithPassword" but with no results. Also I can not understand how I can user "Serverstorage" directly from Visual Studio Designer. When i try that i get an "0xC0014061" error.

Any idea
Bart Doise

To save a package from BIDS directly to SQL Server use File-> "Save Copy of <package_name>.dtsx As..."

HTH,
Ovidiu
StevieMac

The problem is that you have the ProtectionLevel set to "EncryptSensitiveWithUserKey". This means the package can be executed only by the user that created the package and on the machine that it was created.

If you import the package on your server I recomend to change the ProtectionLevel to "EncryptSensitiveWithPassword" - will ecnrypt sensitive information like passwords - or if you store the package on SqlServer you can use "Rely on server storageand rolse for access control" - this means that the package will be stored unencrypted on the SQL Server.

The package can be stored unencrypted ONLY in the SQL Server.

HTH.
Ovidiu Burlacu
Error Code 0xC0202009 + connection password

Answer this question