Software troubleshooting, cookbooks and HOWTOs

ORA-27069 and ORA-01114

2009-10-27T14:06:00.003Z

When creating a new object on a database (e.g. an index, a table) you get a set of ORA-27069 errors, each of them accompanied by ORA-01114. The description for these errors is:

ORA-27069 skgfdisp: attempt to do I/O beyond the range of the file
Cause: This is an internal error. The range of blocks being read or written is
outside the range of the file, additional information indicates the starting block
number, number of blocks in I/O, and the last valid block in the file.
Action: Check for a trace file and contact Oracle Support Services.

ORA-01114: IO error writing block to file string (block # string)
Cause: The device on which the file resides is probably offline. If the file is a temporary file, then it is also possible that the device has run out of space. This could happen because disk space of temporary files is not necessarily allocated at file creation time.
Action: Restore access to the device or remove unnecessary files to free up space.

How to work it out:

This can happen for a multitude or reasons: damaged storage, lack of storage space, etc. On Windows, namely Windows Server 2003 running a 32-bit file system, this can happen when one of the files in your tablespace reaches or crosses 4GB, 8GB, 12GB etc, so this may be the first thing to check.

You can use Oracle Enterprise Manager to check this: http://download.oracle.com/docs/html/B14399_01/rev_precon_db.htm#CACDJBBF

If, in fact, the problem is related to having a file with the characteristics above, you have plenty of options. For example, if you have an 8GB file in the USERS tablespace, you may have trouble adding data to that tablespace (which is the default for user tables, indexes, etc). To solve it, you can:
- set the file's maximum size below the size limit that started causing problems (e.g. 8GB)
- add more files to the tablespace where that file resides, so the tablespace can grow without creating very large files
- move indexes to a specific table space (ALTER INDEX REBUILD TABLESPACE ;)
- furthermore, you can create specific tablespaces for specific objects and move them there, which is way better than having every single object cramping up your default tablespace

All in all, the best way to solve this problem is to correctly manage your storage, tablespaces and files. Oracle ASM can help you with this. If you're running older versions, start here: http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/physical.htm

Format large HDD as FAT32 for your PS3 or DVD

2009-06-18T22:44:00.007+01:00

Do you have a PS3 or DVD/Bluray player on which you'd like to use your external USB HDD, but it's capacity (160GB, 250GB, 320GB, 500GB, 1TB, whatever) results in the drive being formatted in NTFS, and therefore your console or disc player can't read it?

You have to format it in FAT32 so your Playstation or DVD can read it, but as you probably noticed already, you can't do this in Windows XP: http://support.microsoft.com/kb/314463

But you can simply grab a free utility, like EASEUS Partition Manager, format the external USB HDD to FAT32 and you're good to go! :)

Copy SQL Server database tables

2009-05-08T17:32:00.003+01:00

Ever needed to copy an SQL Server database, but get only its data and leave out everything else?
Here's a T-SQL script that you can use to copy all the database's tables' data, and leave out everything else (indexes, partitions, programmability components, etc...)
The script will go through all tables in the 'dbo' schema of the source database (named 'sourceDatabase' in this example), create a copy of the table in the 'dbo' schema of the destination database (named 'targetDatabase') and insert all data from the source table in the destination table (by using a SELECT INTO).

Here's the code:

DECLARE @tableName varchar(300)
DECLARE @sqlStmt nvarchar(300)

DECLARE curTables CURSOR LOCAL FOR
SELECT table_name FROM sourceDatabase.INFORMATION_SCHEMA.tables

OPEN curTables

FETCH NEXT FROM curTables INTO @tableName
WHILE @@FETCH_STATUS = 0
BEGIN
SET @sqlStmt = 'SELECT * INTO targetDatabase.dbo.' + @tableName + ' FROM sourceDatabase.dbo.' + @tableName
EXEC sp_executesql @sqlStmt

FETCH NEXT FROM curTables INTO @tableName
END

CLOSE curTables
DEALLOCATE curTables

Hyperlink on Oracle Answers or Interactive Dashboard values

2008-08-14T15:33:00.007+01:00

This is both an example on how to add custom hyperlinks to Oracle BI dashboards' values and on the importance that context information from the Web has for BI systems.

So let's get to it: create a new Answers request and include the columns you desire. Go to the Criteria tab and, for the column on which you want to create the hyperlink, click on the "Column Properties" button. Click the "Data Format", enable "Override Default Data Format" and on "Treat Text As" choose "Custom Text Format".

On the text box below, you'll have to enter the expression to create the link - the syntax isn't quite well documented, although this is where you usually insert ActionLinks to interact with Siebel. To create a standard hyperlink, the syntax is:

@[html]"<a href=\"http://codingassistance.blogspot.com \">"@"</a>"

Trying it out, it's easy to determine that the "@" (quotation marks are required) stands for the row value, so this hyperlink will be something like <a href="website.com">RowValue</a>.

If you want to kick it up a notch, you can pass the row value itself as an argument for the URL; for example, the expression

@[html]"<a href=\"http://maps.google.com?q="@"\" \" target="_blank">"@"</a>"

passes the row value to (the q parameter of) maps.google.com and opens a new window pointing to the map of the row value. On a dashboard, the row values are hyperlinks to, for example, "http://maps.google.com/?q=SANTA%20CRUZ%20DAS%20FLORES" where "SANTA%20CRUZ%20DAS%20FLORES" is one of the row values. In this particular case, the row value is a geographical location, hence the choice of Google Maps.

We can embelish it a bit by adding a title to the anchor, like this:

@[html]"<a href=\"http://maps.google.com?q="@"\" \" target="_blank" title=\"Click to view this location on a map\">"@"</a>"

(don't forget to escape your quotation marks!)

So, bringing it all together, we'll have a dashboard like this:

After clicking, a new window opens with a map for the location:

Describe a table in SQL Server 2005

2008-07-31T15:17:00.004+01:00

Here's a quick snippet of SQL that allows you to describe a table in a SQL Server 2005 database, similar to the DESC or DESCRIBE command in Oracle and MySQL:

SELECT column_name, data_type,column_default, is_nullable, character_maximum_lenght, numeric_precision, datetime_precision
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name='MyTableName'

Detailed info on INFORMATION_SCHEMA: http://msdn.microsoft.com/en-us/library/ms186778.aspx

Error 26 connecting to SQL Server 2005

2008-05-14T22:05:00.005+01:00

While connecting to a remote SQL Server 2005 instance, you get an error like this:

SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

If you are sure that there are no firewalls blocking connections between the two machines, and that the server is configured to accept remote TCP connections, then the likely solution is to start the SQL Server Browser service on the remote machine.

More information:
SQL Server Browser service: http://msdn.microsoft.com/en-us/library/ms181087.aspx
Configure remote connections on SQL Server 2005: http://support.microsoft.com/kb/914277

Oracle BI default password

2008-04-24T11:07:00.002+01:00

If you are having trouble (rejected password) logging in to Oracle Answers or Oracle BI Publisher, be aware that both have a default password that differs from the password you were asked upon installation of the Oracle BI suite. The default account credentials for these services are:
Username: Administrator
Password: Administrator

(remember that the password is case sensitive)

How to create folders programatically in Business Objects XI repository

2008-02-19T11:14:00.008Z

This is an example of how to create folders in the Business Objects XI InfoStore using VB6 and the COM API. This code creates a folder called "MyNewFolder" beneath "TestFolder", which is created at the folder root.

Dim sessionMgr, entSession, infoStore, pluginMgr, folderPlugin

'create a session and connect to the InfoStore
Set sessionMgr = CreateObject("CrystalEnterprise.SessionMgr")
Set entSession = sessionMgr.Logon("Administrator", "myPassword", "myBoServer", "secEnterprise")
Set infoStore = entSession.Service("", "InfoStore")
Set pluginMgr = infoStore.PluginManager
Set folderPlugin = pluginMgr.PluginInfo("Folder")

Dim infoObjectCollection, newFolder

Set infoObjectCollection = infoStore.NewInfoObjectCollection()
Set newFolder = infoObjectCollection.Add(folderPlugin)

newFolder.Title = "MyNewFolder"
newFolder.Description = "This is the folder we're creating in the example"

Dim infoObjectCollectionAux 'used to help determine the parent folder id
Dim queryStr As String
Dim queryStr1 As String
Dim queryStr2 As String

'build a query to get the parent folder id
'you can test this using the Query Builder in the Admin Launchpad
queryStr1 = "SELECT * FROM CI_INFOOBJECTS WHERE SI_NAME='"
queryStr2 = "' AND SI_KIND='Folder' AND SI_PARENTID=0" 'the root folder has id=0
queryStr = queryStr1 & "TestFolder" & queryStr2

'execute the query and get the parent folder id
'if "TestFolder" doesn't exist in the root, the infoObjectCollectionAux will be empty
Set infoObjectCollectionAux = infoStore.Query(queryStr)
Dim parentFolderId As Long
'only get the first item, for example simplicity sake
parentFolderId = infoObjectCollectionAux.Item(1).Id

'set the new folder's parent id and commit the changes
newFolder.ParentID = parentFolderId
infoStore.Commit (infoObjectCollection)

WIS 00504 error on Business Objects XI

2008-01-14T17:45:00.001Z

If you get a WIS 00504 error message when trying to perform an action that requires access to a Universe (e.g. new WebI or DeskI report), this probably means that you don't have enough security privileges to acess the Universe's data. You need to have "View on Demand" rights over the Universe and "View on Demand" rights over the corresponding Universe Connection.

SSIS Script Component throws "Object reference not set to an instance of an object"

2008-01-02T11:38:00.000Z

In Integration Services 2005, if you get an Object reference not set to an instance of an object exception when trying to manipulate rows from a Script Component, even after you have guaranteed that the column is set as an input for the script, try checking if the column you're accessing is not null, using the automatically available "_IsNull" property. For example, if the input column is called myInputCol, you can try something like this:

If Not Row.myInputCol_IsNull Then
'code that access the column here
End If

How to reset SQL Server identity column

2007-12-27T16:04:00.001Z

Generally, to reset an identity column to value n on table XYZ:
DBCC CHECKIDENT('XYZ',RESEED,n)

So, to reset an identity column to value 17 on table XYZ:
DBCC CHECKIDENT('XYZ',RESEED,17)

The page cannot be found in Infoview

2007-11-21T18:06:00.000Z

In Business Objects XI, you may get an error saying The page cannot be found when trying to access InfoView or the Central Management Console. One cause for this problem is that, on Windows Server 2003, IIS 6.0 blocks .NET 2.o .aspx applications by default. To enable them, go to Administrative Tools -> Internet Information Services (IIS) Manager, click the Web Service Extensions, select ASP .NET v2.0xxxx and click Allow.

Detailed info on this operation:
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/596ff388-bc4c-472f-b029-aea2b0418bea.mspx?mfr=true

[repo_proxy 13] SessionFacade::openSessionLogon with user info has failed

2007-11-21T18:03:00.001Z

When trying to log on to InfoView on BusinessObjects XI, you may get this error because the CMS can't be contacted. This may be happen because of a firewall or traffic filtering on your network. The first reason is reasonably easy to solve: make sure there is no firewall blocking you in the path from the client to the BO server. If you suspect it's the latter, try putting localhost on the System textbox.

Access and consume a Web Service from Integration Services

2007-11-01T15:34:00.000Z

Sometimes you need to consume a Web Service that is specific enough for you not be able to use the default Web Service Task available on SSIS 2005.

In this example I'm going to show how to consume a Web Service that returns a .NET object (a serialized DataSet, for example). For this, we'll have to use a Script Component that allows us to insert some custom code that is able to do what we need. The Script Component will be part of a Data Flow acting as a Source that provides rows to Transformations down the pipeline.

Acessing a Web Service from a Script Component is pretty much similar to how we'd do it in a standard .NET application:

You need a proxy class (in the VB language) for the Web Service you want to consume. You can create it using the wsdl.exe application like this:
wsdl /language:VB http://yourserver/yourWebService?WSDL /out:yourProxyClass.vb
Access the Script Component's code and, on the code window, go to the Project menu and select "Add Existing Item". The item you have to add is the proxy class you created previously (yourProxyClass.vb, in this example). Next, go to the Project menu, select "Add Reference" and add the System.Xml and System.Web.Services assemblies.
Now you have to write the code to acess the Web Service and output its results onto the outputs you defined for the Script Component.
In this example, the Web Service defines a class called Export which has a method called getDataSet(String) that outputs is a serialized DataSet. The Script Component has one output, called Output0, with two columns (colOne and colTwo) defined as a String (DT_STR)

Public Class ScriptMain
Inherits UserComponent

Dim webServiceExport As Export
Dim dsResults As DataSet

'Prepare the required connections and initialize objects
Public Overrides Sub AcquireConnections(ByVal Transaction As Object)
MyBase.AcquireConnections(Transaction)

webServiceExport = New Export()
dsResults = Nothing

End Sub

'Get the data from the WebService
Public Overrides Sub PreExecute()
MyBase.PreExecute()

webServiceExport.Timeout = 3600
dsResults = webServiceExport.getDataSet("test parameter string")

End Sub

'Go through the received data and add it to the output rows
Public Overrides Sub CreateNewOutputRows()

Dim dtResults As New DataTable

dtResults = dsResults.Tables(0)

Output0Buffer.colOne = dtResults.Columns(0).ToString()
Output0Buffer.colTwo = dtResults.Columns(1).ToString()

Output0Buffer.AddRow()

End Sub

End Class

If you need some Web Services for testing you can search at http://www.webservicex.net/WS/default.aspx

Detailed information links:
Wsdl.exe: http://msdn2.microsoft.com/en-us/library/7h3ystb6(VS.80).aspx
Referencing Assemblies in a script: http://msdn2.microsoft.com/en-us/library/ms136007.aspx
Using the Script Component as a source: http://msdn2.microsoft.com/en-us/library/ms136060.aspx

Convert Access' Memo to a VARCHAR string

2007-10-25T11:47:00.000+01:00

The problem: the Memo data type in Access is a Unicode text stream (i.e. no fixed width) and the VARCHAR type is a non Unicode text string (fixed width). So, if you're transferring data from a Memo column on an Access file to a database column of the VARCHAR(n) type, you'll have to use a Data Conversion transformation to convert the Memo to String (DT_STR, which maps to VARCHAR) and when you do, Integration Services will throw the following error

Conversion from DT_NTEXT to DT_STR is not supported

This means that you cannot directly convert a Unicode stream to a non Unicode string.
What you can do in this situation is create a Data Conversion that converts the Memo column to DT_TEXT (non Unicode stream) and after that use another Data Conversion to convert that same column from DT_TEXT to DT_STR. Keep in mind that truncation may occur if the conversion to DT_STR doesn't reserve enough width on the column to fit the whole stream contents (i.e. if the stream has at most 500 characters you'll need to set up the Length of the column to 500 in the Data Conversion transformation)
Another option could be using a Derived Column to perform both casts in a single transformation (haven't tried this solution).

Custom logging with Integration Services

2007-10-24T11:11:00.000+01:00

Integration Services 2005 allows you to insert custom log entries from a Script Task by sending events of a specific type to your log provider. You can use something like this from within a script:

Dts.Events.FireInformation(0, "CustomInfoHere", "This is a custom log entry thrown by a script task")

You can also use this technique to raise errors, warnings, progress information, etc...

If you need help on how to set up logging for a package see this: http://msdn2.microsoft.com/en-us/library/ms141727.aspx

Freeware encryption and compression

2007-10-22T21:09:00.000+01:00

FreeSecurity is an easy to use freeware application that allows you to use AES encryption to secure your files and safeguard your privacy, also allowing file compression. It's developed in Java and requires only that your operating system has Java 1.4 or above installed, therefore being able to run in any operating system which provides the mentioned Java support.
I developed it in 2005 and released it as a freeware application, you can get it here: http://www.canudo.net/derelict/freesecurity/

Convert MPC to MP3 and MPC to WAV

2007-10-22T21:06:00.000+01:00

FreeMPC is a freeware, graphical and easy to use application for listening and converting MPC audio files. It can convert MPC to WAV and to MP3 (all bitrates) and you can also use it to play MPC files without having to convert them.
I developed it in 2006 and released it as a freeware application, you can get it here: http://www.canudo.net/derelict/freempc

Execute SQL Task (SSIS) with parameters

2007-10-22T14:08:00.000+01:00

On Integration Services 2005, when using a query with parameters in the Execute SQL Task, mind that in the Parameter Name field the counting starts at 0 (if, at least, the connection type is OLE DB). Therefore, if you are using multiple parameters the first Parameter Name must be 0, the second must be 1, and so on.
Otherwise, you'll get this error:
[Execute SQL Task] Error: Executing the query "DELETE FROM myTable WHERE key = ?" failed with the following error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Check here for more information: http://msdn2.microsoft.com/en-us/library/ms187685.aspx

Lots of 401.x errors on the IIS log

2007-10-16T21:31:00.000+01:00

Substatus=2 and win32-status=2148074254 along with Substatus=1 and win32-status=0 means the packet exchange corresponds to normal NTLM authentication (Windows Integrated Authentication). If there are a lot of these, there is probably some configuration causing connections to close too soon.

Excel says 'user does not have permissions to run DBCC Traceon'

2007-10-16T21:28:00.000+01:00

This is due to an incompatibility between Excel 2000 and SQL Server 2005. As a workaround, try this: press the Options button and replace the text on the "Application Name" textbox on the "SQL Server Login" panel with a single white space

Insert a newline in a Reporting Services' textbox

2007-10-16T20:47:00.000+01:00

Use an Expression such as this one:
="Some text" & chr(10) & "more text, but on the next line"

Changing system culture programatically in C# .NET

2007-10-16T20:45:00.001+01:00

This is useful when handling dates in US or other format in C# .NET:

Thread.CurrentThread.CurrentCulture = New CultureInfo("en-US", False)
Row.date = MonthName(Row.datahorainicio.Month(), True) & " " & Row.datahorainicio.Day() & " " & Row.datahorainicio.Year()

'reset the culture to the system's default
Thread.CurrentThread.CurrentCulture = New CultureInfo("pt-PT", False)

Get the datetime representing the first day of a date

2007-10-16T20:44:00.000+01:00

This is pretty useful when you need to get data from the past n months:

SELECT CAST(((convert(varchar(7),getdate(),121))+'-01') AS datetime)

Get the date portion of a datetime

2007-10-16T20:42:00.000+01:00

SELECT CONVERT(varchar(11), myDate, 102)
You can then use REPLACE() to substitute the . with -

Clear Visual Studio 2005 Recent Projects list

2007-10-16T20:40:00.002+01:00

Visual Studio's MRU list is located in the Registry under:
HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\8.0\ProjectMRUList

If you need help on editing the Registry see this article

FindControl on a MasterPage

2007-10-16T20:40:00.001+01:00

When you need to use FindControl() on the Controls placed on a page inside a MasterPages layout, first you have to retrieve the ContentPlaceHolder that holds the page’s elements ( Master.FindControl(“myContentPlaceHolder”) ) and use FindControl on the ContentPlaceHolder.

A quick intro to MasterPages

2007-10-16T20:38:00.000+01:00

MasterPages are a new feature of ASP .NET 2.0 and simplify the creation of a site-wide template with editable regions. In some applications I developed, the layout was previously created and styled using CSS; then, a MasterPage was created to centralize the site-wide page layout and make it easier to create a consistent and updateable look and feel across all pages, as they will appear within a ContentPlaceHolder defined on the MasterPage. Therefore, for the overall design to be applied to all other pages on the Presentation Layer it suffices to select their Master Page.

IIS Server Application Unavailable

2007-10-16T20:36:00.000+01:00

Ever got that error when running/debugging an ASP .NET application?
Try one of these methods:
- Check if ASP .NET 2.0 is correctly installed (aspnet_regiis -lv)
- See if the aspnet user has proper (read & execute) permissions over the application's directory - if he hasn't, the error won't be logged to the Event Log.
- See if the application pool for the virtual directory is correct (this problem produces a log entry identifiable in the Event Viewer)

Fixing orphan logins on SQL Server 2005

2007-10-16T20:32:00.000+01:00

Ever restored a backup that didn't include database logins, winding up with a lot of orphan logins? Here's a way out:

To set "targetUserNewLogin" as the new login for user "targetUser", run the following stored procedure (you can leave the first parameter unchanged):
sp_change_users_login 'update_one', 'targetUser','targetUserNewLogin'

If you need to get the list of users without logins:
SELECT * FROM sysusers
WHERE issqluser = 1 AND (sid IS NOT NULL AND sid <> 0x0)
AND suser_sname(sid) IS NULL

If you need to delete schema ownership:

SELECT s.* FROM sys.schemas AS s
INNER JOIN sys.database_principals AS dp ON dp.principal_id = s.principal_id
WHERE dp.[name] = 'someUser';

SELECT s.[name] as schemaname, o.[name] AS objectname, o.type_desc
FROM sys.objects AS o
INNER JOIN sys.schemas AS s ON s.schema_id = o.schema_id
INNER JOIN sys.database_principals AS dp ON dp.principal_id =s.principal_id
WHERE dp.[name] = 'someUser'
ORDER BY s.[name], o.type_desc, o.[name];

DROP SCHEMA someUser;

Can’t enable Design or Edit mode for a WebPart

2007-10-16T20:31:00.001+01:00

If you can’t enable Design or Edit mode for a WebPart, check if IIS is allowing anonymous logons for the virtual directory. It shouldn't be, because the username needs to be stored in the aspnetdb database so personalization settings can se saved.

An intro to ASP .NET WebParts

2007-10-16T20:30:00.001+01:00

WebParts are part of the Presentation Layer and empower users with the capability of customizing the contents of the Web page being visualized. A WebPart is a control whose positioning, content and design can be customized effortlessly by the user, creating a richer and easier interaction. A WebPart can be in one of five modes: Browse, for standard navigation; Design, which allows users to minimize and drag WebParts between zones; Edit, on which an EditorZone control is displayed allowing the user to add WebParts properties at runtime; Catalog, on which a CatalogZone control is displayed so that the user can use it to add new Web Parts to the page while navigating; and Connect (not explored yet). The Sentry Customer Interface has its WebParts in Design mode, allowing only their minimization and customization of their position.
WebParts use a WebPartZone as a container and can be moved within their container (to change their position) and between other WebPartZones that exist on the Web page. Almost all controls can be displayed from within a WebPart, using the GenericWebPart control as a wrapper.
The WebPart framework requires a database, local or located on a server, to enable persistence of the customization options. This database is tipically "aspnetdb" and can be created by running the "aspnet_regsql" command. The customization settings are kept in a per-user basis (with the current logged on user by default).

Backing up specific SharePoint web sites

2007-10-16T20:28:00.000+01:00

With Microsoft Windows SharePoint Services, you can back up and restore site collections hosted on your server. You can use this backup and restore method to replace a site collection that has become corrupted, or that contains changes that need to be rolled back (for example, if you need to recover a list or a list item that was deleted accidentally). This backup and restore method is not dependent on the type of database server that you are using.
When you back up a site collection, you back up the content database for the site collection, including all pages in the site, files in document libraries or lists, security and permission settings, and feature settings. The backup process creates a single file that contains all of this data. You can then restore your site collection to either the same location, or to a new location. The backup file for a site includes any subsites of the site collection.

To backup/restore a site, you use the backup/restore operation with the Stsadm.exe command-line tool. Therefore, you can automate the backup process by using a batch file, a script, or the Scheduled Tasks item on Microsoft Windows Control Panel.

Example of backup: stsadm -o backup -urlhttp://server/site -filename backupFile.dat -overwrite
Example of restore: stsadm -o restore -urlhttp://server/site -filename backupFile.dat

Example of restore: stsadm -o restore

Grayscale an image programatically

2007-10-16T20:23:00.000+01:00

This code allows you to dinamically apply a grayscale filter to an image contained in a div:

You have to either set the div and img height and width or set its position to absolute, or the effect won't work.
This seems not to work in ASP .NET pages, although it works perfectly on plain HTML.

There are more filters that you can use like the above, here's a list: http://msdn2.microsoft.com/en-us/library/ms532853.aspx

Secured connection unavailable while editing a Universe

2007-10-15T16:51:00.000+01:00

When using Business Objects Designer to create a Universe you can only export it to the CMS database if it has a Secured connection. If you're trying to change the connection type and the "Secured" option isn't available, it may be a matter of user rights: you need permissions to create a Universe in order to change the connection type.

Multiple-step OLE DB operation generated errors

2007-10-15T16:29:00.000+01:00

When running an Execute SQL Task on SSIS 2005 you get the following error:

Error: Executing the query "your SQL code here" failed with the following error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

The last time I ran into this error it turned out that I had (yes, it was copy/paste ;D) some comments in the middle of the T-SQL code - deleting the comments got it working, hope this method helps you.