Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xhizi
Starting Member
6 Posts |
 Posted - 2012-11-15 : 04:32:37
|
| Hi,I import the data of invoices from access to sql, but for new customers the data imported with errors in sql.for example:the invoice with noserial 55555555 is made for customer A,when i import this invoice in sql, it registered for customer B.How can i fix permanently this problem?thnx in advance! |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-15 : 08:51:59
|
| This is very much dependent on how you are doing the importing and any code that used by the import process to associate customers with invoices. How are you importing? Do you have visibility into any code used by the import process? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-11-15 : 10:19:47
|
| looks like issue with reference lookup for me. how are you doing the lookup? using t-sql or using ssis lookup task?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
The data mismatching for the new customers