Forum Replies Created

Viewing 15 posts - 796 through 810 (of 948 total)

  • RE: Importing data reports data truncation in both EM and SSIS from multiple data sources

    'Thank you for your support'.  The luxury at my age is that it's OK to sound a bit out of touch, 'cause I don't have to interview for jobs any...

    Rick
    If you do a half-assed job of things, folks will ask 'why did this ass only do half the job?'

  • RE: Importing data reports data truncation in both EM and SSIS from multiple data sources

    Jeff Moden - Monday, October 23, 2017 10:15 PM

    skeleton567 - Monday, October 23, 2017 9:40 PM

    Rick
    If you do a half-assed job of things, folks will ask 'why did this ass only do half the job?'

  • RE: Importing data reports data truncation in both EM and SSIS from multiple data sources

    Well, I believe the Quicken .csv import problem is also solved.  The failure reported was 'String or binary data would be truncated'.
    By eliminating one column at a time, I...

    Rick
    If you do a half-assed job of things, folks will ask 'why did this ass only do half the job?'

  • RE: Identify the Column for 'String or binary data would be truncated'

    Well, the problem may be solved.  I switched from using SSMS Import Wizard to a single-step SSIS bulk insert and now the same data files, over 20 files of historical...

    Rick
    If you do a half-assed job of things, folks will ask 'why did this ass only do half the job?'

  • RE: Identify the Column for 'String or binary data would be truncated'

    OK, here's a good one.  I import my data into a table with all field defined as VARCHAR.  Then I INSERT into a second table with all columns defined as...

    Rick
    If you do a half-assed job of things, folks will ask 'why did this ass only do half the job?'

  • RE: error import flatfile to sql server

    For what it's worth, here's what I've found regarding the truncation errors:

    I have been trying to import two different types of data, my financial records exported to .CSV...

    Rick
    If you do a half-assed job of things, folks will ask 'why did this ass only do half the job?'

  • RE: error import flatfile to sql server

    For what it's worth, here's what I've found regarding the truncation errors:

    I have been trying to import two different types of data, my financial records exported to .CSV...

    Rick
    If you do a half-assed job of things, folks will ask 'why did this ass only do half the job?'

  • RE: Using Tools that Fit

    I'm a retired DBA who now spends time every day in my home office with my systems.  At present I have 4 desktops and 5 laptops in various states of...

    Rick
    If you do a half-assed job of things, folks will ask 'why did this ass only do half the job?'

  • RE: Appreciating New Perspectives

    These are some very good observations.  I have travelled Europe from France to Romania and Ukraine, and learned many of these same things on those trips.  Especially rewarding was when...

    Rick
    If you do a half-assed job of things, folks will ask 'why did this ass only do half the job?'

  • RE: Importing data reports data truncation in both EM and SSIS from multiple data sources

    drew.allen - Monday, August 28, 2017 3:02 PM

    Have you checked the end-of-record delimiter.  It could be LF, CR, or CR/LF.

    Drew

    Drew, I haven't...

    Rick
    If you do a half-assed job of things, folks will ask 'why did this ass only do half the job?'

  • RE: Importing data reports data truncation in both EM and SSIS from multiple data sources

    Sue_H - Monday, August 28, 2017 12:47 PM

    skeleton567 - Friday, August 25, 2017 11:42 AM

    Rick
    If you do a half-assed job of things, folks will ask 'why did this ass only do half the job?'

  • RE: Hiring Guitarists

    "Programmers and DBAs get paid a whole lot of money. I wish people would stop making excuses for the folks that put buzzwords on a resume but don't...

    Rick
    If you do a half-assed job of things, folks will ask 'why did this ass only do half the job?'

  • RE: Hiring Guitarists

    I always felt that it's not as important to know all the answers as it is to know and understand how to find them.  It's like art.  Lots of folks...

    Rick
    If you do a half-assed job of things, folks will ask 'why did this ass only do half the job?'

  • RE: Hiring Guitarists

    Only thing I don't agree with it this:  "If I insist on making poor choices, I want their support, but if they can influence me to do...

    Rick
    If you do a half-assed job of things, folks will ask 'why did this ass only do half the job?'

  • RE: Fuzzy Search

    William, thank you for your very nice work with the fuzzy search function.  I'm a 74-year-old retired DBA who now 'plays' nearly every day with SQL code working mainly on...

    Rick
    If you do a half-assed job of things, folks will ask 'why did this ass only do half the job?'

Viewing 15 posts - 796 through 810 (of 948 total)