Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Monday, June 24, 2024 
 
slxdeveloper.com Community Forums  
   
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
 Data & Imports Forums - SSIS/DTS
Forum to discuss using SQL SSIS or DTS to perform SalesLogix imports. View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to SSIS/DTS | New ThreadView:  Search:  
 Author  Thread: Help.. Need faster record update
Erdem
Posts: 9
 
Help.. Need faster record updateYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 11 Nov 08 10:11 AM
Does anyone have any ideas as to how i can update 1000s of recodes through SSIS in SLX. Looping with a data reader is extremely slow. I am updating based on a record set in another database.

I have a script task doing the following but it is rediculously slow

Dim conn As New OleDbConnection(Dts.Connections.Item("SLX").ConnectionString)
Try

conn.Open()
Dim cmd As New OleDbCommand("select something from somewhere join on something", conn)
Dim reader As OleDbDataReader = cmd.ExecuteReader()
Dim sql As String
While reader.Read()
Try
sql = "update something"
Dim cmd2 As New OleDbCommand(sql, conn)
cmd2.ExecuteNonQuery()
Catch ex As Exception
MsgBox("An error occurred: " & ex.Message, MsgBoxStyle.Exclamation)
End Try

End While
reader.Close()

Catch ex As Exception
MsgBox("Error: " & ex.Message, MsgBoxStyle.Exclamation)
Finally
conn.Dispose()
conn = Nothing
End Try
[Reply][Quote]
Phil Parkin
Posts: 819
Top 10 forum poster: 819 posts
 
Re: Help.. Need faster record updateYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 11 Nov 08 11:04 PM
Use an OleDBDataAdaptor, do the updates in memory and then post them to disk in batches rather than one at a time.

Phil
[Reply][Quote]
Erdem
Posts: 9
 
Re: Help.. Need faster record updateYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 12 Nov 08 1:26 PM
I tried to implement your suggestion but SSIS keeps complaining that i need to implement system.xml (which i already am). Any suggestions?
[Reply][Quote]
Phil Parkin
Posts: 819
Top 10 forum poster: 819 posts
 
Re: Help.. Need faster record updateYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 13 Nov 08 2:32 AM
Perhaps a reference is missing - merely adding an 'implements' line does not drag in references. If you've tried this, please post the exact error message and I will try to help you again when I have my work PC in front of me.

Phil
[Reply][Quote]
Erdem
Posts: 9
 
Re: Help.. Need faster record updateYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 13 Nov 08 10:08 AM
I fixed it. I was had an imprts statement but in the references there was nothing there.
[Reply][Quote]
 Page 1 of 1 
  You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

   Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 6/24/2024 8:34:39 PM