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 2:49 pm

    #1706595

    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 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.