Private Sub UpdateDB(ByVal Fieldname As String, ByVal TableName As String, ByVal NewVal As String, ByVal Where As String)
    Dim strSQL As String, modified As Boolean
    'Build the select SQL string to bring back the records to be updated
    strSQL = "Select * from " & TableName
    If Not (Where Is Nothing Or Where = String.Empty) Then
      strSQL = strSQL & " Where " & Where
    End If

    Dim adpSLX As OleDbDataAdapter = New OleDbDataAdapter(strSQL, objSLXConn)
    Dim ds As DataSet = New DataSet
    '    Dim row As DataRow

    Try
      modified = False
      adpSLX.Fill(ds)
      For Each row As DataRow In ds.Tables(0).Rows
        UpdateIfDifferentString(row, Fieldname, NewVal)
        If row.RowState = DataRowState.Modified Then
          modified = True
          row("Modifydate") = Now
          row("Modifyuser") = "ADMIN"
        End If
      Next

      ' Declare a command builder to create SQL instructions
      ' to create and update records.
      If modified Then
        Dim cb As New OleDbCommandBuilder(adpSLX)
        adpSLX.Update(ds.GetChanges)
      End If

    Catch ex As Exception
      ' Write out an error, with the exception generating target site
      ' and the exception message
      Dts.Events.FireError(1, ex.TargetSite.ToString(), ex.Message, "", 0)

      ' Always execute this code and return gracefully.
      ' Never return with an exception from script tasks.
      Dts.TaskResult = Dts.Results.Failure
    Finally
      adpSLX.Dispose()
      adpSLX = Nothing
    End Try

  End Sub

Just wondering if you ever got SSIS to work using the pure functionality of SSIS with the SLX OLE DB provider. I have managed to get several different configurations to generate several different error messages.

I didn't, though I haven't tried for a while.

It would be excellent if we could find a way!

I never got it to work either. I eventually gave up and used the DTS2000 control within SSIS to do a data driven query. Not the ideal way at all but it works. I am hoping that maybe when next version of Saleslogix is released they fix this issue.

I never got it to work either. I eventually gave up and used the DTS2000 control within SSIS to do a data driven query. Not the ideal way at all but it works. I am hoping that maybe when next version of Saleslogix is released they fix this issue.

Quote: Originally posted by Martin Wickens I am going through the process of moving all of our DTS packages to our new company format of SSIS. We have a lot of packages that are using data driven queries with the saleslogix adaptor so that the data will sync out to our remote users. I am trying to use the OLE DB Command object to replicate this process in SSIS and am getting errors returned of "Error: 0xC0202009 at Data Flow Task, OLE DB Command [34]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8000FFFF. " for each line to be updated. The really strange thing is that the data within the database is being updated. Is there any setting that I am missing or is there a better way of doing these updates? Thanks Martin

No solution for me, except manual scripting in VBS files...
Francois

Actually did get this to work. Thought I would mention one trick with SSIS. When editting the data flow rioght click the SLXOLEDB item and choose advanced edit. Under component properties set AlwaysUseDefaultCodePage to True and it works like a charm.

Awesome! Just got a bunch of our stuff to work using this trick.

THANKS!