Forum Replies Created

Viewing 13 posts - 1 through 13 (of 13 total)

  • Reply To: SSIS Excel Import Error

    I'm sorry if I'm missing or repeating anything, but I'm trying to help, but short on time, so only skimmed the messages.

    SSIS does not like spaces in worksheet names.  When...

  • RE: Merry Christmas

    Thanks Jeff. I somehow overlooked the link the first time. Definitely a good article to store in my "Cool Stuff" folder even though the feature isn't as good as...

  • RE: Merry Christmas

    Thanks. One more quick question, is there a document any where with the colors used and the order when adding polygons, or does everyone just play with it in...

  • RE: Merry Christmas

    Thanks! That is nice. I understand polygons with geometry, but can you please explain how you set the colors? Also, did you add the FROM sys.messages simply...

  • RE: Issue with 12/30/1899 in flat file import in SSIS ..

    Koen Verbeeck (6/30/2014)


    annjunk (6/30/2014)


    I know this is an old topic, but this seems to be a known "feature" with flat files with empty strings going into a SQL table in...

  • RE: Issue with 12/30/1899 in flat file import in SSIS ..

    I know this is an old topic, but this seems to be a known "feature" with flat files with empty strings going into a SQL table in SSIS.

    The work around...

  • RE: Report Builder or Reporting Services?

    Mohamed IDTTALBE (5/31/2014)


    Hi Andy

    Very good article but you can't compare 2 Tools that is for different user skill's level 🙂

    I think in Report Builder you can not add references when...

  • RE: Report Builder or Reporting Services?

    Good article and I agree with most of it.

    As a trainer, I have found that even with my business users (not developers), once they have taught how to use Report...

  • RE: Can a Table Really Have a Clustered Index?

    Robert Davis (12/25/2012)


    colin.s.allen (12/25/2012)


    ... another time this happens is when you have Enterprise edition and have concurrent scans running, the second scan will piggy back on the first scan then...

  • RE: Can a Table Really Have a Clustered Index?

    Mr. hoek (12/24/2012)


    But why does the table allocation 'double' when adding a clustered index?

    The only explanation I can think of, is that SQL server has the information 'twice' in the...

  • RE: Can a Table Really Have a Clustered Index?

    I wonder if this over simplification will end up confusing people more in the end. Both clustered and non-clustered indexes have what are called non-leaf-level pages that can help...

  • RE: Can a Table Really Have a Clustered Index?

    patrickmcginnis59 (12/24/2012)


    Let's assume there is no clustered index on this table. This makes it a heap, meaning the rows are not physically written to disk in any particular order. When...

  • RE: Output of Query

    I wanted a non of the above answer since the single quotes would not print out.

Viewing 13 posts - 1 through 13 (of 13 total)