Error in Transfer SQL Server Object Task

Hi all,

I am facing problem while using Transfer SQL Server Object Task in SSIS, it is not importing table & its attributes.

The details settings of Transfer SQL Server Object Task as follows:
clicking edit - Objects(left pane)
Right pane
Connection
Source Connection existing server name 1
Source Database ganny1
Destination Connection existing server name 1
Destination Database ganny2
Destination copy objects
Objects to copy - copy all tables - true
Table Objects
CopyPrimaryKeys - True
CopyForiegnKeys - True

After setting all this configurations, Executing task, I am not able to get table in my destination database.
Please suggest me to solve the issue.

Thanks in advance
Karna

What is the value of CopySchema? If it's false, trying setting it to true.

error in rs

aspnet_wp!ui!980!20.9.2004-09:42:16:: e ERROR: An internal error occurred on
the report server. See the error log for more details. --> An internal error
occurred on the report server. See the error log for more details. --> Key
not valid for use in specified state.
aspnet_wp!ui!980!20.9.2004-09:42:17:: e ERROR: HTTP status code --> 200
--Details--
System.Web.Services.Protocols.SoapException: An internal error occurred on
the report server. See the error log for more details. --> An internal error
occurred on the report server. See the error log for more details. --> Key
not valid for use in specified state. at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
Message message, WebResponse response, Stream responseStream, Boolean
asyncCall) at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at
Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String
Item) at
Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String
Item) at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
at Microsoft.ReportingServices.UI.Permissions..ctor(String path) at
Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)
at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser() at
Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender, EventArgs
e) at System.EventHandler.Invoke(Object sender, EventArgs e) at
System.Web.UI.Control.OnInit(EventArgs e) at
System.Web.UI.Control.InitRecursive(Control namingContainer) at
System.Web.UI.Page.ProcessRequestMain()
aspnet_wp!ui!980!20.9.2004-09:42:17:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)Try deleting the following file:
\documents and settings\<machine name>\aspnet\application
data\microsoft\crypto\rsa\<user sid>\1aedd7b5699f3d6a88e354100b596aae_*
Then run rsactivate -r -c <config file>
--
This posting is provided "AS IS" with no warranties, and confers no rights
"TomislaW" <tomislav147@.hotmail.com> wrote in message
news:%23ldrknwnEHA.4088@.TK2MSFTNGP10.phx.gbl...
> aspnet_wp!ui!980!20.9.2004-09:42:16:: e ERROR: An internal error occurred
on
> the report server. See the error log for more details. --> An internal
error
> occurred on the report server. See the error log for more details. --> Key
> not valid for use in specified state.
> aspnet_wp!ui!980!20.9.2004-09:42:17:: e ERROR: HTTP status code --> 200
> --Details--
> System.Web.Services.Protocols.SoapException: An internal error occurred on
> the report server. See the error log for more details. --> An internal
error
> occurred on the report server. See the error log for more details. --> Key
> not valid for use in specified state. at
>
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClient
> Message message, WebResponse response, Stream responseStream, Boolean
> asyncCall) at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) at
>
Microsoft.SqlServer.ReportingServices.ReportingService.GetPermissions(String
> Item) at
> Microsoft.SqlServer.ReportingServices.RSConnection.GetPermissions(String
> Item) at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
> at Microsoft.ReportingServices.UI.Permissions..ctor(String path) at
> Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)
> at Microsoft.ReportingServices.UI.ReportingPage.get_RSUser() at
> Microsoft.ReportingServices.UI.FolderPage.Page_Init(Object sender,
EventArgs
> e) at System.EventHandler.Invoke(Object sender, EventArgs e) at
> System.Web.UI.Control.OnInit(EventArgs e) at
> System.Web.UI.Control.InitRecursive(Control namingContainer) at
> System.Web.UI.Page.ProcessRequestMain()
> aspnet_wp!ui!980!20.9.2004-09:42:17:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
>

Error in database mirroring

Hi,

when I tried to mirror database giving principal and mirror server names every details I am getting the error

'Database mirroring is disabled by default. Database mirroring is currently provided for evaluation purposes only and is not to be used in production environments.To enable database mirroring for evaluation purposes, use trace flag 1400 during startup.'

How to user trace flag 1400 during startup?

Since I am newbie Kindly guide me with step by step procedure.

thanks

Hi Shobha,

Database Mirroring is disabled by default in SQL Server 2005 and is enabled in SQL Server 2005 SP1. Therefore, I strongly encourage you to download and install SP1 by following the directions at https://www.microsoft.com/sql/sp1.mspx.

However, if you choose to continue using the RTM (Release to Manufacturer) version of SQL Server 2005 you can enable this feature by adding -T 1400 to the startup options. To do this follow the direction at http://msdn2.microsoft.com/en-us/library/ms190737.aspx. You will need to restart the service upon doing this; a reboot of your system should suffice.

Thanks,

Jaaved Mohammed

|||

Hi. I am using SP1 currently, but I still got the same problem

Error in database mirroring

Hi,

when I tried to mirror database giving principal and mirror server names every details I am getting the error

'Database mirroring is disabled by default. Database mirroring is currently provided for evaluation purposes only and is not to be used in production environments.To enable database mirroring for evaluation purposes, use trace flag 1400 during startup.'

How to user trace flag 1400 during startup?

Since I am newbie Kindly guide me with step by step procedure.

thanks

Hi Shobha,

Database Mirroring is disabled by default in SQL Server 2005 and is enabled in SQL Server 2005 SP1. Therefore, I strongly encourage you to download and install SP1 by following the directions at https://www.microsoft.com/sql/sp1.mspx.

However, if you choose to continue using the RTM (Release to Manufacturer) version of SQL Server 2005 you can enable this feature by adding -T 1400 to the startup options. To do this follow the direction at http://msdn2.microsoft.com/en-us/library/ms190737.aspx. You will need to restart the service upon doing this; a reboot of your system should suffice.

Thanks,

Jaaved Mohammed

|||

Hi. I am using SP1 currently, but I still got the same problem