Forum Replies Created

Viewing 15 posts - 1 through 15 (of 16 total)

  • Reply To: SSIS and Excel - 'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.'

    So I had this issue. Reading and writing with Excel was working fine until MS Office got completely removed from my work laptop, because we now use Google Workspace. It...

  • Reply To: ANSWERED - Flat file problem - input column is 1252 and is required to be 65001

    My issue was that I had a flat file input, doing a lookup against a database, and my matched and unmatched output files were giving this complaint. I had changed...

  • RE: TRY_CONVERT smaller

    I got an error.

    Msg 195, Level 15, State 10, Line 1

    'VARCHAR' is not a recognized built-in function name.

  • RE: Insert without a PK

    I used my Magic 8 Ball and it wasn't anywhere near as helpful.

  • RE: Insert without a PK

    I'm confused. When I ran these scripts, I got one row inserted and the second insert threw an error caused by a duplicate key.

  • RE: Legal/illegal characters in table name

    free_mascot (4/8/2015)


    Carlo Romagnano (4/8/2015)


    MyDoggieJessie (4/7/2015)


    This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

    +1

    Ahi, ahi, ahi, ahi, ahi, ahi!!!!!!!!!!

    :w00t:

    +1...

  • RE: Summit 2014

    I'm in the Seattle area and am sorry not to be at the Summit. Have a good time!

  • RE: Create a stored procedure

    Me three... or four... or however many people have already responded...

  • RE: While loop Testing

    I got a different error than was indicated,

    Msg 102, Level 15, State 1, Line 1289

    Incorrect syntax near 'END'.

    But when I reduced @intMaxLoop from 162 to 161, it worked....

  • RE: The Next Generation

    Joe Garrick (8/15/2014)


    djackson 22568 (8/15/2014)


    Joe Garrick (8/15/2014)


    rshaw 91433 (8/15/2014)


    It would be nice if more kids were exposed to what an IT career really is.

    I've often wondered if other fields have...

  • RE: The Next Generation

    wwallace-848999 (8/15/2014)


    I remember going to Cal Poly and finding out that the Computer Science major was impacted back in the 80's, and the counselor said why not try Math? I...

  • RE: The Next Generation

    The worst career move I ever made was to support a legacy system. I supported it for three years, during which time I learned all about its obsolete technology and...

  • RE: The Next Generation

    I'm kind of the opposite from some of the people Steve has met, who studied other things before choosing a computer career. I knew I wanted to work in computers...

  • RE: WMI Alerts

    I too was frustrated by the radio buttons, so I selected namespace and got it wrong. Sigh.

  • RE: What was that field name?

    This didn't work for me right away, but I checked the Edit/IntelliSense menu, and turned on the List Members function with Ctrl+J, and then it worked.

Viewing 15 posts - 1 through 15 (of 16 total)