Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

Creating an SSIS package to generate an XML output file Expand / Collapse
Author
Message
Posted Wednesday, April 16, 2014 2:40 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 8:14 AM
Points: 49, Visits: 122
In connection Manager the encoding is Unicode
Post #1562454
Posted Wednesday, April 16, 2014 2:45 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:21 AM
Points: 13,236, Visits: 11,006
OK. If you put a data viewer right before you write to the destination, does the data look normal?
When the flat file is created, can you double check the encoding using a decent text editor, like notepad++?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1562457
Posted Wednesday, April 16, 2014 2:49 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 12:24 PM
Points: 5,584, Visits: 6,376
kbnyny (4/16/2014)
Sorry Brandie, I did not make myself clear enough. I can change the data type but the problem is when I do change it to anything beside Unicode text stream [DT_NTEXT] I get a red x on the flat file destination.


Again, you're not telling me WHICH component you're making the change on that gets the file destination screwed up. There are multiple components that MUST be changed. Are you changing all of them or only one of them?

Do this:

Change the connection manager data type. The flat file destination should get a red X. Open the flat file destination, click on the Column Mappings tab, then (after it finishes changing over) hit OK.

Does the red X go away? If not, open up the Error tab and paste the contents into this thread. Do not "fix" it back until Koen and I can get an idea of what's going wrong.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1562461
Posted Wednesday, April 16, 2014 3:05 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 8:14 AM
Points: 49, Visits: 122
Here is a screen shot of the error, not sure if this will work.

Post #1562466
Posted Wednesday, April 16, 2014 3:09 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:21 AM
Points: 13,236, Visits: 11,006
kbnyny (4/16/2014)
Here is a screen shot of the error, not sure if this will work.



You cannot post directly from your own hard drive.
You can upload an image as an attachment though. (but not as PDF)




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1562471
Posted Wednesday, April 16, 2014 3:10 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 12:24 PM
Points: 5,584, Visits: 6,376
Can you add it to your post as an attachment instead of embedded into the post? All I can see is a place holder and I've used 2 different computers and 2 different browsers.

Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1562473
Posted Wednesday, April 16, 2014 3:12 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 8:14 AM
Points: 49, Visits: 122
Error msg say " The data type for input column "Copy of XML_f52e2b61-18a1"(330)" is DT_NTEXT.

When I change encoding to unicode and the data type DT_NTEXT to that this is what I'm getting. I am making the change in connection manager.

noneॄPLastName੄PFirstNameࡄ
牭㥎Ꙧ멻嗢޻☆揾��끠觞ግﯪﲁ怼蘜㻸ౢ霽퓾惫쯰솀胳ػ恷��ᰀ
Post #1562475
Posted Wednesday, April 16, 2014 3:14 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 8:14 AM
Points: 49, Visits: 122
attach is a screen shot

  Post Attachments 
Screen shot.pdf (7 views, 107.95 KB)
Post #1562476
Posted Wednesday, April 16, 2014 3:16 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:21 AM
Points: 13,236, Visits: 11,006
kbnyny (4/16/2014)
Error msg say " The data type for input column "Copy of XML_f52e2b61-18a1"(330)" is DT_NTEXT.

When I change encoding to unicode and the data type DT_NTEXT to that this is what I'm getting. I am making the change in connection manager.

noneॄPLastName੄PFirstNameࡄ
牭㥎Ꙧ멻嗢޻☆揾��끠觞ግﯪﲁ怼蘜㻸ౢ霽퓾惫쯰솀胳ػ恷��ᰀ


The error is probably a bit longer that just that.
Check the error window to find the full error.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1562478
Posted Wednesday, April 16, 2014 3:25 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 12:24 PM
Points: 5,584, Visits: 6,376
kbnyny (4/16/2014)
Error msg say " The data type for input column "Copy of XML_f52e2b61-18a1"(330)" is DT_NTEXT.

When I change encoding to unicode and the data type DT_NTEXT to that this is what I'm getting. I am making the change in connection manager.


Did you refresh the flat file destination metadata after making the change in the connection manager?


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1562484
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse