I know this is somewhat 'shutting the stable door after the horse has bolted', but it may help prevent such a drastic problem another time if you limit the size...

True, but permissions to tables should be under exclusive control of DBAs whereas ACL could be changed by IT Ops/Domain Admins etc.

zanoni.harris (5/14/2009)

---

Could someone comment on some of the practical applications of using the XML configuration file approach instead of using a SQL server table?

...what I mean is what the advantages...

BCC

I can think of a couple of ways off the top of my head, but there are probably others.

1. Using variables and expressions.

2. Using a script task(!)

The choice...

Paul Paiva (5/7/2009)

---

...

As was clearly stated in the "Purpose/Scope" section of the article, the intention is to show how you can use a script task to send email....

BCC,

Hopefully these screenshots shold give you a start.

You'll need to add expressions to the Send Mail task which will reference existing variables.

You can test your expressions for syntax errors...

Precisely. If you want to design your packages to be able to take advantages of...

If you are going to use a Script Task (and I wouldn't personally for reasons already stated in previous posts), you should use the concepts LockForWrite/Read and LockOneForWrite/Read rather than...

Brett Flippin (5/6/2009)

---

It sounds like from that example that you could do that with For or Foreach Loop container to loop through your emails and do the appropriate operations instead...

Useful article, but I think it is easier to use the Send Mail task with Expressions to dynamically set properties such as MessageSource, To, From, Subject etc.

Automatic Page Repair is available in Enterprise and Developer Editions for SQL Server 2008, so as 'Developer Edition' was not listed in the available answers I guess that 'Enterprise only'...

Running SQL Server under the Local System account is dangerous as the account has far more privileges than it needs. Try to avoid this if at all possible and check...

Laura,

To set up a SQL Server Log Provider, do the following steps:

[font="System"]1. Open the package for which you want to configure logging in BIDS.

2. Select 'Logging...' from the SSIS menu.

3....

Jack,

There is no direct correlation between the Log Providers and failing packages/data flows, By that I mean that the use of a Log Provider in and of itself will not...

Jack,

The solution clearly provides what you want in terms of error handling/logging, but wouldn't it be easier to use the Log Providers that are readily available with SSIS? For example,...