<div>
Is the package saved to your local amchine?
</div>


Is the package saved to your local amchine?

<div>
Hi Venk,<br />
<br />
Yes, the package is saved to the local machine. &nbsp;The package source connection is an Oracle query and the destination is a table on the local sql server machine. &nbsp;I am now going to try it storing the package on the sql server and see if that makes a difference.
</div>


Hi Venk,

Yes, the package is saved to the local machine.  The package source connection is an Oracle query and the destination is a table on the local sql server machine.  I am now going to try it storing the package on the sql server and see if that makes a difference.

<div>
Good . That what I was about to address initially
</div>


Good . That what I was about to address initially

<div>
Thankfully, I was able to resolve my own question.
</div>


Thankfully, I was able to resolve my own question.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am trying to run a SSIS Package I created using the import/export wizard. &nbsp;I put the package on the SQL Server Agent and trying to execute it there.<br />
<br />
Job Step Code: &nbsp;dtexec /f &quot;c:\pkgOne.dtsx&quot; <br />
<br />
It fails.<br />
<br />
Regards,<br />
<br />
Kelly<br />
<br />

</div>
</div>


Hi,

I am trying to run a SSIS Package I created using the import/export wizard.  I put the package on the SQL Server Agent and trying to execute it there.

Job Step Code:  dtexec /f "c:\pkgOne.dtsx" 

It fails.

Regards,

Kelly



Can't Run my SSIS Package on SQL Server Agent

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.