Forum Replies Created

Viewing 15 posts - 3,256 through 3,270 (of 9,715 total)

  • RE: Creating an SSIS package to generate an XML output file

    kbnyny (4/17/2014)


    Brandie when I took out he Binary Base64 I still get the same funny character on the XML output file.

    Can you give us a DDL for the table and...

    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.

  • RE: Creating an SSIS package to generate an XML output file

    Hmm. I'm not able to replicate the strange character pattern on my flat file. It comes out as all binary. And when changing datatypes in the connection manager, I appear...

    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.

  • RE: Creating an SSIS package to generate an XML output file

    I am trying to replicate this in my environment, using my own tables. Can you post the set up of the flat file connection manager (General and Advanced tabs)?

    You can...

    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.

  • RE: Creating an SSIS package to generate an XML output file

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

    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.

  • RE: Creating an SSIS package to generate an XML output file

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

    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.

  • RE: Creating an SSIS package to generate an XML output file

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

    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.

  • RE: Creating an SSIS package to generate an XML output file

    kbnyny (4/16/2014)


    The Data type is the same in the connection manager and in the Data Conversion Transformation Editior.

    That's not what I asked. You said you were having problems changing the...

    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.

  • RE: Creating an SSIS package to generate an XML output file

    Your XML document may be malformed. Are you sure you have your hierarchy designed correctly?

    And are you looking for a full XML document or just a fragment?

    EDIT: Are you changing...

    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.

  • RE: Use SSIS or SQL Server Agent to post to HTTPS site

    Another question. Once I finish writing up the Powershell script, how do I make it part of the SSIS package or the SQL Server Agent job?

    Is it as simple as...

    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.

  • RE: Use SSIS or SQL Server Agent to post to HTTPS site

    Thanks.

    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.

  • RE: Use SSIS or SQL Server Agent to post to HTTPS site

    GAH.

    Is this Powershell error normal?

    Microsoft Team Foundation Server 2008 Power Tools\TFSSnapin.ps1 cannot be loaded because running scripts is disabled on this system.

    It gives me a link for execution polices on...

    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.

  • RE: Use SSIS or SQL Server Agent to post to HTTPS site

    Powershell will do this?

    ROCK ON. I've been looking for an excuse to learn this. Thanks for the links and the reference.

    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.

  • RE: Use SSIS or SQL Server Agent to post to HTTPS site

    I'm assuming so. The link they point to in their help document is http://www.w3.org/TR/html4/interact/forms.html.

    HelpDoc


    For automatic submission, post the embedded file over HTTPS using multipart/Form-data (MIME) encoding.

    It tells me to have...

    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.

  • RE: Sql network name

    Beyond repeating what I've told you about permissions and SQL Server Browser Service, the only other thing I can recommend is that you call your software vendor or go to...

    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.

  • RE: xp_create_subdir for non-sysadmins

    Jeff Moden (4/16/2014)


    Brandie Tarvin (4/16/2014)


    I answered the OP before I fully read your post. Searching your error on Google, I found this article from TechNet. Does it help resolve your...

    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.

Viewing 15 posts - 3,256 through 3,270 (of 9,715 total)