I'm glad it worked for you.

You can store the configuration information in a SQL table as well as an XML file, this may give you greater flexibility for updates.

Graham

FYI - I have resolved this myself.

I think I was getting confused over the "AlwaysUseDefaultCodePage" property of the DataSource, I thought it was behaving in the opposite way.

Setting AlwaysUseDefaultCodePage to...

Hi,

You can use a configuration file to make the changes.

In the "SSIS" drop down select the "Package Configurations..." and you can configure which values you would like to store as...

Hi,

The Execute Package Task gives you the option for the location of the SSIS package you want to execute (either in SQL Server or the File System).

I'm guessing this is...

I have no idea why, but when the SQL Server is logged in as the same user that another machine is logged in as (and connecting to the cube) the...

I'm still having some weird issues...

When I login to the server SQL01 as the user the linked server is using the query will not run from another machine, but when...

FANTASTIC!

I _really_ can't thank you enough.

I went for the proxy account route which seems to work for me, no more faffing with SPNs!

Thank you!

Graham

It appears I was wrong!

GRussell31 (8/3/2012)

---

I have checked and it is using the 64bit version of DTExec when the SSIS package is double clicked, which is what I believe BIDS...

Hi,

I have been able to get the package to run by running it within BIDS on the live server. Not ideal but it does seem to prove that it...

Hi,

I have set SSIS to log the errors to a SQL Server table, and I have just saved them to a text file (attached - but I have commented out...

Hi,

The FailPackageOnFailure is greyed out (but showing False) at a package level and FailParentOnFailure is also showing False.

I have a feeling some of the child packages may have the FailParentOnFailure...

Hi,

Thank you for your reply.

You are correct that implementing the email via the Event Handler works correctly (and so I've implemented that approach).

I have no idea why the error path...

Hi,

I am still having this problem and would appreciate any suggestions on how to resolve it.

When my SSIS package calls a SQL Task (which calls a stored procedure which...

Hi,

Probably a bit late for you, but maybe not for others.

Today we renamed a SQL 2008R2 server and tried to setup log shipping and got a similar error.

We renamed the...

I was wondering if the approach used in the article saved the XML with the root node as well as I'm trying to understand what is adding it.