XSLT Transform Dropping Spaces, CR's

Jun 15, 2006

I have an XSLT transform that works perfectly using the msxsl.exe utility.

When the same XSL file is run through an SSIS XML transform, the character spacing and carriage returns embedded in the XSL templates are mostly (but not completely) dropped.

Any comments on why SSIS is behaving differently than msxsl.exe? What to do?

Thanks in advance,

Richard

View 4 Replies


ADVERTISEMENT

XML, XSLT And SQL Server

Jun 14, 1999

I want to delete and recreate the master Database Device for purpose of shrinking the size of the device .
I dont want to loose the Master db.

I thought of transfering the Master db to a different device,
Delete and recreate the master device and then tranfer back the master db .
and this is all done through the MS SQL enterprise Manager (SQL 6.5 )
Is this the safest eay to proceed with this task?

Any thoughts are greatly appreciated.

Thank you
Guss Hasb

View 1 Replies View Related

XML Task && XSLT

Feb 23, 2007

Can I use the XML task in SSIS to create an excel document? If so which operation type is best to do it with, XSLT?

I'm trying create excel files dynamically with nothing more than a SQL statement that I'm passing as a variable which generates XML. I would then like to take that variable and combine it with a template and create an excel document. Any help would be appreciated. I do not want to use the data flow because it requires all transformations ahead of time.



Thanks,

Phil

View 3 Replies View Related

Displaying Xml With Xslt In RS

Sep 10, 2007



Hi,

I've got an xml and an xslt - I want to get that into reporting services. Right now I have a link to the xml file in a 'report', which will open it correctly and format with the xslt. I'd like it to display without going to an external link.

I know how to use an xml datasource, but I need the xslt applied, since it has some nice formatting in it - so i don't think that will work.

I'm trying to report on the results of a scripted ms baseline security analyzer of several servers - the style sheet lets you drill down and has links to the base reports.

Thanks for your help.

View 4 Replies View Related

How To Change Xml With Xslt In Ssis

Mar 3, 2008

Hi,

I've got a problem with my ssis package.
I have a webservice, which from i am downloading xml file which looks like this:









Code Snippet

<?xml version="1.0" encoding="utf-16"?>
<DataSet>
<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Table">
<xs:complexType>
<xs:sequence>
<xs:element name="lukas_id_nagrody" type="xs:string" minOccurs="0" />
<xs:element name="ilosc" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
<NewDataSet>
<Table diffgr:id="Table1" msdata:rowOrder="0">
<lukas_id_nagrody>10</lukas_id_nagrody>
<ilosc>4</ilosc>
</Table>
<Table diffgr:id="Table2" msdata:rowOrder="1">
<lukas_id_nagrody>12</lukas_id_nagrody>
<ilosc>10</ilosc>
</Table>
<Table diffgr:id="Table3" msdata:rowOrder="2">
<lukas_id_nagrody>21</lukas_id_nagrody>
<ilosc>32</ilosc>
</Table>
<Table diffgr:id="Table4" msdata:rowOrder="3">
<lukas_id_nagrody>32</lukas_id_nagrody>
<ilosc>13</ilosc>
</Table>
<Table diffgr:id="Table5" msdata:rowOrder="4">
<lukas_id_nagrody>33</lukas_id_nagrody>
<ilosc>15</ilosc>
</Table>
<Table diffgr:id="Table6" msdata:rowOrder="5">
<lukas_id_nagrody>34</lukas_id_nagrody>
<ilosc>2</ilosc>
</Table>
</NewDataSet>
</diffgr:diffgram>
</DataSet>

And i want it to looks like this:






Code Snippet

