Problems With Xp..cmdshell
Mar 12, 2001
Hi,
As it was discussed many times on this forum my xp..cmdshell procedure doesn't run vb executable when I am trying to schedule a job.
However it works fine thru DTS or vb executable works itself without any problem.
I am pretty sure that all it can be solved with correctly assigning of the rights/permissions to SQLAgentCmdExec, but supprisingly when I go to Admin Tools -> User Manager for Domains, NT Account SQLAgentCmdExec is not there.
Should I create it ( if it is not there) or it should be done differently?
If someone has few minutes can it be written/explained what I should do in the Windows NT in order to properly assign rights/permissions to SQLAgentCmdExec.
I am using Windowd NT authentication for SQL server;
and SQL server authentication for SQL server agent.
Thanks a lot,
Andy
View 4 Replies
Jul 30, 2007
I would like to run a ssis package and pass the filename as the parameter to the package.
This is what I have worked out so far but notice the error message:
xp_cmdshell 'dtexec.exe /f "d:sysapplCEMSSISImportsTradesCounterPartyExposureEquitiesImport.dtsxEqRonnieHK.csv"'
p.s. If I run the package manually, it runs without error.
Error:
Description: Failed to open package file "d:sysapplCEMSSISImportsTradesCounterPartyExposureEquitiesImport.dtsxEqRonnieHK.csv" due to error 0x80070003 "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. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.
Thanks
View 15 Replies
View Related
Jun 21, 2001
hello,
Can you give me an example of suppression under DOS, of the files with under-directories by exec cmdshell
thank you in advance
Pascal
View 1 Replies
View Related
Mar 17, 2008
Folks:
When I run this from Windows Command Prompt (DOS) it runs successfully but when run from SQL Management Studio (Query nalyser) using xp_cmdshell it fails. Any help is appreciated.
This runs with SUCCESS.
-------------------------
Dtexec /F "E:PackSSIS_Total1.dtsx" /SET package.variables[User::strStatusEmailTo].Value;"xyz@abc.com" /SET package.variables[User::strFileSystemRoot].Value;"Z:" /SET package.variables[User::strServerName_Admin].Value;"pacers"
This FAILS.
------------
exec master..xp_cmdshell 'Dtexec /F "E:PackSSIS_Total1.dtsx" /SET package.variables[User::strStatusEmailTo].Value;"xyz@abc.com" /SET package.variables[User::strFileSystemRoot].Value;"Z:" /SET package.variables[User::strServerName_Admin].Value;"pacers"'
ERROR:
------
End Progress
Progress: 2008-03-17 12:28:53.13
Source: DFT Format Log Info
Validating: 100% complete
End Progress
Progress: 2008-03-17 12:28:53.15
Source: DFT Table Extract to File
Validating: 0% complete
End Progress
Error: 2008-03-17 12:28:53.15
Code: 0xC0202009
Source: MyPackage Connection manager "encore_cm"
Description: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.
".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.".
End Error
Error: 2008-03-17 12:28:53.18
Code: 0xC020801C
Source: DFT Table Extract to File OLE_SRC tblFileConfigMaster [1]
Description: The AcquireConnection method call to the connection manager "encore_cm" failed with error code 0xC0202009.
End Error
Error: 2008-03-17 12:28:53.20
Code: 0xC0047017
Source: DFT Table Extract to File DTS.Pipeline
Description: component "OLE_SRC tblFileConfigMaster" (1) failed validation and returned error code 0xC020801C.
End Error
View 4 Replies
View Related
