Hi Bob,

Thank you for the input, you are really making things even complex, although you won't say that. (don't panic, I know you are in good intention ;))

If I have...

Thank you for your reply, the reason why I don't want to use (if possible) the if else is: I have not only integrity be the criteria, but several others,...

Yes, it is still there, my mistake. Thank you guys.

Step 1 prompted a "folder not exist" permission problem, all the following steps show different error messages caused by step 1.

This is weird, there got to be something wrong...

All the child packages are logging-enabled, log shows there was no any problem until Aug 30.

Each of the sub DTS has no history reported since Aug 30.

Before Aug 30, everything is fine.

I still don't understand:

There are 5 steps in the master DTS package, each step is a sub DTS package, when I tried to run each step in the master DTS...

I have just verified the user that the job is run under has Modify/Read/Write... except for Full Control to that folder.

I am running the DTS again to see if a...

Good remind!

The error message says a local folder doesn't exist, but the folder is there.

However I am not sure what role...

I checked the log history, no any record for showing either success or fail since Aug 30.

There you go.

I know it's á, I just don't know why/how it is padded into my records,...

Problem resolved.

Thanks for all of you who pull me out of this muddy weird pond. But I still don't know why char(160) was padded.

OK, using ASCII() I found for unknown reason char(160) was inserted as padding.

I believe now I can clear out the table.

But what the heck is char(160)?

OK, here is the scripts: first one is not working, second one is working:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[EPM](

[ID] [int] NOT NULL,

[AppID] [int] NULL,

[AppCode] [varchar](5) NULL,

[Description] [varchar](2000)...