DTExec: The package execution returned SUCCESS but had warnings

hi!

i am trying to execute through command line the following:\

dtexecui /SQL "\ArchiveMain" /SERVER "SE413695\AASQL2005" /WARNASERROR /MAXCONCURRENT " -1 " /CHECKPOINTING OFF

I am actaully creating an archiving package.

1. All it does is get some data from the Table.

2. creating directory and set usedirectoryifexist = true

shows some warning when i run that directory already exists cos i don't want to create new one i want to use the existing one.

3. actual archiving to get call to another package for archiving - warning while running the package that parent variable is missing

The pacakge seems to run while i execute it thorugh command prompt but i get this message

DTExec: The package execution returned DTSER_SUCCESS (0) but had warnings, with
warnings being treated as errors!

Thanks,

Jas

Your description in line 2 indicates you are creating and setting the directory, is that correct? I see the set command but I don't see the create command. If you are using both a create and set command you should remove the create command because the directory already exists, and then try running it.

You could also include some sort of "if not exist then create" command for your directory in case it was accidentally deleted somehow, then it would be recreated before being set.