ADVERTISEMENT
Problem Running SSIS From C# Executable When Kicked Off By Another Executable.
Sep 26, 2007
If I kick off my C# executable from the server everything works fine but if I have another C# executable kick off the C# executable that runs the SSIS I get an error message saying it cannot run SSIS package. I am thinking it sounds like a permissions problem but not sure. Any suggestions/guidance would be greatly appreciated.
Errors I am getting.
2007-09-26 15:02:30,187 [1] ERROR reporting.Processor [(null)] - Problem with Direct Script
2007-09-26 15:02:30,843 [1] ERROR reporting.Processor [(null)] - {Microsoft.SqlServer.Dts.Runtime.DtsError, Microsoft.SqlServer.Dts.Runtime.DtsError, Microsoft.SqlServer.Dts.Runtime.DtsError, Microsoft.SqlServer.Dts.Runtime.DtsError, Microsoft.SqlServer.Dts.Runtime.DtsError}
Thanks in advance.
Run An Executable File In SQL
Feb 20, 2008Hi, I'm new to SQL and I just got a new job with very little hands on training. I have executed a CreateTables.sql and now my boss wants me to run a Conversion.exe file. I am not sure how to do that, any help would be most appreciated. Thanks,
Laura
Kick Off A VB Executable File
Jul 22, 1999Can I kick off a VB.exe in SQL Server 6.5?
TIA,
Stella
How Can I Know Which Tables Modified With An Executable File
Jan 23, 2007Kazim writes "generally when we find the new software on our customer and when they want to change the software they said "we must see and use the old datas on the new program". but at here the problem is starting for us because of i want to know on any example on the old software which data is stored on which table on sql server or it is possible for this example we can say spy. do you know anything for about this type of the question and how can we check which tables and columnS are affected by the software?
thnx."
SQL Express 2005 Executable File Name?
Feb 19, 2008I am having a hard time finding the executable file to start sql express 2005 or SQL exress 2005 with advance services. I installed the SQL express and had the desktop icon....but I thought i would need to uninstall it before installing SQL 2005 with advance services. Now I can not find anything to start the program.
Calling An Executable File From Stored Procedure
Jul 26, 2007Hi people.
I have this issue
I'm on a application server and i need to run a executable file from a SP, my problem is if i use xp_cmdshell (from the SP) it will try to run it on the SQL Server not on a App server, this a third party executable so cannnot be run on the sql backend.
Do you know any workaround for this?
Examples Of Certificates Created With Private Key And FROM EXECUTABLE FILE Options
Apr 4, 2006Hi
I am looking at documentation of CREATE CERTIFICATE statement. I am having hard time in understanding if I want to create CERTIFICATE with above mentioned options, how I am supposed to create either PRIVATE KEY file or EXECUTABLE file. any example would be really helpful for what I am doing here.
thanks
Satya
Output To File (not Using Xp_cmdshell)
Aug 13, 2007Hi everyone -
I have a client who need to output some text from a stored procedure to a text file. The main problem is that it is a SOX system, so we can't use xp_cmdshell, and we can't create new tables. This rules out the following methods:
DTSrun
osql
bcp
I then thought well maybe we can convert the SP to a DTS package. Well that can't work because he stores the text to be output in a #temptable, and I couldn't get DTS to do data transformation on a temptable.
SQL Server 2000 SP4
Any ideas?
Thanks,
Reghardt
Copy Backup File Xp_cmdshell
Jan 4, 2000What is the syntax for using xp_smdshell to copy a file from 1 server to another?
Our Report server is restored from our production server and I want to copy the .dat
file from the production server to a folder on the report server.
Xp_cmdshell And Pass Command Line Parameters To .exe File
Jul 20, 2005I need to execute xp_cmdshell in a trigger and pass a command lineparameter to the .exe programi.e. I have a .exe program c:program filessavedata.exeIn the trigger I have a parameter @Id bigintI need to pass the parameter @Id to savedata.exeIn the trigger, I am tryingEXEC master..xp_cmdshell 'cmd.exe /C "c:program filessavedata.exe "'+ CAST(@Id as varchar)BUT this does not work.Can someone please help me with how to do this?Thanks,db
View 1 Replies View RelatedXp_cmdshell - Problem Creating Txt File For Working For Remote Computer
Jan 20, 2004I am having problem creating/copying "txt" file in a remote machine by using the "exec master..xp_cmdshell" command in query analyzer. For example, we are getting errors for the following command:
exec master..xp_cmdshell 'copy d: estingauthors.txt \<MyServerName><myFolderName>authors.txt'
(but exec master..xp_cmdshell 'copy d: estingauthors.txt d: esting1authors1.txt' is working without any problems)
Any ideas?
Xp_cmdshell - Problem Creating Txt File For Working For Remote Computer
Jan 20, 2004I am having problem creating/copying "txt" file in a remote machine by using the "exec master..xp_cmdshell" command in query analyzer. For example, we are getting errors for the following command:
exec master..xp_cmdshell 'copy d: estingauthors.txt \<MyServerName><myFolderName>authors.txt'
(but exec master..xp_cmdshell 'copy d: estingauthors.txt d: esting1authors1.txt' is working without any problems)
Any ideas?
Problems Creating Error File When Using Bulk Insert Or BCP From Xp_cmdshell.
Mar 13, 2006BCP thru xp_cmdshell from stored procedure:
EXEC sp_configure 'show advanced options', 1;
RECONFIGURE
EXEC sp_configure 'xp_cmdshell', 1;
RECONFIGURE
EXEC xp_cmdshell 'bcp database.dbo.table in c:scheduled.csv -S SERVERSQLEXPRESS -T -t, -r -c -e "error.txt"';
This is returning the following error code. I even tried placing the command in a seperate command file and calling that with no success. If I run this from the command line the error file generation does work.
=================================================================
SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unable to open BCP error-file
=================================================================
Error message when using BULK INSERT as follows:
BULK INSERT database.dbo.table from 'c:unscheduled.csv' with
(FIELDTERMINATOR = ',', ERRORFILE = 'c:error.txt');
Returns the following error message:
=================================================================
Msg 4861, Level 16, State 1, Procedure pro_cedure, Line 9
Cannot bulk load because the file "c:error.txt" could not be opened. Operating system error code 80(The file exists.).
Msg 4861, Level 16, State 1, Procedure pro_cedure, Line 9
Cannot bulk load because the file "c:error.txt.Error.Txt" could not be opened. Operating system error code 80(The file exists.).
=================================================================
The Bulk Insert actually creates a empty error.txt file (0kb) and never preforms the insert, I can not find any examples of anyone using the -ERRORFILE switch on BULK INSERT. Prolly some default security setting to allow file creation/modification I am missing. Anyone help me out? Thanks.
EDIT: SQL SERVER EXPRESS 2005 - WINXP PRO SP2
Using XP_CmdShell To Execute BCP Utility With QUERYOUT. How To Control The OWNER Of The File Created?
Jan 29, 2008I need the file created by my BCP QUERYOUT command I'm executing from XP_CmdShell in Transact-SQL to have a specific OWNER. I've tried using the sp_xp_cmdshell_proxy_account to setup the correct owner. The owner is always SERVERNAMEAdministrators.
thanks,
jim
CMD Executable From A Job Step
Feb 28, 2002I'm trying to initiate an executable from a job step. This executable functions normally from a command prompt on the server and will initiate properly from a DTS package that is executed locally by a logged in user. It won't run from Query Analyzer, an Operating System Command jobstep, or a scheduled DTS package. The executable creates a report that gets written to disk and a window shows briefly during execution.
MS SQL 2000 on Win2K.
Any clues as to how to run this executable from a scheduled jobstep?
Thanks if you can help,
Mack
Running An Executable As A Job
May 24, 2002We have a job set up that runs a Visual Basic executable file. It was running fine. We just upgraded to SQL2000. The job still seems to run ok, but we are getting a message that the job failed. "The step did not generate any output. Process Exit Code -1073741819. The step failed." Yet, when we check the output tables, it seems as though the job ran ok. The programmer is not passing any exit codes. Any ideas?
View 1 Replies View RelatedAdding Dll Or Executable
Apr 13, 2007Is there an ability to add dll or executable to ssis?????
Running Job With Vb Executable On Windows NT
Feb 15, 2001Hi,
I have a small Vb project( it is triggers Crystal report to run) which should be scheduled with SQL 7.0.
Project itself runs without any problem.
When I schedule a job to run that Myproject.exe with WIN95 Or create a DTS package and execute it on WINNT it also works fine.
But when I am trying to schedule that package OR create a separate job on WINNT to run Myproject.exe- nothing happen(it run 47 hours since yeasterday-nothing happen) Also under Job/Edit/Step1/Command I am using the following command
either: Myproject.exe OR cmd /c "D:VB98f100estvbCrystalMyproject.exe"
Any ideas,
Andy
How To Execute An Executable Using A Sqlserver Job
Jun 14, 1999I am trying to run an executable via a scheduled sqlserver job. I have set the jobstep type to CMDEXEC; and the commands for the jobstep that I have tried are:
start c:estinsertindb.exe
c:estinsertindb.exe
c:estinsert.bat
insert.bat above contains c:estinsertdb.exe or
start c:estinsertdb.exe
Is there an exception that will not allow a job to run an exe file?
I am running into a similar problem using the NT scheduler via the "at" command.
With NT, I run a bat file with the following command to create a scheduled task or job (at 10:10 /every:M,W,F c:estinsertdb.exe).
At 10:10, when the job is scheduled to run, nothing happens; but if I edit the job and manually start the job, it runs.
How To Run A Executable From Triggers Or Stored Procedures
Nov 16, 2001Hi folks,
Is there is any way to run a executable from triggers or stored procedures..
Please let me know, whether it is possible in SQl Server 7.0.
Let me know asap...
rgds,
VJ
Can You Embed DTSX Package In A C# Winform Executable?
Mar 22, 2008
Im trying to figure out if there is a way to embed an ssis package into a c# winform?
I know that I can pass variables to a package and write the entire package out programatically, but im curious if there is a way to add the dtsx as an assembly or something. OR is there any tool that would take the ssis package and spit out its equivalent in code?
thanks
Recovery :: Unable To Locate The Cluster Service Executable
Jun 12, 2015I am having Windows 2012R2 Std with SQL2012SP2. Trying to add SQL cluster node2 but unable to locate the instance name when I click on drop down button.Understand that SQL Server Agent is required but it is not listed as cluster resource. Therefore, I perform the followingFrom Windows Power Shell with Administrator rights
1. Import-Module FailoverClusters
2. Add-ClusterResourceType "SQL Server Agent" c:windowssystem32SQAGTRES.DLL
Error: Add-ClusterResourceType : Unable to locate the cluster service executable on node1.The network name cannot be found.No problem to ping all cluster related names as well as fail-over to and from next available node.
Installing SQL 2005 Trial Software - Which Executable Should I Download
May 31, 2006I am in the process of downloading the executable file, however which am I meant to pick
X86
x64
IA64
I will be installing on a labtop, 256 memory, Pentium 4 1.7 GHZ
I have gone for the x86. Is this right? Also I know recommended memory is 1 gig but will I still be able to install. I just want to have a look at the procduct.
Please help
Execute Process Task How To Exit The Executable Program
Jan 21, 2008Hello everybody,
Could anybody tell me how can I stop the executable program which I am using in Arguments field of Execute Process Task Editor window. My SSIS process based on three steps.
1. retrieve the file from FTP location
2. Process the file by using windows 32bit application
3. transfer the processed file back to FTP location
The problem occurs in step 2, it opens the win32 application for processing and it does process BUT after that it won't exit untill I close it manually, so it never reaches to step 3 if I don't close it.
Thanks in advance.
Zee.
SSIS Programming Model - Adding Custom Dll As An Executable To Package
Aug 8, 2007
I am trying to add a custom dll(IncrementTask avalilable in SQL Server DTS Samples)
as an executable(Task) to an SSIS package.
The following console application consumes the Custom dll:
using System;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Tasks.FileSystemTask;
using Microsoft.SqlServer.Dts.Samples;
using Microsoft.Samples.SqlServer.Dts;
namespace Microsoft.SqlServer.Dts.Samples
{
class Program
{
static void Main(string[] args)
{
Package p = new Package();
// Add a File System task to the package.
//This Line of code works fine.
//TaskHost execPkghost = (TaskHost)p.Executables.Add("STOCKQLTask");
//This line throws the following error: Object reference not set to an instance of an object.
TaskHost execPkghost = (TaskHost)p.Executables.Add("Microsoft.Samples.SqlServer.Dts.IncrementTaskUI,IncrementTaskCS,
Version=1.0.0.0,Culture=Neutral,PublicKeyToken=b23be0feabed1355");
TaskHost thFileSystemTask = execPkghost as TaskHost;
// Iterate through the package Executables collection.
Executables pExecs = p.Executables;
foreach (Executable pExec in pExecs)
{
TaskHost taskHost = (TaskHost)pExec;
Console.WriteLine("Type {0}", taskHost.InnerObject.ToString());
}
Console.Read();
}
}
}
I am getting a runtime error that "object reference has not been set to an instance of the object".
Any help on this is higly appreciated.
Installing SQL Server 2005 Trial Version: Use X86 , X64 Or IA64 Executable?
Jan 4, 2008Hi,
I want to install SQL server 2005 trial version from Microsoft, How do I know which excecutable to tale from these below?
Self-extracting executables:
X86 Executable
X64 Executable
IA64 Executable
Thanks
Integration Services :: SSIS Execute Process Task Executable Not Found
Jul 10, 2015I have an execute process task set up to run ftp.exe and a script argument. Â The ftp.exe is referenced in the executable field without a qualified path. Â The package just seems to know it's there relatively. Â I need to change this to run a secured ftp executable that I recently installed on my pc. Â I put the new executable in the WindowsSystem32 folder where the old ftp.exe is stored. Â But when I put the new executable in the executable field, it says the 'File/Process "FTPS.exe" is not in path'. Â I get the same error when I fully qualify the path. Â Is there something I need to do with the new executable for SSIS to pick it up without having to fully qualify the path?
View 8 Replies View RelatedUsing A Variable In An Expression To Populate The Executable Property Of An Execute Process Task In SSIS
Jan 22, 2008Hello,
I am having a hard time setting the executable path for an Execute Process Task in SSIS. I have a variable that is initialized at package statup which holds the path to an executable in Windows. When I set the property "Executable" Path in an expression, I get a warning that the path for the executable is not set. One workaround was to try and initialize the variable with a bogus path with the hopes that the "correct" value will be written on run-time. NO LUCK. I still get the error and I cannot run the package until I put a static path.
Does anyone have a clue as to what is going on??
Mike
Installing Sql Server 2005 Trial Software From Microsoft Website - Self Extracting Executable
Nov 14, 2005Hello,
View 1 Replies View RelatedDTS & Xp_cmdshell
May 15, 2001Hello,
I am trying to create a directory containing the date and then copy all the files in the current directory to it.
If I run the T-SQL script found below within Query Analyser it works fine (directory is created and files are copied in to it).
But if I run it as SQL task within DTS, only the directory is created. The files are not copied in to it!?!
I thought it maybe a permissions problem, but the SQL Server/Agent account is a local administrator and has sysadmin role with SQL Server.
I would be grateful of any assistance in this problem.
Thanks in advance,
Chris.
SQL:
declare @directoryname varchar(200)
declare @doscmd varchar(255)
select @directoryname = 'e:Audit_table_archive' + rtrim(cast(day(getdate())as char)) + rtrim(cast(month(getdate())as char)) + rtrim(cast(year(getdate())as char))
select @doscmd = 'mkdir ' + @directoryname
exec master..xp_cmdshell @doscmd
select @doscmd = 'copy e:Audit_table_archive*.* e:Audit_table_archive' + rtrim(cast(day(getdate())as char)) + rtrim(cast(month(getdate())as char)) + rtrim(cast(year(getdate())as char)) + '*.*'
exec master..xp_cmdshell @doscmd
Ftp Through Xp_cmdshell Help?
Jul 9, 2001does anyone know how to execute a FTP command through sql server 7? I am creation a table and need to ftp the result set. I have it currently creation the table, turning it into a CSV txt file and placing it in a directory. I have to then manually ftp the txt file. I want to automate this process but I cant get the FTP command to execute throught the xp_cmdshell. It will work at the DOS prompt though so I know the syntax is correct. Any sugetsions would be appreciated.
-Nathan
Xp_cmdshell
Aug 10, 2001hi everybody
My requirement is, I have to transfer database backup files from one server to another server to take tape backup. Generally in my backup folder there will be 4days backups. I want to schedule a job so that after database backed up, today’s backup file only copied to the other server. I wrote following code, upto xp_cmdshell every thing is working fine.
But xp_cmdshell statement is giving error. I have to use variable value with sp_cmdshell. Please give me the solution for this.
declare @year1 as varchar(4),@month1 as varchar(2),@day1 varchar(2),@filename varchar(40)
set @year1=ltrim(str(year(getdate())))
if month(getdate())<10
set @month1='0'+ltrim(str(month(getdate())))
else
set @month1=ltrim(str(month(getdate())))
if day(getdate())-1 <10
set @day1='0'+ltrim(str(day(getdate())-1))
else
set @day1=ltrim(str(day(getdate())-1))
set @filename='EMPTest_db_'+ @year1+@month1+@day1+'*.bak'
xp_cmdshell @a
thanks
Keerthi