<?xml version="1.0" encoding="utf-16"?>
<DataSet>
<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Table">
<xs:complexType>
<xs:sequence>
<xs:element name="lukas_id_nagrody" type="xs:string" minOccurs="0" />
<xs:element name="ilosc" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<Table id="Table1" rowOrder="0">
<lukas_id_nagrody>J07Z0</lukas_id_nagrody>
<ilosc>1</ilosc>
</Table>
<Table id="Table2" rowOrder="1">
<lukas_id_nagrody>J08Z0</lukas_id_nagrody>
<ilosc>1</ilosc>
</Table>
<Table id="Table3" rowOrder="2">
<lukas_id_nagrody>J09Z0</lukas_id_nagrody>
<ilosc>1</ilosc>
</Table>
</DataSet>

Can You help me?

Thanks in advance

ps. sorry for my english

View 4 Replies View Related

XSLT Transformation In XML Task

Sep 10, 2007

Hi,

I've a xml file and I want to substitute some of the values from database in this xml using XSLT transformation making use of XML task. How can this be achieved?

Thanks

View 5 Replies View Related

Generate RDL Using XSDObjectGen XSD.EXE XMLTextWriter Or XSLT...

Mar 14, 2006

I'm writing some code to generate RDL based on a set of existing tables that define reports. (Headings, columns etc.)

The options I'm exploring so far for doing this are as follows:

Use XMLTextWriter class
Use XMLDocument class
Use XMLSerialiser to serialse a set of classes made with XSD.EXE and
Use XMLSerialiser to serialse a set of classes made with XSDObjectGen
Use XSLT to convert MyReportDefinitionDataset.GetXML into RDL

Has anybody else out there seen other code that does anything like this or in general has any suggestions to help me narrow these options down?

Note:

I am hoping to allow users supplying RDL their own files as templates enabling them to define things like report header and footer etc.
My code will take the Table element from the template RDL and replace it with my generated XML (Headings and columns etc.)

Any suggestions/help/existing sample code appreciated.

Thanks,

Mike G

View 4 Replies View Related

XML Task: How To Pass Arguments To XSLT

Aug 10, 2006

In the XML Task if you set the OperationType to XSLT, how do you pass arguments to the Transform like you would in .Net by using the XsltArgumentList class? Thanks.

View 3 Replies View Related

Message Output From XSLT XML Task

Sep 11, 2006

Where does output from <xsl:message> stylesheet elements go? It's not in the Progress or Output window, and there doesn't seem to be a property that controls the destination for messages.

View 4 Replies View Related

Strip DTD Out; Help With Some XSLT Inside Of SSIS XML Task

Sep 4, 2007

I'm reading over this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1884062&SiteID=1

and I'm kinda lost as to what to do to strip out the dtd from an XML file I am downloading. I do NOT know XSLT and for that reason, I can't follow his logic.

My SSIS package downloads my XML file just fine, now I need to do a strip of the DTD line in my XML Task.

The person who provided the solution in the above post said to do this...





Code Snippet
Operation Type: XSLT
Source Type: Variable
Source: Variable's name containing the xml text
Save Operation Result: True
DestinationType: Variable
OverwriteDestination: True
Destination: Variable's name which is to contain the original xml minus the DTD.
SecondOperandType: Variable







That stuff I understood. I'll replace variables with my files because they are stored that way, but from what I can tell, that's not my problem.

The stuff he says below this comment is going over my head like a ton of bricks. I can't figure out how to do it.

This is the kind of line of my XML that I want to strip out.

https://www.myaddy.com/pbdr.dtd"[]>

and then he said this...





Code Snippet
Since XSL doesn't know about DTDs, telling it to copy everything strips out DTDs. Then use the Variable specified in the Xml task's SecondOperand as the Source data for the xml source.


Code Snippet

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">

<xsl:copy-of select="." />

</< FONT>xsl:template>

</< FONT>xsl:stylesheet>

A note on how to paste a multi-line xml document into a Integration Services String variable:


Integration Services String variables textboxes are not multi-line, in the Windows sense of a line (CR+LF),

So, in order to paste multi-line text (which xml docs almost always are), save a temporary copy with a unix line ending.

