|
|
Hi Guys,
I have one batch file. I set argument in it and when I double click the bat file,it work perfectly  . 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
|
|
|
|
|
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.
|
|
|
|
|
Thx for the reply
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
|
|
|
|
|
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
|
|
|
|
|
Hello friends can any one tell me how can I get the total number of records found and print that on top my report?
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 ?
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Thanks Senthil,
It is not overwritten issue.
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
|
|
|
|
|
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
|
|
|
|
|
Hmm.. you don't have to create the file first. It will automatically created, if you call:
objWriter.Close();
|
|
|
|
|
Thanx man it really work for me
wasim khan
|
|
|
|
|
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!!! 
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Hi,
I need to get printed document name using PJL in C#.
I tried USTATUS command , but unable to get document name and computer name.
can anybody help me, if anybody has done this before?
Thanks.
Regards,
Sunil.
|
|
|
|
|
I have "System.ComponentModel.Win32Exception: Access is denied Exception."
while try to get Processinformation of some process using System.Diagnostics
Can anybody help
Thanks,
Soni
|
|
|
|
|
Most likely you did not use Credentials with Admin Permissions for executing the query?
:: It's better to burn out than to fade away ::
|
|
|
|
|
Hi friends,
I have 2 list box and a horizontal Splitter. When I resize the window, both the listbox does not resize proportionally. The top listbox remains in same height, the bottom listbox gets resized.
The properties for splitter is
cursor - HSplit
Dock - Top
The properties for listbox1 is
Dock - Top
Anchor - Top,Left
The properties for listbox2 is
Dock - Fill
Anchor - Top,Left
I tried changing the dock properties. It does not help me.
Please help me.
Thanks,
Thiaga
|
|
|
|
|
I'm pretty sure you need to change the Anchor settings of the listbox controls. If for example you anchor them to each side they will resize whenever you resize the entire Form. The Dock option just defines to which side the listbox element sticks, like an "align" in html if I remember it right
:: It's better to burn out than to fade away ::
modified on Tuesday, July 15, 2008 10:14 AM
|
|
|
|
|
Dear All,
Please help me solving following issue.
Background Information
------------------------------------
1. We have 2 web application running on MOSS + IIS 6
2. Both applications are on same web server, run by System Admin account
3. Developed using ASP.Net, C# and DB as SQL Server 2005
4. One is running on Framework 2.0 and second is on Framework 3.5
5. In both we are using Office Objects to impose IRM permissions
6. Both were working till latest windows update on the web server.
7. After that we started getting following errors
Errors
---------
Word object: Not Able to Open the word file at all
------------------
System.Runtime.InteropServices.COMException (0x800A1401): Word experienced an error trying to open the file.
Try these suggestions.
* Check the file permissions for the document or drive.
* Make sure there is sufficient free memory and disk space.
* Open the file with the Text Recovery converter. (C:\...\My File.doc)
at Microsoft.Office.Interop.Word.Documents.Open(Object& FileName, Object& ConfirmConversions, Object& ReadOnly, Object& AddToRecentFiles, Object& PasswordDocument, Object& PasswordTemplate, Object& Revert, Object& WritePasswordDocument, Object& WritePasswordTemplate, Object& Format, Object& Encoding, Object& Visible, Object& OpenAndRepair, Object& DocumentDirection, Object& NoEncodingDialog, Object& XMLTransform)
at OpenFile.SetExpiryDate(String strFilePath, String strExpiryDate) in c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\My Application\MyPage.aspx.cs:line 1033
Excel Object: Not Able Close the excel file even though all objects are explicitly closed.
-------------------
When try to delete file following error comes.
The process cannot access the file 'C:\\Program Files\\Common Files\\Microsoft Shared\\web server extensions\\12\\TEMPLATE\\LAYOUTS\\My Application\\Scratchpad\\Book1.xlsx' because it is being used by another process
PowerPoint object: Not able to save
---------------------------
Presentation (unknown member) : An error occurred while PowerPoint was saving the file.
Is this some kind of a security permission issue on the folder where we are processing the file? Right now I have given full permission to following accounts.
1. Administrators
2. ASP.Net
3. Network Service
4. System
After the error I gave full permission to Everyone, still the problem persists.
I have uninstalled office and installed it with latest security patches. Removed old COM reference (Microsoft Excel, Word, PowerPoint) and added new, but still no progress.
Any other thing I need to check or update?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
