Error in SSIS pkg

SQLServerCentral is supported by Red Gate Software Ltd.

Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Error in SSIS pkg

Error in SSIS pkg

Rate Topic

Display Mode

Topic Options

Author

Message

Tara-1044200

Posted Friday, November 06, 2009 7:40 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 1:05 PM
Points: 443, Visits: 1,237

SSIS package "Export EmpplyeeData.dtsx" starting.
Error: 0xC002F325 at Export Data to OBbeaver, Transfer SQL Server Objects Task: Execution failed with the following error: "Property DefaultSchema is not available for Database '[EmpplyeeTest]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. ".
Task failed: Export Data to OBbeaver
SSIS package "Export EmpplyeeData.dtsx" finished: Success

I am getting the above error when trying to export table with data using ssis pkgs. I want to create a database and export all tables and data into it from the source db and my account has read/write and ddl_admin previlages.

Post #814926

Silverfox

Posted Friday, November 06, 2009 8:14 AM

SSCrazy

Group: General Forum Members
Last Login: Friday, November 27, 2009 5:32 AM
Points: 2,683, Visits: 1,003

Tara-1044200 (11/6/2009)

Not sure I understand the problem, why dont you just use the copy database wizard, that will create a SSIS package to do it. or depending on the size of the database. just generate the scripts, including data.

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw

Post #814949

Silverfox

Posted Friday, November 06, 2009 8:15 AM

SSCrazy

Group: General Forum Members
Last Login: Friday, November 27, 2009 5:32 AM
Points: 2,683, Visits: 1,003

Do you have rights to create a new database?

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw

Post #814951

Tara-1044200

Posted Monday, November 09, 2009 1:13 PM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 1:05 PM
Points: 443, Visits: 1,237

Yes, user has create database permissions along with Read/Write/ddl_admin.

Here is the thing...
User with above previlages to trying to move a database from one server to another server and getting that error.

He is trying to achive this by using Transfer SQL Server Objects Task

Post #816087

« Prev Topic | Next Topic »

Permissions