Forum Replies Created

Viewing 15 posts - 1,846 through 1,860 (of 3,666 total)

  • RE: Are the posted questions getting worse?

    Jeff Moden (9/8/2010)


    Withdrawn... it was just a little too racy...

    Too much bull? 😛



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Initialize variable through SQL statement

    Take a look at this: http://www.sqlis.com/post/The-Execute-SQL-Task.aspx



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Rename files with timestamp and move to archive folder

    Not sure what you mean when you say you cannot rename the file.

    When you copy the file, the file name in the destination should be the new name...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Script Task won't open

    kdbarrett (9/8/2010)


    Right, SQL Server 2008 R2, which runs VS 2008 with different options than "regular" VS 2008. So you can open SSIS projects, work on packages, etc., with VS...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: How to stop package from failing when a connection has an error?

    Have you taken a look at the MaximimErrorCount for both the Container and the Package?



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Script Task won't open

    kdbarrett (9/8/2010)


    Being able to create, edit, run, etc., SSIS packages in VS 2010.

    I don't know what MS has planned for that, but the way is works now, you install that...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: File System Task Expressions

    It looks like it's trying to find a variable with the name "\\Server\MyPath\Inbound\MyFile_20100901.zip"

    Did you happen to use the expression for the value of the variable where you should have used...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Alvin Ramard (9/8/2010)


    Paul White NZ (9/8/2010)


    WayneS (9/8/2010)


    How about a table where the PK is on a text datatype? (as are most of the other columns also!)

    I would speculate that the...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SQL Query

    Jan Van der Eecken (9/8/2010)


    LOL.

    I was just thinking, if the BookID is 2GB as well, then taking an average of 2.5mm for the width of a single character on a...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Paul White NZ (9/8/2010)


    WayneS (9/8/2010)


    How about a table where the PK is on a text datatype? (as are most of the other columns also!)

    I would speculate that the OP there...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    GilaMonster (9/8/2010)


    WayneS (9/8/2010)


    How about a table where the PK is on a text datatype? (as are most of the other columns also!)

    After a day full of stupidity, I'm just about...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: ORACLE Delete query not working properly

    Thanks for posting your solution. Others with a similar problem may be able to benefit from it.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Temp Holding of Query Results to Reference for Other Queries in SSIS

    maggie.blechinger (9/8/2010)


    ... Should I be using a recordset or variable to hold the list of patients, and IDs? ...

    The answer is yes.

    Your SQL Script will return a recordset that will...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Script Task won't open

    kdbarrett (9/8/2010)


    Thank you both for your responses, much appreciated!

    One question that arose in a meeting I just got out of was whether VS 2010 has support for SSIS. From...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Script Task won't open

    FYI, the break in SSIS package compatibility happened with SQL 2008. SQL 2005 packages must be upgrade for 2008; 2008 packages are not backwards compatible with 2005. SQL...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 15 posts - 1,846 through 1,860 (of 3,666 total)