Issue time06:55:00 am, by Tom Green Email 4632 views
Categories: SSIS, Errors
Problem When executing an SSIS package, the following error appears: 0x80040E55 Column does not exists   Solution I encountered this error when running a SSIS package that executes a stored procedure, inside an OLE DB Source component, on several… more »

Leave a comment
Issue time09:25:00 am, by Tom Green Email 2347 views
Categories: SQL Server, Errors, Server Configuration
Problem When trying to install or uninstall SQL Server services, the setup process fails with the following message: Rule "Restart Computer" failed. A computer restart is required. You must restart this computer before installing SQL Server. Thi… more »

Leave a comment
Issue time12:20:00 pm, by Tom Green Email 6844 views
Categories: SSAS, Errors
Problem  When trying to process a database cube the following error is received:  Internal error: An unexpected exception occured.   After the restart of the SSAS service the event view shows the following error: The file '\\?\X:\...\Data\master.vm… more »

Leave a comment
Issue time12:34:00 pm, by Tom Green Email 4084 views
Categories: SSAS, Errors
Problem When trying to call DiscoverSessions function from the ASSP procedure the following error can appear. CALL ASSP.DiscoverSessions() Execution of the managed stored procedure DiscoverSessions failed with the following error: Exception has b… more »

Leave a comment
Issue time05:51:00 pm, by Tom Green Email 4710 views
Categories: Server Configuration
Create MSDB directory for storing SSIS packages from multiple instances (located in the msdb database of each of the instance):   Go to C:\Program Files\Microsoft SQL Server\100\DTS\Binn\ folder (SQL Server 2008) and edit the MsDtsSrvr.ini.xml file… more »

Leave a comment
September 2023
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
          1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30


Email Subscription

Enter your email address:

Delivered by FeedBurner



XML Feeds

DBA Blog

Latest posts

SSAS More...
SSRS More...
Server Configuration More...
Server Configuration More...
Errors More...
SQL Server More...
SSIS More...


Which database platform do you use?

View Results

Powered by b2evolution