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)
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.