Forum Replies Created

Viewing 15 posts - 3,631 through 3,645 (of 9,722 total)

  • RE: SSIS-Data in multiple .csv files to columns in same csv file

    In several other packages, here's what I did. I had to actually do a Multicast to do derived columns. Then I pulled those columns together with a UNION ALL. 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.

    May 15, 2013 at 8:29 am

    #1615446

  • RE: SQL2012SP1, simple recovery, transaction log full, can't add another, won't grow

    This may or may not have anything to do with the problem but... Have you checked TempDB?

    I've run into issues where the TempDB log is full up and won't let...

    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.

    May 15, 2013 at 7:14 am

    #1615411

  • RE: Are the posted questions getting worse?

    Lowell (5/15/2013)

    On a completely unrelated note, I started making a post asking someone for a working example of a linked server for Access using the ACE drivers; about halfway 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.

    May 15, 2013 at 7:10 am

    #1615408

  • RE: Parsing a summary / detail flat file

    Thanks everyone for the responses. We're going to start checking them now. I'm glad I asked the question as this was not the direction I had been heading in with...

    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.

    May 13, 2013 at 12:16 pm

    #1614735

  • RE: Parsing a summary / detail flat file

    wolfkillj (5/13/2013)

    I couldn't use your sample data because the text file formatting seemed to be inconsistent from line to line

    Exactly. If you check my first post, you'll see where I...

    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.

    May 13, 2013 at 12:13 pm

    #1614733

  • RE: Are the posted questions getting worse?

    WayneS (5/13/2013)

    Brandie Tarvin (5/13/2013)

    So I'm thinking that this Workflow Logic for Kids is something I'd like to push to more than just our little community. Not only would it encourage...

    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.

    May 13, 2013 at 12:10 pm

    #1614732

  • RE: Are the posted questions getting worse?

    Revenant (5/13/2013)

    Brandie Tarvin (5/13/2013)

    So I'm thinking that this Workflow Logic for Kids is something I'd like to push to more than just our little community. Not only would it encourage...

    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.

    May 13, 2013 at 11:18 am

    #1614716

  • RE: Are the posted questions getting worse?

    So I'm thinking that this Workflow Logic for Kids is something I'd like to push to more than just our little community. Not only would it encourage children to explore...

    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.

    May 13, 2013 at 11:04 am

    #1614710

  • RE: Parsing a summary / detail flat file

    WayneS (5/13/2013)

    Brandie - just to verify... you are using SQL 2008? (I know you posted it in this forum, but we both know that folks sometimes make mistakes...)

    Yes, I am...

    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.

    May 13, 2013 at 10:58 am

    #1614704

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (5/13/2013)

    Brandie Tarvin (5/13/2013)

    Workflow Logic for Kids[/url]

    What do you think?

    Looks great to me! I'm so glad it worked so well. The little girl who wanted to do more 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.

    May 13, 2013 at 10:56 am

    #1614703

  • RE: Are the posted questions getting worse?

    Revenant (5/13/2013)

    Brandie Tarvin (5/13/2013)

    Workflow Logic for Kids[/url]

    What do you think?

    From the mouths of the babes: my 6 years old grandson loves it.

    What is he programming?

    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.

    May 13, 2013 at 10:55 am

    #1614700

  • RE: Parsing a summary / detail flat file

    Duh. Forgot there is a record 4 line which is the last line of the file. Anyway, sample data attached and CREATE TABLE code as follows:

    /****** Object: Table [dbo].[Detail]...

    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.

    May 13, 2013 at 10:08 am

    #1614676

  • RE: Parsing a summary / detail flat file

    Stefan Krzywicki (5/13/2013)

    Can you use SSIS?

    I've done something similar recently with SSIS, so if you can use it I think you have a good option.

    Yes, we can use SSIS. In...

    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.

    May 13, 2013 at 8:42 am

    #1614633

  • RE: Are the posted questions getting worse?

    Threadzians, I could use some help with my own personal RBAR horror story here. It's not that we want to do RBAR, but that we really don't seem 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.

    May 13, 2013 at 7:30 am

    #1614588

  • RE: Are the posted questions getting worse?

    Workflow Logic for Kids[/url]

    What do you think?

    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.

    May 13, 2013 at 4:04 am

    #1614534

Viewing 15 posts - 3,631 through 3,645 (of 9,722 total)