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 Thread

View: Search:

Author

Thread: Data Flow for History import freezes

Erdem
Posts: 9

Data Flow for History import freezes Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Nov 08 3:20 PM

Hello,
I have an ssis package and it does a whole slew of things to import data from another server. Near the very end (like step 20) i have a dataflow to insert some history records for closed oppertunities. For some reason the insert freezes at "preparing Data" I cannot understand why it woud do this. The source information in my test is 3 records and the destination table has 850,000 records (indexed). In previous steps the package inserts 1000s of records in Account, Contact, and other tables without issue. For some reason when it gets to History it gives up.

Any help would be appreciated.

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Data Flow for History import freezes Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 13 Nov 08 8:55 PM

Are you using a script component to do this?

Consider creating a test package including only this component and then debugging line by line - if the process gets that far.

If you are not using a script component, how are you generating the IDs?

Cheers
Phil

[Reply][Quote]

Erdem
Posts: 9

Re: Data Flow for History import freezes Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Nov 08 12:13 PM

No, no script component. I do a selec and data flow into the slx table. Source is an SLQ connection and destination is an SLX ole db connection. Since i have the table to auto increment I do not have to worry about the ids (or at least i shoudn't).

The data pull happens in 0.003 secs. and it is importing into the history table with records totalling about 850,000 records.

[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 \|

page cache (param): 11/22/2024 4:50:08 AM