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!
|
|
Using SSIS To create new SLX Records (7.0.1, .NET 2) - TEF generation
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 |
|
|
| |
|
Re: Using SSIS To create new SLX Records (7.0.1, .NET 2) - TEF generation
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 |
|
|
|
Re: Using SSIS To create new SLX Records (7.0.1, .NET 2) - TEF generation
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  |
|
|
| |
| |
| |
| |
|