DTS Update scheduled job

#1

The statement has been terminated. (Microsoft OLE DB
Provider for SQL Server (80040e2f): INSERT statement
conflicted with COLUMN FOREIGN KEY
constraint 'FK_fctSales_dmProduct'. The conflict occurred
in database 'MgkOlap', table 'dmProduct',
column 'item_code'.)
Package failed because Step 'DTSStep_DTSExecuteSQLTask_8'
failed.

#2

Please do not post the same question under different subject headings. See
my reply to your other thread.

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Jael" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

The statement has been terminated. (Microsoft OLE DB
Provider for SQL Server (80040e2f): INSERT statement
conflicted with COLUMN FOREIGN KEY
constraint 'FK_fctSales_dmProduct'. The conflict occurred
in database 'MgkOlap', table 'dmProduct',
column 'item_code'.)
Package failed because Step 'DTSStep_DTSExecuteSQLTask_8'
failed.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Update scheduled job

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Update scheduled job - 11-04-2003 , 05:05 AM

Re: DTS Update scheduled job - 11-04-2003 , 05:28 AM