That is, create an xml file in visual studio, and paste your sample original xml in there. Go to File/Advanced Save options, and save the xml with the the settings of Encoding: Unicode (utf-8 without signature) - CodePage 65001, and most importantly, set the Line endings dropdown to "Unix (LF)".

After selecting "OK", copy and paste the text from Visual Studio's xml file editor into the IS variable, and you'll note all the xml data appears.





So can anyone walk me through a dummies version of what he is suggesting to do?

Thanks,
Keith

View 1 Replies View Related

Problem With Extraction Of A Report In Xml Format Using XSLT

Nov 1, 2007

Hi guys,


I have a simple report created with rs2005. I want to get the output exported (using the export options of rs2005) in a specific xml format, so I am using xslt transformation to get it proper.

My problem is that, when I'm doing this using my own machine (SQL Server 2005 32bit installed) everything works OK. BUT when I want to try it on a server that we are supposed to use it gives me a real bad error. On the server, if I have the report without using xslt, it gets exported OK but not in the correct format. I have tested the report on a 32 and on a 64 bit server, I have used either SP1 and SP2 but still can't get through. The error message appearring while I try to export in xml is "Server Error in '/Reports' Application. The XSLT path is invalid. It refers to an external resource, uses invalid syntax, or the XSLT was not found in the catalog."


Has anyone seen something like this before ?


Your help would be much appreciated.

Thanx in advance

View 5 Replies View Related

XSLT Transformation On XML Data Stored In SQL Server 2005

Jun 27, 2007

Hi  Does anyone have any information on how I can due a XSLT Transformation on XML Data Stored in SQL Server 2005?Thanks for the helpBones   

View 10 Replies View Related

Xslt Filters On Xml Output. Cdata-section-elements And Omit-xml-declaration Problems.

Sep 14, 2006

Hi All,



I'm using some xslt documents to transform the xml output of my Reports
but have come across two curiosities where the xslt filter seems to
behave unusually.



Firstly, I need the final saved file to have an xml declaration, which
I believe it should do by default. Even if I put
omit-xml-declaration="no" in the xsl:output tag I don't get an xml
declaration. At present we have a custom job that writes these
declarations back into the xml after SRS has saved it.



Secondly and more importantly, I need to have some of my output tags
wrapped in CDATA sections. I've tried using the cdata-section-elements
attribute, again with no luck.

my XSLT looks something like this (simplified for space)



<?xml version="1.0" encoding="utf-8"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="xml" encoding="utf-8" media-type="text/xml" omit-xml-declaration="no" cdata-section-elements="description"/>

<xsl:template match="/">

<xsl:for-each select="Report/table1/Detail_Collection/Detail">

<item>

<description>


<xsl:value-of select="@Description"/>

</description>

</item>

</xsl:for-each>

</xsl:template>

</xsl:stylesheet>



The output is something like:



<item>

<description>My first description text...</description>

</item>


<item>


<description>My seconddescription text...</description>


</item>



What I want is:

<?xml version="1.0" encoding="utf-8"?>

<item>


<description><![CDATA[My first description text...]]></description>


</item>



<item>



<description><![CDATA[My secondfirst description text...]]></description>



</item>



All help gratefully appreciated.



Thanks - Andrew.

View 5 Replies View Related

How To Convert XML File To XSL File Using XSLT

Jan 30, 2014

I need to convert an xml file that has an attribute(name). This xml file has to be converted using xsl into the XSLT file such that the tag should have the same structure along with it and its the tag-content also should be the value of the attribute.

<?xml version="1.0" encoding="utf-8"?>
<PatientUpdateRequest xmlns="http://medseek.com/ecoEnablement/Schemas">
<General>
<SendingApplication>SendingApplication1</SendingApplication>
<SendingFacility>SendingFacility1</SendingFacility>

[code].....

View 1 Replies View Related

Dropping Tables

May 28, 2002

