SSIS PACKAGE DOUBT

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SSIS PACKAGE DOUBT

SSIS PACKAGE DOUBT

Rate Topic

Display Mode

Topic Options

Author

Message

vijayarani87.s

Posted Monday, December 24, 2012 1:26 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 4:21 AM
Points: 49, Visits: 124

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

vijayarani87.s

Posted Monday, December 24, 2012 1:39 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 4:21 AM
Points: 49, Visits: 124

AND another error I am getting is Unable to load the package as XML because package doesnt have valid xml format.

Post #1399838

John Mitchell-245523

Posted Monday, December 24, 2012 1:44 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 4,434, Visits: 7,218

Can you open the package in Visual Studio or in the Package Execution Utility?

John

Post #1399840

vijayarani87.s

Posted Tuesday, December 25, 2012 9:35 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 4:21 AM
Points: 49, Visits: 124

Yes I could open the package in visual studio

Post #1400137

John Mitchell-245523

Posted Thursday, December 27, 2012 1:19 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 4,434, Visits: 7,218

What version of Visual Studio are you using, and what is the version of dtexec.exe?

John

Post #1400487

« Prev Topic | Next Topic »

Permissions