Error running SSIS pkg from dtexec utility

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

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Error running SSIS pkg from dtexec utility

Author

Topic

nrnviv
Starting Member

2 Posts

Posted - 2008-02-21 : 22:44:33

Hi All,

I developed my package in BI studio and tested runnning it through BI. Now when i have to deploy the package to main server it will be executed via batch job. This package requires an input file name too.
Now when i am trying to run the package on my loacal box using following command on command prormpt i get error given below.

COMMAND USED BY ME: DTExec /FILE 'C:\Project\IntegrationServices\SFRIntegrationServices\bin\pkgSFRLocation.dtsx' /SET \Package.Variables[InputParamFileName].Value;'C:\DataDump\Input\LOC00022'

ERROR MESSAGE:
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 1:29:54 PM
Error: 2008-02-22 13:29:54.96
Code: 0xC0011007
Source: {9B1FAA88-A6FA-44CF-A2E2-DB3F737FDA65}
Description: Unable to load the package as XML because of package does not ha
ve a valid XML format. A specific XML parser error will be posted.
End Error
Error: 2008-02-22 13:29:54.96
Code: 0xC0011002
Source: {9B1FAA88-A6FA-44CF-A2E2-DB3F737FDA65}
Description: Failed to open package file "'C:\Project\IntegrationServices\SFR
IntegrationServices\bin\pkgSFRLocation.dtsx'" due to error 0x800700A1 "The speci
fied path is invalid.". This happens when loading a package and the file cannot
be opened or loaded correctly into the XML document. This can be the result of
either providing an incorrect file name was specified when calling LoadPackage o
r the XML file was specified and has an incorrect format.
End Error
Could not load package "'C:\Project\IntegrationServices\SFRIntegrationServices\b
in\pkgSFRLocation.dtsx'" because of error 0xC0011002.
Description: Failed to open package file "'C:\Project\IntegrationServices\SFRInt
egrationServices\bin\pkgSFRLocation.dtsx'" due to error 0x800700A1 "The specifie
d path is invalid.". This happens when loading a package and the file cannot be
opened or loaded correctly into the XML document. This can be the result of eit
her providing an incorrect file name was specified when calling LoadPackage or t
he XML file was specified and has an incorrect format.
Source: {9B1FAA88-A6FA-44CF-A2E2-DB3F737FDA65}
Started: 1:29:54 PM
Finished: 1:29:54 PM
Elapsed: 0.047 seconds

PLease let me know solution to creating batch job for executing this pkg with input param.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-21 : 22:57:36

Does that file exist in c:\ on your pc?

nrnviv
Starting Member

2 Posts

Posted - 2008-02-28 : 19:52:54

Yes, currently the dtsx file is lying in my project path folder i.e.
'C:\Project\IntegrationServices\SFRIntegrationServices\binpkgSFRLocation.dtsx'

I still have not solved this problem, pls help.

well7952
Starting Member

1 Post

Posted - 2008-03-17 : 11:23:31

Have you tried changing the single quotes to double quotes?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-17 : 23:49:28

If you deployed package to remote sql server, should reference package file with unc name and ensure sql agent service account has permission to access the file.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources