Monday, June 24, 2013

[MS SQL Server] what are the high level steps to move a server from one datacenter to another datacenter

[MS SQL Server] what are the high level steps to move a server from one datacenter to another datacenter


what are the high level steps to move a server from one datacenter to another datacenter

Posted: 23 Jun 2013 07:42 PM PDT

what are the high level steps to move a server from one datacenter to another datacenter ?Thanks

Error importing SharePoint 2010 list into SQL Server 2008 R2 database through SSIS

Posted: 23 Jun 2013 01:07 PM PDT

Hi,I want to import SharePoint 2010 list data into a different SQL Server 2008 R2 database. The table structure for each list was created through exporting lists to excel and then using Import and Export wizard. I created an SSIS package using [url=http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652]SharePoint SSIS Adapter[/url]. When I execute the package to test from BIDS, I get following error through SendMail task:Error code: -1073450910Error description: System.Runtime.InteropServices.COMException (0xC0047020): Exception from HRESULT: 0xC0047020 at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSBuffer100.AddRow(IntPtr ppRowStart) at Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.AddRow() at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)Error code: -1073450952Error description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "SharePoint List Source - SP Sample" (2806) returned error code 0xC0047020. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.Error code: -1073450910Error description: Microsoft.Samples.SqlServer.SSIS.SharePointUtility.SharePointUnhandledException: Unspecified SharePoint Error. A possible reason might be you are trying to retrieve too many items at a time (Batch size) ---> System.ServiceModel.FaultException: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.Server stack trace: at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListsService.ListsSoap.GetListItems(GetListItemsRequest request) at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListsService.ListsSoapClient.ListsService_ListsSoap_GetListItems(GetListItemsRequest request) at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListsService.ListsSoapClient.GetListItems(String listName, String viewName, XElement query, XElement viewFields, String rowLimit, XElement queryOptions, String webID) at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.Adapter.ListsAdapter.GetSharePointListItems(String listName, String viewId, XElement queryXml, XElement viewXml, Int16 pagingSize, XElement queryOptionsXml) --- End of inner exception stack trace --- at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.Adapter.ListsAdapter.GetSharePointListItems(String listName, String viewId, XElement queryXml, XElement viewXml, Int16 pagingSize, XElement queryOptionsXml) at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.Adapter.ListsAdapter.GetSharePointListItemData(String listName, String viewId, IEnumerable`1 fieldNames, XElement query, Boolean isRecursive, Int16 pagingSize) at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListServiceUtility.GetListItemData(Uri sharepointUri, NetworkCredential credentials, String listName, String viewName, IEnumerable`1 fieldNames, XElement query, Boolean isRecursive, Int16 pagingSize) at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)BatchSize 1000 (some of the lists had 5000 records)DelayValidation = TrueRun64BitRuntime = FalsePlease point out what wrong am I doing.Thanks in advance,Puja

SSIS FTP Package Fails as a Job but Runs Manually

Posted: 23 Jun 2013 05:45 AM PDT

I wrote an SSIS package that pulld files from a client's FTP site. When run manually through "Execute Package Utility" -> "Execute" it runs to completion.If I try and run it in a query window[code="sql"]exec xp_cmdshell 'dtexec /DTS "\MSDB\Website_FTP_Import" /SERVER MySQLServer Name /CHECKPOINTING OFF /REPORTING V '[/code], I get the following error, saying the password is not allowed. But the password is in the package and it works when run the other way.:[code="other"]Microsoft (R) SQL Server Execute Package UtilityVersion 10.0.2520.0 for 32-bitCopyright (C) Microsoft Corp 1984-2005. All rights reserved.NULLStarted: 14:25:49Error: 2013-06-23 14:25:49.97 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Property" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.End ErrorError: 2013-06-23 14:25:54.08 Code: 0xC001602A Source: Website_FTP_Import Connection manager "FTP Connection Manager" Description: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed.End ErrorError: 2013-06-23 14:25:54.08 Code: 0xC002918F Source: FTP Task - RoundTable FTP Task Description: Unable to connect to FTP server using "FTP Connection Manager".End ErrorWarning: 2013-06-23 14:25:54.08 Code: 0x80019002 Source: Website_FTP_Import Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.End WarningDTExec: The package execution returned DTSER_FAILURE (1).Started: 14:25:49Finished: 14:25:54Elapsed: 4.203 secondsNULL[/code]

No comments:

Post a Comment

Search This Blog