Failed to open a fastload rowset

Hi.

In OLEDB Destination, AccessMode as OpenRowset Using FastLoad raises the following error:

"Failed to open a fastload rowset db_object. Check that the object exists in the database"

db_object exists in the database. Is there any key point for the table or view used for fastload?

Thanks

How did you set db_object to the OLE DB Destination component? Did you choose it from the drop-down list or typed it in the property grid? Does it have the schema part which is not included?

Thanks.

|||

Yes, I select the db_object from drop down list and also schema part is included.

Thanks

|||

Could you copy the entire error message here? Do you see that message at the design time or when you run the package?

Thanks.

|||

Following is the error raised at design time:

TITLE: Package Validation Error

Package Validation Error

ADDITIONAL INFORMATION:

Error at Model [OLE DB Destination [49]]: An OLE DB error has occurred. Error code: 0x80040E21.

Error at Model [OLE DB Destination [49]]: Failed to open a fastload rowset for ""PRATI"."CONFIG_MODEL"". Check that the object exists in the database.

Error at Model [DTS.Pipeline]: "component "OLE DB Destination" (49)" failed validation and returned validation status "VS_ISBROKEN".

Error at Model [DTS.Pipeline]: One or more component failed validation.

Error at Model: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

BUTTONS:

OK

|||

Are you connecting to the SQL Server database? The fast load interface can be used only for SQL Server.

Thanks.