Home › Forums › Power Update › Varchar(max) default?

This topic contains 2 replies, has 2 voices, and was last updated by  kellandanielson 8 years, 6 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • October 15, 2015 at 3:49 am #2082

    kellandanielson
    Participant
    • Started: 4
    • Replies: 5
    • Total: 9

    Is there anything I can do to force a varchar(255) load from power update to SQL server? The load is defaulting to max characters which is causing problems in creating views. I’m looking to remove an SSIS manual load step to configure any field additions.

    Does that makes sense? Thx Charles!

    kellan

    October 15, 2015 at 6:53 am #2085

    Charles
    Moderator
    • Started: 2
    • Replies: 34
    • Total: 36

    You can create the table in SQL and set up the desired column data types and disable the Re Create option in Power SQL Update (columns are then matched based upon name).

    October 15, 2015 at 3:30 pm #2096

    kellandanielson
    Participant
    • Started: 4
    • Replies: 5
    • Total: 9

    Thanks Charles for confirmation. This is what I am doing today. I’ll look for easier ways in my process. Thanks!

    kellan

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)

The forum ‘Power Update’ is closed to new topics and replies.