Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Sunday, July 14, 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: slx_DBIDS seen as char(13)??
Patrick Sullivan
Posts: 13
 
slx_DBIDS seen as char(13)??Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 21 Jun 07 3:37 PM
So I ran into a minor issue. Here's the jist: I have all my data ready to get SLX IDs for account migration.

I created an OLE DB Source in a data flow task and the connection is a SLX OLE connection to our dev SLX Server. The SQL Command for the OLE DB Source is slx_DBIDs('ACCOUNT', ?) and i am passing in my parameter for row count in my mid tier account table.

When i first attempted this I thought no way it works but low and behold the OLE DB Source is seeing that I am getting a table back with the column named ID. I was like wow awesome easy. Then I realized it is seeing the Column as a char(13) instead of a char(12) for some reason. All my attempts to mess with the properties in the advanced editor are not doing what I thought they would so I am still trying to get this last issue resolved.

[Reply][Quote]
Ryan Farley
Posts: 2265
slxdeveloper.com Site Administrator
Top 10 forum poster: 2265 posts
 
Re: slx_DBIDS seen as char(13)??Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 21 Jun 07 3:49 PM
Don't believe I've ever had that happen for me. If you can dump the data returned by that somewhere and examine the data, what do you see?
[Reply][Quote]
Patrick Sullivan
Posts: 13
 
Re: slx_DBIDS seen as char(13)??Your last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 21 Jun 07 4:29 PM
I am attempting that now but apparently I have readonly permissions in the dev environment for this right now. I should know more on Monday. Seems strange to me as well.

I think i may have to just treat it like a char(13) in my mid tier area and trim the ids later.
[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): 7/14/2024 3:39:17 AM