Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SSIS explicit data type in xsd

Posted on 2009-07-16
1
Medium Priority
?
649 Views
Last Modified: 2013-11-10
Hi Experts,

Is it possible to explicitly name the data type in the xsd file to sql server data types? I have an xml source that I am putting through a lookup in SSIS. The lookup is reporting that the data type don't match with the table. The attribute in the xml file is a url with data type string, I've changed the table column data type to varchar(max), nvarchar(max), and text with no effect.

I'm now trying to set the data type in the xsd file by using the namespace

xmlns:dt="urn:schemas-microsoft-com:xml:datatypes"

<xs:element name="ItemURL" type="xs:string" dt:type="varchar" minOccurs="0"/>

Can I do something like dt:type="varchar"?

0
Comment
Question by:acclimate
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 9

Accepted Solution

by:
Hwkranger earned 1500 total points
ID: 24882088
Yes you can.  

What I do though, is I used a "DERIVED COLUMN" or the "CONVERT DATA" tasks.  It's easier than working with the XSD in my opinion.  The XSDs are easily corrupted.  I use hundreds of them, and I find it's easier to manipulate the data afterwards rather than defining it in the XSD.
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question