Thanks for the reply Phil! I completely rebuilt the package, set delay validation = false..and it runs without error!

One more question. I'm trying to execute the package from a SP. What's the proper syntax to pass the variable from the SP to the SSIS package? My overall goal is to call the SSIS package programatically from an asp.net application. So I'll be passing the filename as a varaible from the program.

Here's what I have so far:

AS

DECLARE @cmd varchar(1000)

DECLARE @SSISpath varchar(1000)

DECLARE @ReturnCode int

set @SSISpath = 'F:\apps\SSIS Packages\ExcelImport.dtsx'

set @cmd= 'dtexec /F "' + @SSISpath + '"'

set @cmd = @cmd + ' /SET \Package.Variables[User::FileName].Properties[Value];"'

EXEC @ReturnCode = master..xp_cmdshell @cmd

Again, thanks for all your help!