Error loading value

I have been getting the error below from an SSIS Package that has been running successfully in production for 2 Months. Also, this started after we installed SP2. We had errors durring the SP2 installation durring the Notification Services and Workstation Tools install but the installation program reported that the installations were successfull so I am not sure if this is related.

Here is the error message:

Date 6/12/2007 4:53:12 PM
Log Job History (SchedulerEMailer)

Step ID 1
Server MISSRV7
Job Name SchedulerEMailer
Step Name new step
Duration 00:00:08
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: XSRV7\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:53:12 PM Error: 2007-06-12 16:53:19.90 Code: 0xC0010018 Source: Description: Error loading value "<DTS:LogProvider xmlnsTS="www.microsoft.com/SqlServer/Dts"><DTSroperty DTS:Name="ConfigString">MISSRV7.SSISConfig.ssisuser</DTSroperty><DTSroperty DTS:Name="DelayValidation">0</DTSroperty><DTSroperty DTS:Name="ObjectName">SSIS log provider for " from node "DTS:LogProvider". End Error Could not load package "\ApptEmailer" because of error 0xC0010014. Description: One or more error occurred. There should be more specific errors preceding this one that explains the details of the errors. This message is used as a return value from functions that encounter errors. Source: Started: 4:53:12 PM Finished: 4:53:19 PM Elapsed: 7 seconds. The package could not be loaded. The step failed.

Any help would be greatly appreciated!!!

One problem that can possibly lead to this error is described in this KB:

http://support.microsoft.com/default.aspx/kb/913817

Please check if it affects your installation.

|||Hi

I am receiving this same error. Did you ever resolve it?

Thanks in advance

Error installing SQL Server Management Studio Express

Yesterday I successfully installed Microsoft Visual Basic 2005 Express Edition which included SQL Server 2005 Express. Today I noticed I needed to download the Management Studio seperate download. I downloaded SQLServer2005_SSMSEE.msi and executed it and get the following error:

Error reading from file C:\...\SQLServer2005_SSMSEE.msi. Verify that the file exists and that you can access it..

Solved my own problem. Once I moved the msi to C:\ the installation worked. Apparently the path it was in was too long causing it to be unreadable. c:\xxxx\xxxx\SQLServer2005_SSMSEE.msiSQLServer2005_SSMSEE.msi.

Make sure you download the management tools for Express as well - it will make your life easier.

Buck Woody

Error installing SQL Server Management Studio Express

Yesterday I successfully installed Microsoft Visual Basic 2005 Express Edition which included SQL Server 2005 Express. Today I noticed I needed to download the Management Studio seperate download. I downloaded SQLServer2005_SSMSEE.msi and executed it and get the following error:

Error reading from file C:\...\SQLServer2005_SSMSEE.msi. Verify that the file exists and that you can access it..

Solved my own problem. Once I moved the msi to C:\ the installation worked. Apparently the path it was in was too long causing it to be unreadable. c:\xxxx\xxxx\SQLServer2005_SSMSEE.msiSQLServer2005_SSMSEE.msi.

Make sure you download the management tools for Express as well - it will make your life easier.

Buck Woody

sql

Error in Merge replication "The schema script..."

I'm trying to set up a merge replication. Publication is created successfully and snapshot also, but when I create pull subscription on subscriber server and merge agent starts, after some time I get an error message of this type:

The schema script '\\ANIL\REPLDATA\unc\ANIL_BEJK_BEJK\20070625142735\dl_HF_vMSCene_3836.sch' could not be propagated to the subscriber.

It seams there is a problem with certain Views and SPs, because tables are successfully created, and some Views and SPs also.

I tried to exclude problematic articles, but every time another one pops up. Up until now, I excluded 7 articles from publication (1 Stored Procedure and 6 Views) but I still get errors.

I gave up because I can't exclude half of the Views and SPs just to make it work.

Is there something that can be done to solve this problem?

Thanks!
Does your SQL Server agent account have rights to read the share \\anil\repldata? Ensure that this account also has rights to list files and folders on the physical drive underlying \\anil\repldata.

If you are using a push subscription it should be the SQL Server agent account on the publisher. If you are using a pull subscription is should be the SQL Server agent account on the subscriber.|||

Hi Hilary

Sharing permisions were set to Read/Write to "Everyone", and security permisions also Read/Write to "Everyone", but it didn't work until I added an account on subscriber computer (which is not in domain) with same username and password as one that exists on publisher (which is in domain). I set SQL Server Agent to use that account and everything started to work fine.

I'm connecting to publisher using the VPN, and despite the fact that those two accounts are not from the same domain, everything is working fine. This is a little bit confusing. It looks like domain name doesn't play any role when logging in to shared folder.

Thanks for the help.

Anil

Error in Merge replication "The schema script..."

I'm trying to set up a merge replication. Publication is created successfully and snapshot also, but when I create pull subscription on subscriber server and merge agent starts, after some time I get an error message of this type:

The schema script '\\ANIL\REPLDATA\unc\ANIL_BEJK_BEJK\20070625142735\dl_HF_vMSCene_3836.sch' could not be propagated to the subscriber.

It seams there is a problem with certain Views and SPs, because tables are successfully created, and some Views and SPs also.

