Post reply

SSIS SQL 2016 failing to import date value into a timestamp column!

  • September 6, 2019 at 12:34 pm

    #3677940

    Thom A wrote:

    Jeff Moden wrote:

    Why do you have to write all the script components?  I thought SSIS was supposed to make it so you basically wouldn't have to write anything.

    I don't know if it's "supposed" to Jeff, but the truth is far from that. I have plenty of Script tasks and Components in my projects.

    Heh... my apologies, Thom and Jeff W.  I know better than what I wrote and that you're absolutely correct, Thom.  I just forgot to indicate that I was being a bit sarcastic and that sarcasm isn't directed at anyone in particular even though it landed as a reply to Jeff W's post.  It was due simply to a massive bad taste in my mouth about SSIS and the things I've seen people have to go through to migrate to new servers including the stages from the Dev to Test to Production boxes.  I was also reminiscing about a good friend that had hired an SSIS consultant to assist with the migrations and he gave up on the task.  Really left my friend in a lurch.

    So, please ignore me... just having a bad dream. 😀

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing post 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply