SequelSurfer (6/21/2010)

---

I would try two basic steps from here...

1) Run the job manually and check results

2) Execute the pacakge manually (making sure you are executing the same job package that...

the message is "Message

Executed as user: LENOVO-PC\SYSTEM. The package execution failed. The step failed."

i used the same user when i import the data and save the SSIS package..

thank u...

yap,"smartbiz" is a database name and the server name is "kawi".....

dear all,

i already use the command EXEC sp_addlinkedsrvlogin 'kawi', 'true'

but the error msg is still the same and i already expand the security login to sql server and windows login...

i'm already add the index for the table like

Product|STATUS|BEGIN|TRX|END|Index

A IN 0 5 0 1

A IN 0 1 0 2

A OUT 0 2 0 3

B IN 0 10...