Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS PACKAGE DOUBT Expand / Collapse
Author
Message
Posted Monday, December 24, 2012 1:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 8, 2014 2:40 AM
Points: 52, Visits: 136
Hi Guys,

I need a small help, I need to execute package with input parameter.
The command which i have given in CMD is
dtexec /f C:\SSIS \Troubleshoot.dtsx /set \package.variables[variablename].Value;"mynewvalue"

In this i have given my file location path,
I have got an error like failed to open package file. Could anyone please tell me how to get the correct location of my package path?

Post #1399836
Posted Monday, December 24, 2012 1:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 8, 2014 2:40 AM
Points: 52, Visits: 136
AND another error I am getting is Unable to load the package as XML because package doesnt have valid xml format.
Post #1399838
Posted Monday, December 24, 2012 1:44 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:58 AM
Points: 5,369, Visits: 9,890
Can you open the package in Visual Studio or in the Package Execution Utility?

John
Post #1399840
Posted Tuesday, December 25, 2012 9:35 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 8, 2014 2:40 AM
Points: 52, Visits: 136
Yes I could open the package in visual studio
Post #1400137
Posted Thursday, December 27, 2012 1:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:58 AM
Points: 5,369, Visits: 9,890
What version of Visual Studio are you using, and what is the version of dtexec.exe?

John
Post #1400487
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse