Problems using SQL: export

Showing posts with label export. Show all posts

Friday, March 30, 2012

Problems with values display as currency

Hi NG,
has anybody got a report with values formatted as currency and could export
it to pdf without loosing the currency-formatting?
My currency-values are in Euro. Do i have to put some language-parametes in
the URL?
regards
Frank
www.xax.deAdobe 5.00 and 5.05 do not render symbols (e.g. Euro symbol) correctly when
the Arial font is used. Which version are you using? Did you try other fonts
(e.g. Tahoma)?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Frank Matthiesen" <fm@.xax.de> wrote in message
news:34mtrsF4avhu6U1@.individual.net...
> Hi NG,
> has anybody got a report with values formatted as currency and could
export
> it to pdf without loosing the currency-formatting?
> My currency-values are in Euro. Do i have to put some language-parametes
in
> the URL?
> regards
> Frank
> www.xax.de
>
>|||"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> schrieb im
Newsbeitrag news:eEvOCqZ%23EHA.3592@.TK2MSFTNGP09.phx.gbl...
> Adobe 5.00 and 5.05 do not render symbols (e.g. Euro symbol) correctly
> when
> the Arial font is used. Which version are you using? Did you try other
> fonts
> (e.g. Tahoma)?
Got the wrong acrobat-version (5.0)
After an update everything wirks fine.
thx
frank
www.xax.desql

Monday, March 26, 2012

Problems with SQL 2005 Export Wizard

I am trying to transfer data from SQL Express to SQL Server 2005. The data is from Paypal Commerce Starter Kit from ASP.NET site.

I have tried several options (Optimize for many tables, Run in Transaction). However the data is not exported. This is the error I am getting:

TITLE: Operation stopped...

The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.

ADDITIONAL INFORMATION:

BUTTONS:

Here is some more info:

===================================

Program Location:

at Microsoft.SqlServer.Dts.Runtime.PersistImpl.LoadFromXML(XmlNode node, IDTSEvents events)
at Microsoft.SqlServer.Dts.Runtime.DtsContainer.LoadFromXML(XmlNode node, IDTSEvents events)
at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.Configure(ITransferMetadataProvider metadataProvider)
at Microsoft.SqlServer.Dts.DtsWizard.Execute.DoTransferConfigureProvider(Exception& ex)

===================================

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageClass.LoadFromXML(Object pNode, IDTSEvents90 pEvents)
at Microsoft.SqlServer.Dts.Runtime.PersistImpl.LoadFromXML(XmlNode node, IDTSEvents events)

|||I've moved this to the SSIS forum. The error you're hitting looks to be in the SSIS/DTS subsystem. Some one in this forum should be able to help.|||

If LoadFromXML() fails it suggests that your package might be corrupt. Can you take that .dtsx file and open it in BIDS? (just right-click and Edit)

-Jamie

|||Thanks, but there is no package created. I just use Export Data wizard...|||

The Export Data wizard fails at "Create Temporrary XML file for table metadeta". here is mor edetails:

Operation stopped...

- Create a TransferProvider. (Success)
- Create a temporary file for destructive SQL. (Success)
- Create a temporary file for constructive SQL. (Success)
- Create a temporary XML file for table metadata. (Success)
- Configure the TransferProvider with files and Source/Destination connection info. (Error)

Messages

ADDITIONAL INFORMATION:

- Execute the transfer with the TransferProvider. (Stopped)

- Execute the destructive SQL. (drop tables) (Stopped)

- Execute the constructive SQL. (create tables) (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Applications] (Stopped)

- Execute transfer package for [dbo].[aspnet_Applications] (Stopped)

- Copying to [dbo].[aspnet_Applications] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Membership] (Stopped)

- Execute transfer package for [dbo].[aspnet_Membership] (Stopped)

- Copying to [dbo].[aspnet_Membership] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Paths] (Stopped)

- Execute transfer package for [dbo].[aspnet_Paths] (Stopped)

- Copying to [dbo].[aspnet_Paths] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_PersonalizationAllUsers] (Stopped)

- Execute transfer package for [dbo].[aspnet_PersonalizationAllUsers] (Stopped)

- Copying to [dbo].[aspnet_PersonalizationAllUsers] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_PersonalizationPerUser] (Stopped)

- Execute transfer package for [dbo].[aspnet_PersonalizationPerUser] (Stopped)

- Copying to [dbo].[aspnet_PersonalizationPerUser] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Profile] (Stopped)

- Execute transfer package for [dbo].[aspnet_Profile] (Stopped)

- Copying to [dbo].[aspnet_Profile] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Roles] (Stopped)

- Execute transfer package for [dbo].[aspnet_Roles] (Stopped)

- Copying to [dbo].[aspnet_Roles] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_SchemaVersions] (Stopped)

- Execute transfer package for [dbo].[aspnet_SchemaVersions] (Stopped)

- Copying to [dbo].[aspnet_SchemaVersions] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Users] (Stopped)

- Execute transfer package for [dbo].[aspnet_Users] (Stopped)

- Copying to [dbo].[aspnet_Users] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_UsersInRoles] (Stopped)

- Execute transfer package for [dbo].[aspnet_UsersInRoles] (Stopped)

- Copying to [dbo].[aspnet_UsersInRoles] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_WebEvent_Events] (Stopped)

- Execute transfer package for [dbo].[aspnet_WebEvent_Events] (Stopped)

- Copying to [dbo].[aspnet_WebEvent_Events] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Categories] (Stopped)

