Not sure what you mean.  My question wasn't about running the package, but rather about getting a Sql dump when I try to use dtutil to regen the package ID. ...

Thanks Carl,

The problem is I don't want all the Sql authenticated users or windows users, I only want roles in this case.  Your answer helped me figure out the real...

Yes .NET framework 2 is installed. MDAC is 2.7.  I'd still like to know about services to stop, settings and any other gothca's. I've read that VS2005 can interfere with...

Thanks Thomas. 

=CountDistinct(Fields!Name.Value) works like a champ.

"A foul mouth proceeds from the rotting stench of a decaying heart."

That one's for free from my pastor's sermon last week.

I went to order the DVD and at the top of the page it states:

Free shipping and handling on U.S. and Canadian orders, while supplies last.

Then when I complete...

To your knowledge Noel, will DTS run ok on 64-bit architecture runnning 32-bit OS and 32-bit Sql Server?  According to AJ there won't be any impact.

Hi James,

I don't think you're wrong regarding:

"Am I wrong, or does Windows 2003 and SQL Server 64-bit exist now for AMD?"

Our problem is still the 3rd party apps we have that...

Thanks AJ.  That's what I needed to know.

The Ops Manager, who has the attention of the boss at budget time, does the ordering.  He and I don't always seee eye-to-eye on Server specs.  I tell him what...

Try the new Search from the menu.  Be sure to enter your keywords under 'Search Forums' .  For example try the keyword 'sp_MSforeachdb'.  Then hit the Search button with the...

This same thing happened with my packages that had been running fine with no problems for well over a year.  The only work around I found was don't open up...

I'm gonna guess that if the search improved on forum text, you'd get a lot less repeats on subjects already covered and thus reduce some bulk. I'm rootin' for...

The cure for the error was to put WAITFOR DELAY '00:00:05' right before backing up the log. Antares686 may have been right... I suspect the differential backup still had...

noeld,

Ooohhhh!!! Aaahhhh!!! This is waaaay cool!

I'd just about given up on sp_MSforeachdb and was working on the cursor when I got your solution. Now I'm gonna add...