I tried to exclude problematic articles, but every time another one pops up. Up until now, I excluded 7 articles from publication (1 Stored Procedure and 6 Views) but I still get errors.

I gave up because I can't exclude half of the Views and SPs just to make it work.

Is there something that can be done to solve this problem?

Thanks!
Does your SQL Server agent account have rights to read the share \\anil\repldata? Ensure that this account also has rights to list files and folders on the physical drive underlying \\anil\repldata.

If you are using a push subscription it should be the SQL Server agent account on the publisher. If you are using a pull subscription is should be the SQL Server agent account on the subscriber.|||

Hi Hilary

Sharing permisions were set to Read/Write to "Everyone", and security permisions also Read/Write to "Everyone", but it didn't work until I added an account on subscriber computer (which is not in domain) with same username and password as one that exists on publisher (which is in domain). I set SQL Server Agent to use that account and everything started to work fine.

I'm connecting to publisher using the VPN, and despite the fact that those two accounts are not from the same domain, everything is working fine. This is a little bit confusing. It looks like domain name doesn't play any role when logging in to shared folder.

Thanks for the help.

Anil

Error in installing SP1 or sp2

I have a sql server 2005 developer edition installed on my windows xp system.

I apply sql server 2005 sp1 then sp2 all does successfully.

Now I have installed same sql server 2005 developer edition on windows 2003 server

When I installed sp1 or sp2 i get the following error

Invalid Login Information

Your account information could not be verified for one or more instances.

Ensure that you can connect to all the selected instances using the account information provided.

To proceed further deselect the instances to which connectivity cannot be established.

OK

I have done every thing.PRovided sql server as well as windows authentication.

I can easily login by both.But Can't able to apply any Service pack even I uninstalled or reinstall the product.

Please help me what can i do ?

In SP2 when you dismiss the "Invalid Login Information" dialog, you will be taken back to the grid. The actual error message should be show in the grid. What error are you receiving, you may need to resize the "Status" column to see the full error.

Thanks,

Peter Saddow

|||.
I am simply getting the invalid authentication error I don't know Why it happens ?|||

I doesn't get any such Dialog

In SP2 when you dismiss the "Invalid Login Information" dialog, you will be taken back to the grid. The actual error message should be show in the grid. What error are you receiving, you may need to resize the "Status" column to see the full error.

|||SQL Server Configuration Manager=>SQL Server 2005 Services=>SQL Server Reporting Services=>Properties
Log On Tab => Configure => Database Setup

Error in installing SP1 or sp2

I have a sql server 2005 developer edition installed on my windows xp system.

I apply sql server 2005 sp1 then sp2 all does successfully.

Now I have installed same sql server 2005 developer edition on windows 2003 server

When I installed sp1 or sp2 i get the following error

Invalid Login Information

Your account information could not be verified for one or more instances.

Ensure that you can connect to all the selected instances using the account information provided.

To proceed further deselect the instances to which connectivity cannot be established.

OK

I have done every thing.PRovided sql server as well as windows authentication.

I can easily login by both.But Can't able to apply any Service pack even I uninstalled or reinstall the product.

Please help me what can i do ?

In SP2 when you dismiss the "Invalid Login Information" dialog, you will be taken back to the grid. The actual error message should be show in the grid. What error are you receiving, you may need to resize the "Status" column to see the full error.

Thanks,

Peter Saddow

|||.
I am simply getting the invalid authentication error I don't know Why it happens ?|||

I doesn't get any such Dialog

In SP2 when you dismiss the "Invalid Login Information" dialog, you will be taken back to the grid. The actual error message should be show in the grid. What error are you receiving, you may need to resize the "Status" column to see the full error.

|||SQL Server Configuration Manager=>SQL Server 2005 Services=>SQL Server Reporting Services=>Properties
Log On Tab => Configure => Database Setup

Error in installing SP1 or sp2

I have a sql server 2005 developer edition installed on my windows xp system.

I apply sql server 2005 sp1 then sp2 all does successfully.

Now I have installed same sql server 2005 developer edition on windows 2003 server

When I installed sp1 or sp2 i get the following error

Invalid Login Information

Your account information could not be verified for one or more instances.

Ensure that you can connect to all the selected instances using the account information provided.

To proceed further deselect the instances to which connectivity cannot be established.

OK

I have done every thing.PRovided sql server as well as windows authentication.

I can easily login by both.But Can't able to apply any Service pack even I uninstalled or reinstall the product.

Please help me what can i do ?

In SP2 when you dismiss the "Invalid Login Information" dialog, you will be taken back to the grid. The actual error message should be show in the grid. What error are you receiving, you may need to resize the "Status" column to see the full error.

Thanks,

Peter Saddow

|||.
I am simply getting the invalid authentication error I don't know Why it happens ?|||

I doesn't get any such Dialog

In SP2 when you dismiss the "Invalid Login Information" dialog, you will be taken back to the grid. The actual error message should be show in the grid. What error are you receiving, you may need to resize the "Status" column to see the full error.

|||SQL Server Configuration Manager=>SQL Server 2005 Services=>SQL Server Reporting Services=>Properties
Log On Tab => Configure => Database Setup