How to set batch file argument in "Execute Process Task" (SSIS Packages) - C# Discussion Boards

Re: windows service

J4amieC14-Jul-08 22:42

J4amieC

14-Jul-08 22:42

arkiboys wrote:
What do I do if this service needs to be installed on another machine

Easiest way is to create an installer, take that installer to the other machine and run it.

A Google search[^] will provide you with a plethora of information on the subject.

Re: windows service

wurzel_cidermaker14-Jul-08 22:45

wurzel_cidermaker

14-Jul-08 22:45

To install the Windows Service on another machine you would add a
Setup project to your solution which would then create an MSI package.

Run the MSI package on the target machine and this will create the Windows Service.

Obviously you would need the relevant .NET Framework version on the target machine.

Re: windows service

arkiboys15-Jul-08 3:14

arkiboys

15-Jul-08 3:14

Can I do this by the click once method to install the service on another machine?
Thanks

Re: windows service

leppie15-Jul-08 3:16

leppie

15-Jul-08 3:16

I highly doubt ClickOnce will work for services Smile | :)

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

saving into database

Metik14-Jul-08 21:36

Metik

14-Jul-08 21:36

Hi,

How can i save value from textbox into database
or change some value in database with value in textbox.

Re: saving into database

leppie14-Jul-08 22:28

leppie

14-Jul-08 22:28

Read some books/tutorials, your question is so vague, I assume you are a beginner. You will need some background knowlegde on the process, but once you do, you will find it is trivial Smile | :)

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Re: saving into database

Rupesh Kumar Swami14-Jul-08 22:28

Rupesh Kumar Swami

14-Jul-08 22:28

i think you need to first learn Database Programming in C# Smile | :)

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

My Company
My Article

How to set batch file argument in "Execute Process Task" (SSIS Packages)

Chintan.Desai14-Jul-08 21:27

Chintan.Desai

14-Jul-08 21:27

Hi Guys,

I have one batch file. I set argument in it and when I double click the bat file,it work perfectly Smile | :)

. Argument only suggest to execute other SSIS packages on a given path.

Argument is:

FOR %%V IN (*.dtsx) DO dtexec /f "%%V" /Config "cfg%%~nV.dtsConfig" >> log_PkgExecution.txt
pause

Now, I want to set the same argument in SSIS Package called "Execute Process Task" in Execute Process Task editor -> Argument property. I did it, but getting problem during execution.

On executing the package, DOS prompt is coming blank...

I think, it is not getting the argument...

Please help, if I am doing something wrong.

Thanks in advance.

Chintan

Re: How to set batch file argument in "Execute Process Task" (SSIS Packages)

leppie14-Jul-08 22:29

leppie

14-Jul-08 22:29

Chintan.Desai wrote:
On executing the package, DOS prompt is coming blank...

It will be. You are redirecting output to the log_PkgExecution.txt file. Have a look in there.

Your question is also not C# related.

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)

Re: How to set batch file argument in "Execute Process Task" (SSIS Packages) [modified]

Chintan.Desai14-Jul-08 23:07

Chintan.Desai

14-Jul-08 23:07

Thx for the reply Smile | :)

Log file is showing the following:

Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started:  12:19:02 PM
DTExec: Stopping the package execution.
Started:  12:19:02 PM
Finished: 12:19:10 PM
Elapsed:  7.938 seconds

I couldn't see the rows affected in my DB by packages which are executed by this bat file...In short, this batch file is not executing the argument.

Regards
Chintan

modified on Tuesday, July 15, 2008 5:18 AM

ORA-00936:mising expression

varun_mca_ju14-Jul-08 21:20

varun_mca_ju

14-Jul-08 21:20

I have a textbox called "textBox6.text" in a C# Windows Application in Visual Studio, and i want that the text entered by the user in the textbox should be added to the "PURPOSE" field in a table "TABLE2_HDB1" in Oracle database "HDB1" on clicking a "submit" button.

the coding for submit button is as follows:-

private void button1_Click(object sender, EventArgs e)
{
string OracleStmt;
string ConString;
OleDbConnection cn = null;
OleDbCommand cmd = null;
try
{
OracleStmt = "insert into TABLE2_HDB1(PURPOSE) values(@PURPOSE)";
ConString = " Provider=MSDAORA;Data Source=HDb1;User Id=SYSTEM
;Password=*****;";
cn = new OleDbConnection(ConString);
cmd = new OleDbCommand(OracleStmt, cn);
cmd.Parameters.Add(new OleDbParameter("@PURPOSE", OleDbType.VarChar , 20));
cmd.Parameters["@PURPOSE"].Value = textBox6.Text;
cn.Open();
cmd.ExecuteNonQuery();
textBox8 .Text = "record inserted successfully";
}
catch (Exception ex)
{
textBox8 .Text = ex.Message;
}
finally
{
cn.Close();
}
}
on executing this code u get the error :-
ORA-00936:missing expression
plz. help Confused | :confused:

Crystal Report Help

Saiyed Alam14-Jul-08 20:59

Saiyed Alam

14-Jul-08 20:59

Hello friends can any one tell me how can I get the total number of records found and print that on top my report?

error monitoring thread status

George_George14-Jul-08 20:58

George_George

14-Jul-08 20:58

Hello everyone,

When using !threads command to monitor thread status for a dump, there is an error message. Does anyone meet this before? What is wrong?

