Package ERROR - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Package ERROR

Author

Topic

yaman
Posting Yak Master

213 Posts

Posted - 2009-01-28 : 06:11:02

alter procedure [dbo].[s_ExecutePackage] 'june','2008'
--@FilePath varchar(1000) ,
@month varchar(20),
@year varchar(20)
as
Declare @cmd varchar(1000)
-- 'dtexec /F "' + @FilePath + @Filename + '"'
select @cmd = 'dtexec /f" E:\Anuj\YG\27jan\ssis\Pkg_PopulateActual_Planning_ALL\Pkg_PopulateActual_Planning_ALL\Package.dtsx /set \package.variables[month].Value;'+@month +'/set \package.variables[Year].Value;'+@year +'"'
exec master..xp_cmdshell @cmd
go

ERROR :-

Unable to load the package as XML because of package does not have a valid XML format.

The system cannot find the path specified.". This happens when loading a package and
the file cannot be opened or loaded correctly into the XML document

Yaman

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-01-28 : 06:26:09

I don't have a first clue what you're actually trying to do but to me the error message says it all: The system cannot find the path specified.

Are you sure that this E:\ drive is visible for the user that is running the sql server engine?

- Lumbago

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources