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!
|
|
slx_DBIDS seen as char(13)??
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.
|
|
|
|
Re: slx_DBIDS seen as char(13)??
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? |
|
|
|
Re: slx_DBIDS seen as char(13)??
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. |
|
|
|