0:001> !threads
Failed to load data access DLL, 0x80004005
Verify that 1) you have a recent build of the debugger (6.2.14 or newer)
2) the file mscordacwks.dll that matches your version of mscorwks.dll is
in the version directory
3) or, if you are debugging a dump file, verify that the file
mscordacwks_<arch>_<arch>_<version>.dll is on your symbol path.
4) you are debugging on the same architecture as the dump file.
For example, an IA64 dump file must be debugged on an IA64
machine.
You can also run the debugger command .cordll to control the debugger's
load of mscordacwks.dll. .cordll -ve -u -l will do a verbose reload.
If that succeeds, the SOS command should work on retry.
If you are debugging a minidump, you need to make sure that your executable
path is pointing to mscorwks.dll as well.

thanks in advance,
George

Exception in EventLog.WriteEntry

George_George14-Jul-08 20:45

George_George

14-Jul-08 20:45

Hello everyone,

The exception is occured in EventLog.WriteEntry, error message and error stack are listed below. Does anyone have any ideas?

"A device attached to the system is not functioning"

System.Diagnostics.EventLog.InternalWriteEvent(UInt32, UInt16, System.Diagnostics.EventLogEntryType, System.String[], Byte[], System.String)
System.Diagnostics.EventLog.WriteEntry(System.String, System.Diagnostics.EventLogEntryType, Int32, Int16, Byte[])
System.Diagnostics.EventLog.WriteEntry(System.String, System.Diagnostics.EventLogEntryType, Int32)

thanks in advance,
George

Re: Exception in EventLog.WriteEntry

N a v a n e e t h14-Jul-08 21:25

N a v a n e e t h

14-Jul-08 21:25

George_George wrote:
A device attached to the system is not functioning

I guess some required DLL's are missing. Are you getting this for all application or only for this one ?

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

Re: Exception in EventLog.WriteEntry

George_George14-Jul-08 22:13

George_George

14-Jul-08 22:13

Only for this application, N a v a n e e t h!

And this happens only once, looks strange. Any ideas? What do you mean DLL missing? Which DLL? CLR DLL?

regards,
George

Re: Exception in EventLog.WriteEntry

S. Senthil Kumar15-Jul-08 9:12

S. Senthil Kumar

15-Jul-08 9:12

Was the event log full by any chance? IIRC, the default setting is to overwrite entries older than a specific date, and if there are lot of events after it, the event log could get full.

Regards
Senthil [MVP - Visual C#]
_____________________________
My Blog | My Articles | My Flickr | WinMacro

Re: Exception in EventLog.WriteEntry

George_George15-Jul-08 22:00

George_George

15-Jul-08 22:00

Thanks Senthil,

It is not overwritten issue. Smile | :)

I noticed at the same time, system is reboot. So, is it expected behavior when system is reboot and at the same time write event log?

regards,
George

Exception : File used by Another Process

wasimsharp14-Jul-08 20:37

wasimsharp

14-Jul-08 20:37

Hi friend i have some problem
I have code

if (!File.Exists(path))<br />
     {<br />
         File.Create(path);<br />
         <br />
     }<br />
     StreamWriter objWriter = new StreamWriter(path, true);

if File does not exist then it Create the File but just after creation when the Stream writer object is created it throw exception that the File is used by another Process how i can overcome this problem

wasim khan

Re: Exception : File used by Another Process

stancrm14-Jul-08 20:52

stancrm

14-Jul-08 20:52

Hmm.. you don't have to create the file first. It will automatically created, if you call:
objWriter.Close();

Re: Exception : File used by Another Process

wasimsharp14-Jul-08 21:00

wasimsharp

14-Jul-08 21:00

Thanx man it really work for me

wasim khan

Clipboard "paste" event, and from where did it copied from.

Green Fuze14-Jul-08 19:57

Green Fuze

14-Jul-08 19:57

Hey everybody!

I wrote a clipboard monitor using "SetClipboardViewer()", "SendMessage()", and "ChangeClipboardChain()" in the windows API.

But I have 2 more problems I just can't figure out...

1.
using GetClipboardOwner(), I'm getting a handle to a window, but I couldn't find a way to know which window is it. So, how can I tell, using IntPtr to which window do I have a handle to?

2.
I'm trying for some time to find ANY way to get information about global paste events.
I know that if I can get a "control" object I can override the WndProc() function to get messages, but about other windows in the system?
For example, what if I want to prevent paste of the clipboard data if it is not in my application ?

Thanks a lot for your help!!! Big Grin | :-D

How to make 30 days trial

D i x y14-Jul-08 19:53

D i x y

14-Jul-08 19:53

Hello Friends,
I am developing a windows application where i need to make two versions for the application one is Full and another is DEMO version

My Question is how to make DEMO version 30 Days Trial and after 30 days it will expires if user changes system date back or forward then one day will be subtracted from trail..

Thanks

Re: How to make 30 days trial

Rupesh Kumar Swami14-Jul-08 20:34

Rupesh Kumar Swami

14-Jul-08 20:34

You can Create key in registry which holds the data of your application.Simply add parameter(subkey) like dayRemaining, lastUsedDate etc to this key in registry and check at application startup.
If you have no idea about registry then click the Read,Write and delete from registry with c#

hope this helps

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

My Company
My Article

Re: How to make 30 days trial

Thomas Stockwell15-Jul-08 8:36

Thomas Stockwell

15-Jul-08 8:36

CodeProject search: Secure Software Distribution SDK[^]

Regards,
Thomas Stockwell

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

Visit my homepage Oracle Studios

Discounted or Free Software for Students:
DreamSpark - downloads.channel8.msdn.com
MSDN Academic Alliance - www.msdnaa.com

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.