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.

Failed To Get Schema Name

I am getting a "Failed To Get Schema Name" error when I attempt to add a
view to a database on a remote server. I can add a View to a db on my
localhost server without any problems.

I am working with a report using SQL Reporting Services 2005 in VS.Net 2005

If I open the DB in SQL Management Studio, I can add a view without any
problems. What would be causing this error and how can I fix?

TIA
Dean

How are you creating this view? What are the steps? You said you can create the view using Management Studio - what tool are you using when you can create the view?

You said you are working with a report...so is the error being generated from the report? What does the report do? Do other reports work correctly?

-Sue

|||

i think the problem is with your .net connectivity. What do u mean by Add a view.... is it that u can create view. please post the exact error with error desc and no.

Madhu

|||

In Visual Studio 2005, using Server Explorer, connect to sql server, select db, right click on View node in tree, select Add.

It does not appear to be a Report problem. I'm trying to create a view that can be reused in multiple reports

Dean

|||

Adding a View, means using the Server Explorer window to connect to a database, select the View node and click Add.

"Failed to get schema name" is what shows up in the message box. There is no error number listed