Forum Replies Created

Viewing 15 posts - 1,726 through 1,740 (of 3,666 total)

  • RE: Automate converting xml to excel

    smacumber 77733 (9/21/2010)


    Yes I am, what would be the script then to write?

    Thx

    Phil, which do you prefer, hourly rate, or contract price?

    🙂



    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: ForEach Loop File Count

    Phil Parkin (9/21/2010)


    I would use a variable that is assigned from the result of an EXECUTE SQL task along the lines of:

    select count(*) from ImportTable

    and then use precedence constraints (=...



    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: Migrating SSIS Packages to Production

    Does your configuration include the connections, or just variables?



    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: ForEach Loop File Count

    I would use a variable that I update using a Script Task.



    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: run .cmd file from SSIS but on another server (not a sql server)

    I've done that successfully by using PsExec.

    http://technet.microsoft.com/en-us/sysinternals/bb896649.aspx

    Edit: removed typo



    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?

    Chris Morris-439714 (9/21/2010)


    CirquedeSQLeil (9/21/2010)


    Alvin Ramard (9/21/2010)


    CirquedeSQLeil (9/21/2010)


    So T-time is at 4? Sounds good to me:cool:

    Is it ok if I have coffee instead of tea? 😎

    My powers of divination...



    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: Package Configurations

    dtexec has a parameter for specifying the config file to use. Shouldn't that solve your problem?

    From http://msdn.microsoft.com/en-us/library/ms162810.aspx

    /Conf[igFile]filespec

    (Optional). Specifies a configuration file to extract values from. Using this option, you...



    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?

    CirquedeSQLeil (9/21/2010)


    So T-time is at 4? Sounds good to me:cool:

    Is it ok if I have coffee instead of tea? 😎



    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?

    jcrawf02 (9/21/2010)


    Alvin Ramard (9/21/2010)


    Chris Morris-439714 (9/21/2010)


    khanameerkhan (9/20/2010)


    Is there any way to determine who deleted the database in sql server 2008.

    Look under tables and in cupboards for one of these :blush:

    Isn't...



    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?

    Chris Morris-439714 (9/21/2010)


    khanameerkhan (9/20/2010)


    Is there any way to determine who deleted the database in sql server 2008.

    Look under tables and in cupboards for one of these :blush:

    Isn't there a system...



    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/21/2010)


    Alvin Ramard (9/21/2010)


    Kit G (9/21/2010)


    Admittedly, with date formats, text files have a bit of the same problem, you have to figure out what format the date has been put...



    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?

    Kit G (9/21/2010)


    Alvin Ramard (9/21/2010)


    Greg Edwards-268690 (9/21/2010)


    jcrawf02 (9/21/2010)


    Finally! The perfect database tool! :w00t:

    http://spreadsheets.about.com/od/datamanagementinexcel/ss/080608_database.htm

    Excel can do anyhing, even word processing! 😛

    It's kind of like I can record a macro, so...



    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?

    Greg Edwards-268690 (9/21/2010)


    jcrawf02 (9/21/2010)


    Finally! The perfect database tool! :w00t:

    http://spreadsheets.about.com/od/datamanagementinexcel/ss/080608_database.htm

    Excel can do anyhing, even word processing! 😛

    It's kind of like I can record a macro, so I can repeat anything.

    Greg...



    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: Put logic inside Execute SQL Task or call sproc?

    da-zero (9/20/2010)


    In our environment they are against using stored procedures, for the simple reason that if you deploy your SSIS packages, you could forget to deploy your stored procedures. And...



    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: Put logic inside Execute SQL Task or call sproc?

    Jeff Moden (9/19/2010)


    Craig Farrell (9/19/2010)


    My preference has, and almost always will be, SPROC if there's logic involved if I can get away with it. Primarily so that I only...



    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,726 through 1,740 (of 3,666 total)