Database

FirstPrevNext

Re: DTS Error &quot;Execution cancel by user&quot; Ghazi H. Wadi30-Oct-07 22:41 Ghazi H. Wadi 30-Oct-07 22:41  IF you are able to execute the DTS package manually using dtsrun.exe , then the problem relates to a bug addressed here http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q319058&[^] Then see the workaround methods in the clickity above! Cheers Raz /* Ghazi Hadi Al Wadi, PMP, ASQ SSGB, DBA */ Re: DTS Error &quot;Execution cancel by user&quot; Vimalsoft(Pty) Ltd31-Oct-07 19:50 Vimalsoft(Pty) Ltd 31-Oct-07 19:50  Thanks it worked for me Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za Re: DTS Error &quot;Execution cancel by user&quot; Ghazi H. Wadi2-Nov-07 21:50 Ghazi H. Wadi 2-Nov-07 21:50  HTH! Raz /* Ghazi Hadi Al Wadi, PMP, ASQ SSGB, DBA */ DateTime _Oct2007 r a j u u30-Oct-07 1:25 r a j u u 30-Oct-07 1:25  hi.... Now displaying date like 10-2007 but I want to display Oct-2007.in Sql Query..anybody know plz reply me.. Rajendran Re: DateTime _Oct2007 soni uma30-Oct-07 1:38 soni uma 30-Oct-07 1:38  Try This, select convert(varchar(50),getdate(),106) Re: DateTime _Oct2007 r a j u u30-Oct-07 1:52 r a j u u 30-Oct-07 1:52  hi soni Uma....Thanks for reply..... I want to display only the month and year..(Oct-2007) if u know that plz reply me.. see the following code...thats i have used...but its displaying 10-2007.... select Cast(DatePart(month,RenewalBaseMonth) as varchar) + '/' +Cast(DatePart(year,RenewalBaseMonth) as varchar) as RenewalBaseMonth from #temp21 Thanks Rajendran Re: DateTime _Oct2007 [modified] Senu Gandhi30-Oct-07 2:07 Senu Gandhi 30-Oct-07 2:07  Hi, Try this select Cast(DateName(month,RenewalBaseMonth) as varchar(3)) + '/' +Cast(DatePart(year,RenewalBaseMonth) as varchar) as RenewalBaseMonth from #temp21 Senthil -- modified at 8:15 Tuesday 30th October, 2007 Re: DateTime _Oct2007 r a j u u30-Oct-07 2:14 r a j u u 30-Oct-07 2:14  hi, Its working fine.... Really good work and thanks alot.... Rajendran Re: DateTime _Oct2007 Senu Gandhi30-Oct-07 2:16 Senu Gandhi 30-Oct-07 2:16  Pls rate my answer if it is working well Senthil Re: DateTime _Oct2007 r a j u u30-Oct-07 2:19 r a j u u 30-Oct-07 2:19  May I know where u r working..If u feel good tell me. Thanks.. Rajendran Re: DateTime _Oct2007 Senu Gandhi31-Oct-07 1:48 Senu Gandhi 31-Oct-07 1:48  Hi Rajendran, I am working in Pricol Ltd, Coimbatore as Dev lead. How about u? Senthil Re: DateTime _Oct2007 Andy *M*30-Oct-07 2:36 Andy *M* 30-Oct-07 2:36  Senu Gandhi wrote: Pls rate my answer if it is working well It is rude to solicit votes. Re: DateTime _Oct2007 Senu Gandhi31-Oct-07 1:49 Senu Gandhi 31-Oct-07 1:49  I am sorry Andy. Senthil Re: DateTime _Oct2007 Colin Angus Mackay30-Oct-07 3:05 Colin Angus Mackay 30-Oct-07 3:05  R a jendran wrote: already I voted for u...5/5 y u r saying like this..really good work.. I can't even read that. Can you stick to English please. Upcoming FREE developer events: * Glasgow: SQL Server Managed Objects AND Reporting Services ... My website Re: DateTime _Oct2007 r a j u u30-Oct-07 3:10 r a j u u 30-Oct-07 3:10  sorry ....i was read that hidden part thats Y replied again....i 'll correct it.. thanks Rajendran Re: DateTime _Oct2007 Colin Angus Mackay30-Oct-07 3:24 Colin Angus Mackay 30-Oct-07 3:24  R a jendran wrote: Y That is the penutimate letter of the modern English alphabet. It is not a word per se. Upcoming FREE developer events: * Glasgow: SQL Server Managed Objects AND Reporting Services ... My website Re: DateTime _Oct2007 soni uma30-Oct-07 2:09 soni uma 30-Oct-07 2:09  Ok This is work fine select DATENAME(MONTH,GETDATE()) + '/' + Cast(DatePart(year,getdate()) as varchar) Have nice time Re: DateTime _Oct2007 r a j u u30-Oct-07 2:18 r a j u u 30-Oct-07 2:18  Thanks for reply...already senu gandhi sent me that solution...I solved that problem ... Thanks.. Rajendran Problem with GetSchemaTable stofel30-Oct-07 0:22 stofel 30-Oct-07 0:22  Hi, I have a problem with a sql-Statement. I’m developing an application in which a user can type in a sql-statement, e.g. "Select * from (select name from employee)" . This statement is not very reasonable but it is syntactically correct. My code is OracleCommand cmd = new OracleCommand("Select * from (select name from employee)", myOracleConnection); OracleDataReader rdr = cmd.ExecuteReader(CommandBehavior.KeyInfo); System.Data.DataTable colinfo = rdr.GetSchemaTable(); At this staement the application crashed with an exception: "InvalidOperationException: Identifier expected or identifier in quotes expected" . (The message is in germaan: "Syntaxfehler: Erwartet wird ein Bezeichner bzw. Bezeichner in Anführungszeichen.", but i try to tranlate it in english) I want to use GetSchemaTable to get all the columninformation I needed to display the result. So how can I solve the problem ? Thanks in advances Willibert Re: Problem with GetSchemaTable andyharman30-Oct-07 7:21 andyharman 30-Oct-07 7:21  Does it work if you specify a table alias:   Select * from (select name from employee) a That should make the SQL legal. Re: Problem with GetSchemaTable stofel30-Oct-07 21:50 stofel 30-Oct-07 21:50  Hi, Select * from (select name from employee) is a legal statement, OracleClient and Toad could execute it. I could by-pass it, I change OracleDataReader rdr = cmd.ExecuteReader(CommandBehavior.KeyInfo); into OracleDataReader rdr = cmd.ExecuteReader(CommandBehavior.SchemaOnly); But their I don't get the basistablename even in a normal select. Tanks Willibert Need query micydon30-Oct-07 0:01 micydon 30-Oct-07 0:01  Hi My requirement is i hve 4 tables Specmast(specification,wgt,min) specgen(specification,wgt,min) specem(specification,wgt,min,em) specdes(specification,wgt,min,desg). All the specification i hve stored in the first table. Now what i want is in specgen i hve to get those specification details from specmast which are not in specem and specdes. How can i give query for this Pls help me this is very important Thanks in advance Regards Micydon Re: Need query r a j u u30-Oct-07 0:24 r a j u u 30-Oct-07 0:24  Select * from Specmast where specification not in(select specification from specem,specdes) u will try this query.... Rajendran Re: Need query Senu Gandhi30-Oct-07 0:32 Senu Gandhi 30-Oct-07 0:32  Micydon , Select specification,wgt,min from Specmast Where specification not in (Select e.specification from specem e Inner join specdes d on e.specification = d.specification ) This will work Senthil Timeout expired Senu Gandhi29-Oct-07 23:36 Senu Gandhi 29-Oct-07 23:36  I am working on .Net 2.0 and SQL 2000. While running my application, during dataset fill I get the following error "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" I tried setting connection timeout to 0 and command timeout to 0. This is the code: public DataSet FillDatasetSQL(string strQuery) { try { //-----Connection open sqlConn = new SqlConnection(strSqlConn); sqlConn.Open(); //-----Fill Dataset DataSet ds = new DataSet(); sqlAdap = new SqlDataAdapter(strQuery, sqlConn); sqlAdap.Fill(ds, "Tablename"); <=========== error occurs here //-----Connection close sqlConn.Close(); sqlConn.Dispose(); return ds; } catch(Exception ex) { if (sqlConn.State == ConnectionState.Open) sqlConn.Close(); sqlConn.Dispose(); throw ex; } } Please help Senthil

Last Visit: 31-Dec-99 18:00     Last Update: 5-May-24 13:54 Refresh ᐊ Prev1...1359136013611362136313641365136613671368 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

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