Forum Replies Created

Viewing 15 posts - 7,051 through 7,065 (of 9,725 total)

  • RE: How to have an Excel destination have dynamic column names?

    Last post until I get more info from you on how you're dynamically generating your column names (code sample?) from the database.

    Looks like there was an article on SSC for...

    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: How to have an Excel destination have dynamic column names?

    WayneS (10/27/2010)


    3. Execute SQL task (connected to a SQL Server) runs a query with dynamic column names (based on the year being executed for). The results are stored in a...

    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: BCP in

    Jez,

    So you'd be doing this manually instead of scheduled as an automatic job?

    Have you tried the Import / Export Wizard? It can import flat files.

    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: BCP in

    Ivan Mohapatra (10/27/2010)


    Soory To all For the format of writeing in the previous post.

    Ivan, that's okay. Just please don't use text-speak like "u" and "r" in these forums....

    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: How to have an Excel destination have dynamic column names?

    WayneS (10/27/2010)


    Brandie, if I'm understand you correctly, you are saying to dynamically set the file name.

    Nope. That's a different, separate thing. You can dynamically create the file, and all its...

    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: Get the Current Date

    Odd. When I do a "SELECT current_timestamp, GetDate()", I get the exact same values. So I'm not getting the point about readability.

    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: Today's Random Word!

    crystal

    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: Get the Current Date

    Jeff Moden (10/27/2010)


    But, my recommendation is to avoid them like the plague.... they're comparatively slow.

    How much of a performance hit do styles put on the server?

    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: How to have an Excel destination have dynamic column names?

    Dynamic name can be done either via script or via a Variable set as "Evaluate as Expression".

    Using the File Connection (not the Flat File Connection), you can dynamically create...

    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: Are the posted questions getting worse?

    WayneS (10/27/2010)


    Questions about this in general:

    1. How do we "submit" these "articles"?

    Look in the upper left hand sidebar. "Write For Us" has all the details. You'll have to click through...

    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: Are the posted questions getting worse?

    Steve Jones - SSC Editor (10/27/2010)


    I wonder if any of you would be interested in writing to fill holes? I keep finding posts here, and elsewhere that someone answers a...

    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: Are the posted questions getting worse?

    Steve Jones - SSC Editor (10/27/2010)


    Whew, for a second I thought I was going to learn something on The Thread.

    OMG, someone grab the paramedics. Steve's going into shock because he...

    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: Which table is used last

    Read my edit. Your punctuation use (. instead of ?) at the end made it sound like a statement, not a question. I thought you were telling us there were...

    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: BCP in

    Ivan,

    Your post is almost incomprehensible to me. Could you edit out the abbreviations and put real words in their place so I can understand what you're trying to say?

    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: Which table is used last

    parthi-1705 (10/27/2010)


    Any other 3rd party tool can solve this.

    Really? I haven't seen one that doesn't use traces or triggers. Please, tell us what those tools are. I'd like to test...

    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 - 7,051 through 7,065 (of 9,725 total)