Forum Replies Created

Viewing 15 posts - 916 through 930 (of 9,720 total)

  • RE: FTP Task question

    stevenb 14609 - Thursday, June 29, 2017 1:07 PM

    If you're asking what port you're connecting from, the answer is that your computer...

    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.

    June 30, 2017 at 5:18 am

    #1948907

  • RE: Using File System Task to partially delete directory contents

    Ed Wagner - Thursday, June 29, 2017 3:47 PM

    I think everyone on this thread knows that I don't know SSIS.  That said,...

    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.

    June 30, 2017 at 5:15 am

    #1948905

  • RE: Someone please help - SSIS - Get info from SQL server table about which particular files to load in target SQL server table

    I assume this happens during validation? If so, have you tried setting the expression and the task involved to Delay Validation TRUE (in the properties of each)?

    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.

    June 30, 2017 at 5:12 am

    #1948902

  • RE: Using File System Task to partially delete directory contents

    Lowell, I was trying to avoid the Loop. I just wanted a single task. But it seems like either I have to do a script task with several lines of...

    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.

    June 29, 2017 at 11:40 am

    #1948803

  • RE: Gender Analysis in SSIS/SQL using name

    I'm not sure there's a good why to figure out gender based on first name and title. There are a lot of names that are used for both binary genders...

    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.

    June 29, 2017 at 11:34 am

    #1948801

  • RE: Someone please help - SSIS - Get info from SQL server table about which particular files to load in target SQL server table

    Don't forget that your variable will probably need to be an object since you're using an object to populate it.

    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.

    June 29, 2017 at 11:32 am

    #1948799

  • RE: Getting the next future Friday

    J Livingston SQL - Thursday, June 29, 2017 6:35 AM

    from  https://stackoverflow.com/questions/18920393/sql-server-get-next-relative-day-of-week-next-monday-tuesday-wed

    DECLARE @NextDayID INT = 4 -- 0=Mon,...

    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.

    June 29, 2017 at 6:56 am

    #1948717

  • RE: Are the posted questions getting worse?

    Chris Harshman - Wednesday, June 28, 2017 2:53 PM

    Jeff Moden - Wednesday, June 28, 2017 6:55 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.

    June 29, 2017 at 4:14 am

    #1948693

  • RE: Are the posted questions getting worse?

    Jeff Moden - Wednesday, June 28, 2017 6:55 AM

    Brandie Tarvin - Wednesday, June 28, 2017 4:51 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.

    June 28, 2017 at 8:09 am

    #1948551

  • RE: Are the posted questions getting worse?

    Reasons to love working from home: Warm purry kitty that sits on my lap to de-stress me from the nonsense I see in my email.

    Reasons to hate working...

    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.

    June 28, 2017 at 4:53 am

    #1948527

  • RE: Are the posted questions getting worse?

    jonathan.crawford - Tuesday, June 27, 2017 9:01 AM

    Jeff Moden - Monday, June 26, 2017 6:44 PM

    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.

    June 28, 2017 at 4:51 am

    #1948526

  • RE: Are the posted questions getting worse?

    jasona.work - Monday, June 26, 2017 12:25 PM

    What does it say that when I see a response written to a topic by...

    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.

    June 28, 2017 at 4:49 am

    #1948525

  • RE: Using File System Task to partially delete directory contents

    I'm looking for an easier way to get out of this. Something that doesn't actually require a lot of code or multiple tasks / work arounds.

    Bleargh. Why does Microsoft...

    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.

    June 27, 2017 at 7:54 am

    #1948371

  • RE: Monitor job in SSIS package with T-SQL isn't working

    Phil Parkin - Thursday, June 22, 2017 8:03 AM

    Being able to execute a package in synchronous mode depends on the package...

    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.

    June 27, 2017 at 6:06 am

    #1948335

  • RE: Monitor job in SSIS package with T-SQL isn't working

    Phil Parkin - Thursday, June 22, 2017 7:29 AM

    Thom, I have not read your code in detail, but doesn't running a package...

    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.

    June 22, 2017 at 7:41 am

    #1947756

Viewing 15 posts - 916 through 930 (of 9,720 total)