Update Table column using another server sequence value

• Sumathi

  Valued Member

  Points: 61

  More actions

  June 15, 2021 at 12:13 pm

  #3896448

  Hi,

  I have the below scenario

  SqlServer1

  Database1

  Table1

  Columns: Name(Varchar), Seq(int)

  SqlServer2

  Database2

  Sequence2

  I want SSIS to update the 'Seq' column in "Table1" from the next value in "Database2.Sequence2". How can I do this in SSIS. I currently have two OLE DB Sources, now im a little stuck on where to put an update command in there for Table1 with next sequence value?

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  June 16, 2021 at 1:10 pm

  #3896977

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.