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.

fail component error notification

I have created a package which forms data from flat file to sql database.I have a data flow where all my data is processed to destination.if the package fails by any chance i want an email notification with the cause of the error.how can i do this.please let me know..I'd start with Send Mail task and the OnError event handler for the package.|||Will i be able to send mail with the list of errors occured if the do the above|||Can you specify your goal in more detail? Do you want one email with all errors listed? Do you want all errors, or just the primary error that caused the package to fail?|||I want all the errors in one email.|||

This post might help:

http://agilebi.com/cs/blogs/jwelch/archive/2007/05/05/handling-multiple-errors-in-ssis.aspx

I created an example that uses a Script task in the OnError event to collect all the errors, and then uses a second Script task in the OnPostExecute event to process them. You could simply add a Send Mail task to the OnPostExecute to send the email.