This is a great article and a much needed idea.:)

In my opinion something like this should have been built into SSIS as part of standard logging.

Its great to start seeing some MDX here. I did not know you can use aliases in MDX.

Thanks.

Hi Andy,

Thomas Keller is absolutely right and explained it very well.

I chose SELECT COUNT(*) because that aggregate function will normally always return a row with a non-null value. That means...

SQL Server 2005 soes not have data encryption on the wire. Passwords are only weakly protected and I assume you would be using SqlServer authentication and therefore transmitting a password.

If...

Normally you would not use configuration files to store passwords.

Normally passwords should be embedded within the package and protected through SSIS's encryption mechanism.

You use the DTUTIL.exe with the /ENC and...

Frank,

Thanks very much. Both of these sound like workable solutions.

I think I will go with a Script task that tests for existence of the folder as you suggested. While in...

If you can establish a VPN to your ISP that would be ideal. It is secure.

You could use transactional or scheduled snapshot replication or SSIS.

I have used replication over a...

Since no one else has answered I will have a go.

First configurations are only applied when a package is first loaded (befofe validation) so use of a configuration would...

If you are running a query that crosses partition boundaries, there is a small performance overhead, compared to the same query against a non-partitioned table.

As I understand it the main...

Regexp Expressions

Compression of Blobs

Concatenate() aggregate function

All the above have proved useful.

**** The 8K limit is an urban myth!!! ****

see the following for a sample:

http://www.codeproject.com/KB/database/blob_compress.aspx

Hi Brian,

Great article. When I read it, it reminded me of something I have never understood about windows logins.

Say I have active directory with user "U" who belongs to 2...

I agree with most posters here.

The recommended solution should be to use integrated security and do not encrypt the command line.

The encrypted command line means the "good guys" cannot tell...

I have successfully used RS to do a couple of unusual things:

a) Kick of an SSIS pckage via a job each time a report is run. The stored procedure loop/sleeps...

Steve,

I agree with most of these people. The ads enable you to run this excellent site without charging us membership fees, so keep on advertising. The page peel ones are...

Thanks vik. I will speak to the network guys about a backup domain controller.

Regarding the 2005 machines - they may not have been running jobs at the time.