Forum Replies Created

Viewing 15 posts - 8,881 through 8,895 (of 9,720 total)

  • RE: Table valued functions, common table expressions and SSIS in SQL Server 2005

    BTW, BOL has this to say about Table Valued Functions:

    Books Online:

    Specifies that the return value of the table-valued function is a table. Only constants and @local_variables can be passed 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: Table valued functions, common table expressions and SSIS in SQL Server 2005

    I'll look at the proc in a moment, but in regards to getting your table valued function to run in SSIS, what T-SQL do you use to get it 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: Send Mail Task

    Does it look like a Connection Manager issue?

    If so, go to connections. Choose New Connection->SMTP (Connection Manager for the Send Mail Task). A popup box will 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: Dear friends

    Please give us an example of the data from each of the tables and the conditions you're trying to pull the data together with. It's hard to answer 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.

  • RE: Derived Column Task Failure on Expression

    Michael,

    You're BRILLIANT!!

    It took me a little more work at first, but given the way the task is executing right now, I really really like your multiple conditional split idea.

    I've got...

    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: Derived Column Task Failure on Expression

    BTW, I should add that I just got a look at the other developer's package and he has everything set to "Ignore Failure" on his package so he doesn't 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: Derived Column Task Failure on Expression

    Michael,

    As much as I would love to do as you've just listed, I can't. I have things in my data such as FirstName of "Ace Insurance" and LastName 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.

  • RE: DTA Stopped unexpectedly

    I have four servers, all of which have the same problem. It's not a server issue as far as I can tell.

    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: DTA Stopped unexpectedly

    Did yours get installed properly to begin with or did you have to manually install it like I did?

    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: DTA Stopped unexpectedly

    I have never figured out what the problem was. Even posted on Microsoft and got a lukewarm response. THough someone suggested the issue had to do with Temp...

    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: Help with create linked server

    Linda,

    Don't answer this on the forum but...What ports are you using for your cluster? Have you checked with the network people to make sure that those are the ports...

    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: Help with create linked server

    Linda,

    I don't think the issue is in Cluster Administrator.

    When the error message talks about Virtual name verses Computer name, there is a distinction. If the servers are literally named...

    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: I got burned today at a SQL Server Interview!

    HEEEEHEEEEHEEEHEEE. ROTFLOL!

    MAAAAAAATTTTTT!!!!

    I'm supposed to be working on serious ETL stuff today! You're not allowed to make me laugh so hard that my boss glares at me from across 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: I got burned today at a SQL Server Interview!

    Grant said:

    Whoa! Hold on. Revelation! People who come out of college are mature adults?

    "Mature" is always a matter of definition. @=)

    But, speaking as someone who used to work at...

    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: I got burned today at a SQL Server Interview!

    Jeff said:

    I don't care who you are, ya gotta laugh at that!

    Gotta laugh?? Says who?

    Perhaps I prefer to chuckle or snort instead. (neener)

    @=)

    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 - 8,881 through 8,895 (of 9,720 total)