Home Forums SQL Server 2008 SQL Server 2008 - General Creating an SSIS package to generate an XML output file RE: Creating an SSIS package to generate an XML output file

  • April 16, 2014 at 3:25 pm

    #1706616

    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 AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.