Hi, I've been trying out RMS for a few weeks and have figured out a lot of things through the help of this community. However, I haven't been able to figure out how to import an Alias. I'm using the MS SQL Data Import utility and for some reason I get an error message whenever I try to open the Alias table. Any help in this matter would be greatly appreciated.
Kwang Lee
Kwang, I found the QSCImp utility on CustomerSource or other sites to be very helpful in regards to updating the Alias in particular.
In SO Administrator, I can query Alias as simply as Select * from Alias. So, I don't think you're having a problem there.
However, in using MSSQL Data Import, I used to error out if I didn't properly line up the Key Fields. ItemID to ItemID, or whatever column/index you are relying on, and what columns aren't getting updated.
Make a backup of your data first, then check your update/insert settings on the last tab of the MSSQL DI wizard.
Thanks for the quick reply. I can access and query Alias in SO Administrator also. But the exact error message I get is:
Unlcosed quotation mark before the character string '[Alias] where 1=0'
So, I'm wondering if I need to change something somewhere else to fix this problem.
Kwang Lee
"Fisher" wrote:
Why does the Alias table have the brackets around it?
Kwang Lee
"Fisher" wrote:
Because it's an SQL keyword. The brackets tell SQL to treat it as an object (table, column, etc)
Have something to add? Share your thoughts — no account required.
Ask the community — no account required