That department head should be persuaded that his career would benefit from an ITIL qualification or two! At least Foundation but achieving the full Managing across the Lifecycle would keep...

Are you sure your account has the correct ssisadmin permissions on msdb on that server?

What that messy text speak above means is that you need to delete the line that sets a guid value for the schedule id and probably the comma on the...

We've rolled out our own VB.Net web app over the in-house intranet using a tree view control, the report server database, role-based security and launching reports in their own window...

Itzik Ben-Gan teaches

WHILE 1=1

BEGIN

DELETE TOP (5000) FROM table WHERE .....

IF @@ROWCOUNT < 5000 BREAK

END

and you can add a WAITFOR to delay between iterations

Adjust the 5000 to suit your table.

I'd already decided I wanted to work with computers because older cousins did and I liked what they described, but the first software I remember was on a three day...

Back in the early 1980's in the UK our DEC PDP11's had 32K of memory and you had to write your own memory management system to swap in and out...

Mine stopped working and I found that the exchange server had been changed without my knowing!

I had to rapidly edit a bunch of servers' database mail settings.

In the SQL Agent...

Try bringing in the decimal field as varchar(50) and then using a derived column transformation to convert it rather than doing everything in the flat file connection manager. You should...

We have a staff small ads system and so the favourite trick on the shop floor is to place a nonsense advert using the unlocked workstation such as Wanted -...

For us and probably many others 2013 will be the year of virtualisation, replacing existing physical servers with virtual servers that much smaller server teams can maintain.

And the usual...

It's worth using a variable to hold the path for the flat file connection and then using Expressions in the flat file connection manager properties to set the connection string...

If you are running the SSIS packages from SQL Agent, just tick the 32 bit runtime box on the Execution Options tab

I had this problem with an Access DB import...

Now to tweak the script to get rid of all those pesky 10% file growth db files:-D

I've found that sometimes as well as declaring Imports system.IO (or whichever I need), I have to actually add a reference to it. Open up the script in the editor...