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: Using SSIS To create new SLX Records (7.0.1, .NET 2) - TEF generation
Phil Parkin
Posts: 819
Top 10 forum poster: 819 posts
 
Using SSIS To create new SLX Records (7.0.1, .NET 2) - TEF generationYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 01 Aug 07 11:00 PM
OK, after a pretty steep learning process and trying to remember my VB.NET and get to grips with SSIS at the same time, I have written several routines that work together to bring in external data and update an SLX database.

However, I have a concern (and a fellow developer has suggested there is reason for the concern, in his experience) that the .NET stuff might not always generate appropriate TEFs - possibly as a result of the extra flexibility and power that is afforded by this environment. Does anyone have any comments? I am, of course, connecting to SLX via the SLX OLEDB Provider.

Cheers
PP
[Reply][Quote]
Ryan Farley
Posts: 2265
slxdeveloper.com Site Administrator
Top 10 forum poster: 2265 posts
 
Re: Using SSIS To create new SLX Records (7.0.1, .NET 2) - TEF generationYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 02 Aug 07 1:09 AM
Why the concern that TEFs won't be created? Any reason for the concern? If you're connecting via the SLX provider then you should expect that TEFs will be created.
[Reply][Quote]
Phil Parkin
Posts: 819
Top 10 forum poster: 819 posts
 
Re: Using SSIS To create new SLX Records (7.0.1, .NET 2) - TEF generationYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 02 Aug 07 1:25 AM
Hi Ryan

My colleague described the OleDbDataAdapter as "not terribly reliable" - functionality great, but not always generating TEFs.

This is his exact statement:
"Maybe it's just my code, but if it got too complex it wouldn't create the TEF files for remotes."

So I haven't got anything specific for you. But I thought I'd throw it out there to see whether anything's been encountered by you guys in the field. If not, maybe it is just his code - and everyone (except him) is happy

Cheers
PP
[Reply][Quote]
Ryan Farley
Posts: 2265
slxdeveloper.com Site Administrator
Top 10 forum poster: 2265 posts
 
Re: Using SSIS To create new SLX Records (7.0.1, .NET 2) - TEF generationYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 02 Aug 07 4:10 PM
The OleDbAdapter is completely reliable, so yes, it would be your colleague's code that was the problem.

There are some things that would cause SLX data to not sync, incorrectly formatted dates, etc. None of these causes are tied back to the fact that you used .NET, or SSIS to update/insert the data.

I use .NET for about every SLX project I do for one thing or another. All my data syncs fine
[Reply][Quote]
Phil Parkin
Posts: 819
Top 10 forum poster: 819 posts
 
Re: Using SSIS To create new SLX Records (7.0.1, .NET 2) - TEF generationYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 02 Aug 07 9:38 PM
Great feedback as always, thanks Ryan.
[Reply][Quote]
Phil Parkin
Posts: 819
Top 10 forum poster: 819 posts
 
Re: Using SSIS To create new SLX Records (7.0.1, .NET 2) - TEF generationYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 02 Aug 07 10:58 PM
Just to tie this up - I have run your comments past my colleague and he confirmed that he thinks it was a problem with dates and not using the correct datatypes.
[Reply][Quote]
Timmus Agersea
Posts: 328
 
Re: Using SSIS To create new SLX Records (7.0.1, .NET 2) - TEF generationYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 03 Aug 07 2:35 PM
Here is an explanation of the issue:

http://www.slxdeveloper.com/forum.aspx?forumid=2002&postid=30

Timmus
[Reply][Quote]
Ryan Farley
Posts: 2265
slxdeveloper.com Site Administrator
Top 10 forum poster: 2265 posts
 
Re: Using SSIS To create new SLX Records (7.0.1, .NET 2) - TEF generationYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 03 Aug 07 2:38 PM
Quote:
Originally posted by Timmus Agersea

Here is an explanation of the issue:

http://www.slxdeveloper.com/forum.aspx?forumid=2002&postid=30

Timmus


Thanks Timmus, I forgot you had posted this here.
[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:59:52 PM