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: SSIS on SQL 2012 - Import Products
Vaughn Poulson
Posts: 32
SSIS on SQL 2012 - Import ProductsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 20 Aug 13 2:06 PM

I'm upgrading an SSIS package that was built on sql 2005 to sql 2012 and am having issues getting a connection to saleslogix.  

If there is any way to get the new productid in the ssis without having to use a script, that would be ideal.  If not then how do you aquire a connection to slx in the script?

I've tried everything i can think of and nothing is working.  Currently the only way i can get the connection is to hard code the connection string inside the script.  

John H. Hedges
Posts: 62
Re: SSIS on SQL 2012 - Import ProductsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 21 Aug 13 2:52 AM

You're not giving us quite enough information here - the main thing being what version of SalesLogix this is. If you're upgrading a package from SQL 2005, then I doubt you're dealing with SalesLogix 8.x, but if you're using SQL 2012 on anything less than SalesLogix 8.x you're probably not going to get it to work, period. As for the script code, I assume you've tried the standard way of doing it from SQL 2005-2008, i.e., casting:

Dim SLXConnection As System.Data.OleDb.OleDbConnection
SLXConnection = CType(Connections.SalesLogix.AcquireConnection(Nothing), System.Data.OleDb.OleDbConnection)

...where the "SalesLogix" connection in the ScriptTask component uses the SLX provider listed under "OLEDB wrappers for ADO.NET," not the native OLEDB driver? Or is that not even available?

Also, when you say you want the "new productid," does that mean you want to create a new PRODUCT record for which you need to generate a new ID, or are you just looking to read new PRODUCT records as they come in from some other source?

Lastly, you should be able to get the same effect as hard-coding the connection string by storing the connection string in an object-level variable and then reading that variable into your script from a secured configuration file. It's a perfectly valid way to do it... whatever works!

Vaughn Poulson
Posts: 32
Re: SSIS on SQL 2012 - Import ProductsYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 21 Aug 13 9:48 AM


Thanks for this tips.  I am on SLX 7.5.2, but we are planning on upgrading within the next six months.  Hopefully after that i'll be able to have a more elegant solution.  I'll give you suggestions a go and see what i can do.  I'm reading inventory items out of our accounting system and creating new product records in saleslogix if they don't already exists and updating if they do exist.  I'll also have to create new product program records as well.  

I'm using C# and translated your code to the following:

<p>OleDbConnection slxConn = new OleDbConnection();


slxConn = Connections.slxOleDbConnection.AcquireConnection(null) as OleDbConnection;


and the slxConn is null. For now i'll just put the connection string in a variable.


Thanks again.



 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 10:15:16 PM