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!
|
|
Import using SSIS into SLX v7
Posted: 04 Mar 07 8:37 PM
|
fiogf49gjkf0d Has any body got a working example on how to use SSIS (SQL 2005) to import data into SLX v7?
Thanks. |
|
|
|
Re: Import using SSIS into SLX v7
Posted: 05 Mar 07 9:58 AM
|
fiogf49gjkf0d Robby,
Right Click on the database you want to import to
Select All Tasks
Select Import Data
Supply Source and destination information as the Wiard instructs
Map your fields
Import  |
|
|
|
Re: Import using SSIS into SLX v7
Posted: 07 Mar 07 5:57 AM
|
fiogf49gjkf0d Maybe I am not as familiar with the Import Data functionality in 2005 as I should be, but doesn't import data just import data. Its not part of SSIS is it?
I though SSIS was for creating a job that can be run at intervals or on demand to perform a predefine set of steps to transform data from one system to another (SSIS replaced DTS).
Thanks,
John G. |
|
|
|
Re: Import using SSIS into SLX v7
Posted: 07 Mar 07 10:25 AM
|
fiogf49gjkf0d The Import Data wizard is a part of SSIS. Basically what the wizard does is create an SSIS package on the fly and runs it. You can have it save the package it built for you, then you can open it, edit the items in it, add to it, or even set up a schedule for it as well. |
|
|
|
Re: Import using SSIS into SLX v7
Posted: 07 Mar 07 4:01 PM
|
fiogf49gjkf0d Thanks! I haven't yet had an opportunity to use it and could only remember how 2000 did it. I think even that version allowed the saving of the import/export as well - but under DTS.
John G.
|
|
|
|
Re: Import using SSIS into SLX v7
Posted: 09 Mar 07 1:17 AM
|
fiogf49gjkf0d Yeah, DTS did the same (the wizard could save the package that you could open and edit). Really pretty cool and a quick way to get your base package started. |
|
|
|
Re: Import using SSIS into SLX v7
Posted: 28 Jun 07 9:25 AM
|
I've had nothing but trouble importing Accounts, Contact and Addresses using SISS in SQL Server 2007.
Originally I was using the SLX autoincrement feature so I did not have to generate the ID myself. However, SISS frequently falls over with memory issues despite having 6gb of RAM on the SQL Server and only attempting to import 100 records. It looks like it is simply a bug in the SLX OLEDB provider.
So, now I simply make the IDs up myself and import directly via the SQL Native Provider. This is not ideal and I can see this biting me on the backside in the future.
Has anyone else had these memory issues and managed to circumvent it? |
|
|
|
Re: Import using SSIS into SLX v7
Posted: 29 Jun 07 3:35 AM
|
Hi Guy
You might find it easier ond more effective to use a tool such as Inaport (from us), which combines powerful data integration capability with extensive SLX business logic.
Regards
David Evans
Inaport - Custeorm Data Integration
http://www.inaplex.com
|
|
|
|
Re: Import using SSIS into SLX v7
Posted: 29 Jun 07 4:01 PM
|
| I have been having headaches as well importing data through SSIS. I think I just made a bit of a breakthrough today in regards to generating the SLX DBIDs. I will post a new thread explaining how and what I am doing. |
|
|
|