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: Import using SSIS Newbie
Scott Burnett
Posts: 5
 
Import using SSIS NewbieYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 13 Jan 14 6:26 AM

Hi All,


We currently use Scribe to complete inserts of data into our Accounts table in Saleslogix v7.2.


We are currently looking to move to SLX 8 and using Leads.


i have been scouring through these posts and there are various ways of completing this, some say there are more complicated ways than others.


Obviously time is of the essence.


Could someone please point me in the direction of a post that helps, with the use of SLXDBIDs, to create multiple ids to insert multiple Leads at once using SSIS?


Kind Regards

[Reply][Quote]
Vaughn Poulson
Posts: 32
 
Re: Import using SSIS NewbieYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 14 Jan 14 8:55 AM

The only way i've been able to do this is using a Script Component Transfor one row at a time to get the ids.  Below is an example of what i do importing products from our ERP system.  


I get one id for the product table and three id's for the productprogram.  Before i get to the script component i use a derived column transform to add the id columns to each row. After i have the ids i then use an OLE DB Destination to insert into the slx db.


 


    public override void Input0_ProcessInputRow(Input0Buffer Row)


    {


        //create connection


        using (OleDbConnection conn = new OleDbConnection("Provider=SLXOLEDB.1ersist Security Info=Trueassword=passwordUser ID=admin;Initial Catalog=slxDB;Data Source=slxServer;"))


        {


            conn.Open();


            //get product id


            using (OleDbCommand cmd = new OleDbCommand(String.Format("slx_DBIDs('{0}', {1})", "PRODUCT", 1), conn))


            {


                Row.PRODUCTID = cmd.ExecuteScalar().ToString();


            }


            //get program ids?


            using (OleDbCommand cmd = new OleDbCommand(String.Format("slx_DBIDs('{0}', {1})", "PRODUCTPROGRAM", 3), conn))


            {


                using (OleDbDataReader dr = cmd.ExecuteReader())


                {


                    List<string> programIds = new List<string>();


                    while (dr.Read())


                    {


                        programIds.Add(dr[0].ToString());


                    }


 


                    Row.RetailId = programIds[0];


                    Row.MSRPId = programIds[1];


                    Row.WholeSaleId = programIds[2];


                }


            }


        }


    }

[Reply][Quote]
Scott Burnett
Posts: 5
 
Re: Import using SSIS NewbieYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 14 Jan 14 9:03 AM

Thanks for the reply.


I have found the way to complete this using SSIS, using connection managers to the SLX provider and the auto increment feature.


My issue i think initially was actually down to the server we have being 64 bit.


As soon as changed the runtime to be false.


success.

[Reply][Quote]
Brian Segers
Posts: 69
 
Re: Import using SSIS NewbieYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 14 Jan 14 9:07 AM

I know you found a solution but I am curious why you would not use Scribe for leads if you use scribe for Accounts?

[Reply][Quote]
Scott Burnett
Posts: 5
 
Re: Import using SSIS NewbieYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 14 Jan 14 9:13 AM

You can use the import functionality in saleslogix to import leads which would be the first way to go without scribe.


However due to various sources of data for our system, ssis is the better way to complete this.


Accounts is how our data was imerported in version 7.2 and scribe was all in place for this.


Now we are moving on with v8 we are looking to use leads properly.


Kind Regards

[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 9:06:48 PM