It's most probably you try to create your job from your machine, on typical developer machine you have your VS2K5 and query Analyzer but do not have the smo clr...

Hi Scott, great articles for the SSIS configuration.

I was testing your code on my machine and found out that:

When I try to add a new variable in the package and...

I saw the range table creation script and think that we can create it with another twist by utilizing Izik-Ben-Gan "Sequential Number table function" without using loop.

Result expected

RangeStart RangeEnd

AA AB

AB...

I have a similar problem on Vista that show MMC "Snap-in failed to initialize" when I click , if you just click on 'Perfomance Monitor' under 'Monitoring Tools' in "Reliability...

You can use only C# compiler to build the SQL CLR dll and you do not need VS or VS Express edition. But the tools make develop the project easier...

Run your cmd with /!X /!C

DTSRun /~Z0xFCE4267FFC0BB... /!X /!C

This will put the decrypted cmd string...

I've this error on one of my full db backup job. Indeed the error msg didn't help much but I found it in ntevent viewer that my harddisk is full....

My 2 cents.

Recently I was asked this similar situation for one db server connect to another db server using link server and to have just enough permission to select from...

I think this question's answer is

c. An error occurs because the first restore statement is incorrect.

or it can be

a. You are able to restore only the full and...