Is there a way we can prevent a object owner from dropping his tables. Example:

There is a user called 'tom' who is given create table permissions, 'tom' creates the table completes his dev and then the table is moved into production where 'tom' is still the owner. However, in production, 'tom' does not have the create table privs. Because 'tom' is the owner of the table, he is still able to drop the table in production. This is what I am trying to avoid. I would like to retain 'tom' as the owner and want to take away his create/drop privs.

View 1 Replies View Related

Dropping The Statistics

Nov 17, 2000

Does anyone have any generic scripts that Drop all the statistics that SQL auto generates?? I have hundreds of '_WA_....'
indicies that are auto created by SS7 and I just want to get rid of ALL of them. Thanks!

View 3 Replies View Related

DRopping Primary Key.

Dec 7, 1999

Simple heres the syntax Alter Table XX Drop PRIMARY KEY.

This is not working whats up?

Thanks,
Phil

View 3 Replies View Related

Dropping A Column

Apr 12, 2001

Whats the quickest way to drop a column from a table with 1 million rows.
This is for SQL Server 6.5

Thanks for all the responses,
Chan

View 1 Replies View Related

Dropping Connections - 6.5

May 22, 2001

I need to drop a database but cannot because there are 2 open connections that I cannot drop via EM. Is there a way to do this without starting and stopping??

View 2 Replies View Related

Dropping Columns

Jul 20, 1998

Hi,

