Upgrade SSMS a couple of times a year?

You should be upgrading every time one is available. Why wouldn't you?

Interesting, but what's wrong with SERVERPROPERTY('ProductVersion')?

I really wanted to love this when it was still called Operations Studio. Unfortunately, using it is nothing like Management Studio or even Visual Studio and I haven't found any compelling...

The inability to access package variables renders Package Parts pretty useless, actually.

Boris, try this: http://converter.telerik.com/

Why are you still running Windows XP?

Interesting as an academic excercise, but as chudman pointed out, the MAP Toolkit does all this and a huge amount more.

Run it as a DA and then generate the reports....

Any DBA regularly shrinking a data file should be, um, "reassigned."

I guess I spoke too soon; it isn't working as desired right now.

If I copy the file "manually" to the drop folder it will work every time. When the file...

Here is the code I'm using.

using System;

using System.IO;

using System.Threading;

namespace HEC

{

[System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]

public partial class ScriptMain...

I have all the .NET frameworks installed, but I only use 2.0 in SSIS 2008.

I am monitoring a folder for excel files. The folder being monitored is a share on...

If you are having difficulty getting this to work consistently, try adding the following to WatchForFileCreation:

// enable the watcher

fileSystemWatcher.EnableRaisingEvents = true;

just prior to the WaitForChanged call. In the .NET 2.0...

Perhaps so, but I want to do this in an SSIS expression, not SQL.

And which method, specifically? I didn't read the entire thread. Are you talking about the CLR option?...

Actually Rob, you will see stuff like that in HL7 data all the time.

I've used the vertical tab for billions of rows over the years; it has never failed.