- Execute transfer package for [dbo].[CMRC_Categories] (Stopped)

- Copying to [dbo].[CMRC_Categories] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Content] (Stopped)

- Execute transfer package for [dbo].[CMRC_Content] (Stopped)

- Copying to [dbo].[CMRC_Content] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Content_Versions] (Stopped)

- Execute transfer package for [dbo].[CMRC_Content_Versions] (Stopped)

- Copying to [dbo].[CMRC_Content_Versions] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_InventoryHistory] (Stopped)

- Execute transfer package for [dbo].[CMRC_InventoryHistory] (Stopped)

- Copying to [dbo].[CMRC_InventoryHistory] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Logs] (Stopped)

- Execute transfer package for [dbo].[CMRC_Logs] (Stopped)

- Copying to [dbo].[CMRC_Logs] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_OrderItems] (Stopped)

- Execute transfer package for [dbo].[CMRC_OrderItems] (Stopped)

- Copying to [dbo].[CMRC_OrderItems] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Orders] (Stopped)

- Execute transfer package for [dbo].[CMRC_Orders] (Stopped)

- Copying to [dbo].[CMRC_Orders] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_OrderStatus] (Stopped)

- Execute transfer package for [dbo].[CMRC_OrderStatus] (Stopped)

- Copying to [dbo].[CMRC_OrderStatus] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Products] (Stopped)

- Execute transfer package for [dbo].[CMRC_Products] (Stopped)

- Copying to [dbo].[CMRC_Products] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_ShippingRates] (Stopped)

- Execute transfer package for [dbo].[CMRC_ShippingRates] (Stopped)

- Copying to [dbo].[CMRC_ShippingRates] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_ShoppingCart] (Stopped)

- Execute transfer package for [dbo].[CMRC_ShoppingCart] (Stopped)

- Copying to [dbo].[CMRC_ShoppingCart] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_ShoppingCartItems] (Stopped)

- Execute transfer package for [dbo].[CMRC_ShoppingCartItems] (Stopped)

- Copying to [dbo].[CMRC_ShoppingCartItems] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_TaxRates] (Stopped)

- Execute transfer package for [dbo].[CMRC_TaxRates] (Stopped)

- Copying to [dbo].[CMRC_TaxRates] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_Applications] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_Applications] (Stopped)

- Copying to [dbo].[vw_aspnet_Applications] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_MembershipUsers] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_MembershipUsers] (Stopped)

- Copying to [dbo].[vw_aspnet_MembershipUsers] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_Profiles] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_Profiles] (Stopped)

- Copying to [dbo].[vw_aspnet_Profiles] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_Roles] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_Roles] (Stopped)

- Copying to [dbo].[vw_aspnet_Roles] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_Users] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_Users] (Stopped)

- Copying to [dbo].[vw_aspnet_Users] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_UsersInRoles] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_UsersInRoles] (Stopped)

- Copying to [dbo].[vw_aspnet_UsersInRoles] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_WebPartState_Paths] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_WebPartState_Paths] (Stopped)

- Copying to [dbo].[vw_aspnet_WebPartState_Paths] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_WebPartState_Shared] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_WebPartState_Shared] (Stopped)

- Copying to [dbo].[vw_aspnet_WebPartState_Shared] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_WebPartState_User] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_WebPartState_User] (Stopped)

- Copying to [dbo].[vw_aspnet_WebPartState_User] (Stopped)

|||

Hi all,

I'm having the same problem. Did anybody found a solution for this?

Thanks

|||

Could you guys try to register the xml dlls:

regsvr32.exe msxml3.dll

regsvr32.exe msxml6.dll

HTH.

|||I am having the same problem with my SQL 2005 server (Developer Edition), however, I needed to transform the database to SQL 2000 server. I went to the SQL 2000 box and ran the transform from there and it works fine. I have put all of the latest patches in my 2005 box, updated the MDAC with all versions from 2.6 forward, reinstalled the DTC tools, reinstalled all of the XML patches and updates; still no luck. I did not have this problem until I reformated my HD about 2 weeks ago. Prior to that it all worked fine.|||

After re-instaling, did you also try to register the XML DLLs that Bob suggested? I know they should have been registeded by setup when reinstalling, but just in case ...

Donald Farmer

|||I'm having the same issues and have not done a reinstall. I did try to reregister the referenced .dlls, but it did not help.|||

Has anyone found a solution to this problem yet?

I am trying to run a 'copy database objects' task programatically from vb.net. The SSIS package runs fine from BIDS but fails to load from the file system in the 'loadpackage' call with this 0xc0011008 message.

fyi here is the code...

Private Sub backgroundWorker2_DoWork(ByVal sender As Object, ByVal e As DoWorkEventArgs) Handles BackgroundWorker2.DoWork

Dim pkgLocation As String

Dim pkg As New Package

Dim app As New Application

Dim pkgResults As DTSExecResult

Dim autoEvent As New AutoResetEvent(False)

pkgLocation = e.Argument.ToString()

pkg = app.LoadPackage(pkgLocation, Nothing) ' this is the error line

pkgResults = pkg.Execute()

If pkgResults = DTSExecResult.Success Then

e.Result = "Success"

Else

e.Result = "Failed"

End If

end sub

As you can see this is running on a worker thread.

Does anyone have any ideas?

Thanks and Regards

Ray

|||

Bob Bojanic wrote:
Could you guys try to register the xml dlls:
regsvr32.exe msxml3.dll
regsvr32.exe msxml6.dll
HTH.

This solves this problem.