Forum Replies Created

Viewing 15 posts - 841 through 855 (of 3,666 total)

  • RE: Identity Field Fluctuations

    m_swetz (3/10/2015)


    OK, got a strange problem for which resolution has been eluding me.

    I have an SSIS package that loads multiple electronic data interchange files via a ForEach Loop. 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: How to Remove Special Characters except Space

    Phil Parkin (3/9/2015)


    A CLR TVF is the fastest and best, in my opinion. Is that an option for you?

    Using RegEx might be the quickest way to identify and remove these...



    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: Dynamically calling child SSIS packages within a project

    I recently did this but I don't have the details in from of me.

    If I remember correctly, in the Execute Package task expressions, look for Package Name. Set that to...



    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: Your Tools

    Eric M Russell (3/9/2015)


    I wish that Microsoft would put a bit more development into the SSMS Database Diagrammer tool. It's OK, for basic modeling, but it's limitations quickly become apparent...



    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: Your Tools

    Andrew..Peterson (3/9/2015)


    Alvin Ramard (2/19/2015)


    This editorial came on an interesting day.

    A few hours ago I decided I need to get my hand on a cheaper option to Erwin or DB Artisan....



    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: SSIS Checking Header Row from a .csv file

    ericwenger1 (3/5/2015)


    I need to be able to see if the incoming csv file had a head row different than the previous files header row. That will tell me that I...



    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: Downgrade SCOM Database

    hcip.77 (3/4/2015)


    First why you need to go back with SQL 2012 standard from SQL 2012 Enterprise.

    ...

    Licensing cost is the first reason I see that might explain why a manager...



    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: Dimension Members showing Empty in Excel

    Since reprocessing seems to fix your problem, the first thing I would check for is steps that are sometimes are not getting executed during your update process.



    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: EXCEL HELL!!!

    Jeff Moden (3/3/2015)


    Matt Miller (#4) (3/3/2015)


    By the way - there are several examples already documented. This one's a fairly solid example (describing a similar process)

    http://www.mssqltips.com/sqlservertip/1761/how-to-use-the-unpivot-data-flow-transform-in-sql-server-integration-services-ssis/%5B/url%5D

    That said - you're...



    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: Generate pdf

    Would this help?

    http://www.sqlservercentral.com/articles/Miscellaneous/creatingapdffromastoredprocedure/1104/



    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: bug report: select distinct isn't quite always

    Have you looked at the possibility that some of the data might contain unprintable characters, like CR, LF, TAB, etc.

    These can make the data look identical to the human eye,...



    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: SSIS Expression on getting the specific files

    I would use a variable to hold the name of the directory you want to copy the files to.

    I would use a script task to set the correct value of...



    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: Your Tools

    Steve Jones - SSC Editor (2/19/2015)


    Alvin Ramard (2/19/2015)


    This editorial came on an interesting day.

    A few hours ago I decided I need to get my hand on a cheaper option to...



    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: Share your best possible answers--

    abhisecks (2/19/2015)


    Tell me about your experience as a SSIS developer?

    I answered-SSIS is nothing but an ETL tool ...

    WRONG!

    SISS can do a lot more than just ETL!



    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: @@ServerName shows different value

    Select @@Servername shows the instance you are connected to, not the default instance.



    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 - 841 through 855 (of 3,666 total)