November 6, 2009 at 7:40 am
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.
November 6, 2009 at 8:14 am
Tara-1044200 (11/6/2009)
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.
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.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
November 6, 2009 at 8:15 am
Do you have rights to create a new database?
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
November 9, 2009 at 1:13 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply