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

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];

                }

            }

        }

    }

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.

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

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