Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

从Access同步数据到SQL,出现以下错误，谢谢

2 views
Skip to first unread message

dkw...@newsgroup.nospam

unread,
Oct 21, 2009, 11:04:07 PM10/21/09
to
������Ϣ��
ִ���û�: SERVERCW\SYSTEM��DTSRun: ����װ��... DTSRun: ����ִ��...
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError:
DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005) �ַ����:
Microsoft Jet ��ݿ�����򲻿��ļ�'\\10.1.1.5\d$\dutydb\DigACS.mdb'�� ���Ѿ�������û��Զ�ռ��ʽ�򿪣���û�в鿴��ݵ�Ȩ�ޡ� ����Դ: Microsoft JET Database Engine
�����ļ�: ����������: 5003051 ������ϸ��¼: ���� -2147467259 (80004005); �ṩ�������: -534709256 (E020FBF8) �ַ����: Microsoft Jet ��ݿ�����򲻿��ļ�'\\10.1.1.5\d$\dutydb\DigACS.mdb'�� ���Ѿ�������û��Զ�ռ��ʽ�򿪣���û�в鿴��ݵ�Ȩ�ޡ� ����Դ: Microsoft JET Database Engine �����ļ�: ����������: 5003051 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: ��ִ����ϡ�. ����˳����� 1��. ����ʧ�ܡ�

��д�IJ��裺
��������Զ�ͬ���IJ���
1.���sql�е�_temptable1 ��ҵ�ĵ�һ������
delete from _temptable1
2.��Access�е������µ��Ž�ϵͳ����ԱID��Ա����ŵ����¶�Ӧ��ϵ��SQL��DTS-2
3.����Access��ʱ�� DTS-1
4.��SQL�����Ŀ���ʱ��ȡ������������Access����ʱ���У�DTS0
5.�������µĿ�����ݵ�AttendLog_temp�У� DTS��
6.��ҵ�����һ�����裻
ִ������ SQL:
insert into AttendLog
(hmid,asCardNo,alSKDate,alSKTime,
alisrepair,alrepairreason,amMachineno,
alstate,alwholetime,alRepairRatifier,
alCreater,alismodify,almodifyreason,
IsAuditing,AuditingData,AuditingRemark
)
(
SELECT c.hmID, a.asCardNo,a.alSKDate,a.alSKTime,
a.alisrepair,a.alrepairreason,a.amMachineno,
a.alstate,a.alwholetime,a.alRepairRatifier,
a.alCreater,a.alismodify,a.almodifyreason,
a.IsAuditing,a.AuditingData,a.AuditingRemark
FROM AttendLog_Temp a INNER JOIN
_tempTable1 b ON a.ID = b.ID INNER JOIN
HumanMain c ON b.hmWorkNo = c.hmWorkNo

)
7.���AttendLog_Temp


0 new messages