I`m new at SQL Server so excuse me if this question sounds dumb.

Does anybody know how to drop columns in a table. I know I can drop and re-build the table,
but I would prefer and easier way.

Thanks

-Z

View 1 Replies View Related

Dropping Database

Dec 21, 1998

Hi,

After I drop the database, I backed up the master database, I recreate the database with new name. When I tried to do the import on the command level,
It gives me the error:
Attempt to locate entry in the sysdatabases for database 'db1' by name,
failed -- no entry found in that name.

What should I do? Thanks.

View 1 Replies View Related

Dropping Defaults

Jul 6, 2001

I have run the following script to create a default on a table:

alter table TableXYY
add default 0 for ColumnX

Now, how do I delete this default (without re-creating the table)??

Thanks

View 1 Replies View Related

Dropping Users

Jul 23, 2001

Anyone know how to drop all users associated with a particular login not matter what database they're contained in?

ie login AdminUser / User AdminUser (in databases master, Dev1)

....
Thus, is there a way to drop the AdminUser login above and associated user
AdminUser in databases master, Dev1 in example above.

Thanks

View 1 Replies View Related

Dropping Database

Sep 7, 2007

Hi friends,

How I can drop a database insatance from a different server ( data base is SQL Server 2005) from my code

Hoping a early reply ....
Thanks :)

View 5 Replies View Related

Dropping A Set Of Tables

Feb 22, 2004

Hi
I am using SQL server 7 database and ASP as front end. I run an application where a text file is loaded into database. After this is done procedures are run to create a set of tables that have snapshots of the data in the text file.. each time i load a new text file i want to create the snapshots.. i hve written a stored procedure to create tables and insert values into the tables.. however how do i delete the tables i created the previous time.. the number of snapshots and their names will depend on the size of the text file.. how do i refer to all the snapshots created and drop them all before creating new ones?
plese guide
regds

View 1 Replies View Related

Dropping All Indexes

Jan 3, 2007

Looking for suggestions.

I have a database that is giving me a bad Index error. When I go to drop the necessary Index it is telling me that it either does not exist or cannot be dropped. However when I try to build that index, it tells me one already exists.

Is there any way to drop all of the indexes or at the very least see what the indexes are? This particular database is using 2005 Express.

Any help would be great!
Shawn

View 4 Replies View Related

Dropping Constraints

Oct 15, 2007

How to remove the constraints on a table in sql server 2000? I need to drop the column, so i need to drop the constraint before that.

Alter Table Table_Name NO CHECK constraints ALL.

Once I execute the above one, it says, "Successfully Executed" but when I try to drop it doesnt allow me and gives me the following error:

Server: Msg 5074, Level 16, State 1, Line 1
The object 'DF_Users_Created_by' is dependent on column 'CREATED_BY'.
Server: Msg 4922, Level 16, State 1, Line 1
ALTER TABLE DROP COLUMN CREATED_BY failed because one or more objects access this column.

Any ideas?

Thanks,

View 2 Replies View Related

Dropping A Constraint

Sep 20, 2006

I think the answer to this question will be something like 'you'll have to re-initialize the subscribers', but I need to ask anyway...

I created a publication where my foreign key constraint we NOT created with NOT FOR REPLICATION. My publication is configured to replicate DDL changes. Is there any way I can drop and re-create the constraint in the publisher and get replication to push the change to the subscribers?

Thanks for your help

Graham

View 1 Replies View Related

Trouble Dropping A Job

Mar 10, 2007

I have trouble dropping a job that was a maintence plan.

I get the following error. Is there a way around this?

TITLE: Microsoft SQL Server Management Studio
------------------------------

Drop failed for Job 'Maintenne Plan'.  (Microsoft.SqlServer.Smo)

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The DELETE statement conflicted with the REFERENCE constraint "FK_subplan_job_id". The conflict occurred in database "msdb", table "dbo.sysmaintplan_subplans", column 'job_id'.
The statement has been terminated. (Microsoft SQL Server, Error: 547)

 

View 3 Replies View Related

Dropping A Database From ASP.NET

Jan 16, 2008

I am trying to run a dymanic DROP DATABASE <dbname> command in a stored procedure called from ASP.NET. I typically connect from the .net using a SQL builtin account. I am getting this error:

System.Data.SqlClient.SqlException: Cannot drop the database 'db_testco', because it does not exist or you do not have permission.

The database is there for sure asI can browse it via the Studio manager. What permission do I need to set for my .net login to allow it to drop ? I tried adding the Delete permission to the database and still no go...

Setup: SQL 2005 SP2 2 Node cluster.

Thanks.

View 3 Replies View Related

Best Way Of Dropping The Column

Oct 11, 2007

Hi,

I have a table with multiple column and has millions of rows in it(say about 50 millions ) and its in production.
What is the best way of dropping the a column from the table without impacting the systems performance. Remeber this table will be used some application to get some data out of it.


~Mohan

View 1 Replies View Related

Need Help Dropping Master Key

Apr 11, 2007

I am having following issue recreating my service broker



This could be a trivial fix...



when i execute the following query..



open master key decryption by password = 'pass1234$'

alter master key drop encryption by password = 'pass1234$'

close master key

drop master key

go



I get the following result..



Msg 15558, Level 16, State 1, Line 3

Cannot drop encryption by password '********'.

Msg 15580, Level 16, State 1, Line 5

Cannot drop master key because certificate 'BackofficeServiceAccount' is encrypted by it.



But 'BackofficeServiceAccount' was already dropped.



Can any one help me how to drop master key?



I appreciate any input..



regards...

View 3 Replies View Related

Trigger Dropping

Apr 12, 2006

Hi:

I think I am doing something wrong. I am trying to make the trigger fire when I want to drop the same trigger. For example I have the following trigger defined:

USE AdventureWorks2000

GO

CREATE TRIGGER Incheckstock

ON DATABASE

FOR DROP_TRIGGER

AS

PRINT 'You must disable Trigger "Incheckstock" to drop Trigger!'

ROLLBACK

GO

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

ENABLE TRIGGER Incheckstock ON DATABASE



DROP TRIGGER Incheckstock

ON DATABASE

I created the trigger Incheckstock and i want to see if the same trigger fires itself if when i am trying to drop the trigger with the same name (kind of recursive one). Is this possible in SQL 2005?. If I asked a dumb question, please correct me.

Thanks

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved