Thank you very Much for your help.Its much appreciated. I logged in as an Administrator and checked the Debug is set to true.I cant even run a page with out debuggig mode. Its really a problem.Could you please advice me further??? Regards

You could use another FTP task to delete the file after you're done. Or you could try and rename it. I don't know if that is directly supported, but if you have permissions you could possibly rename your local copy when you're done, then upload it back to the ftp server and delete the original copy from the server. You could try and keep a local list of files you're already processed if you don't have permissions on the FTP server and use that to determine which files need to be downloaded and processed. Mark's blog: developMENTALmadness.blogspot.com

hope this will help you... select count(*) from myTable where [columndate] >= substring(convert(varchar,columnName,20),1,10)+' 12:00:00.000' and [columndate] <= substring(convert(varchar,columnName,20),1,10)+' 12:00:00.000' I Love T-SQL modified on Thursday, April 24, 2008 4:26 PM

Thank you Once again.On the Bulk insert progress it says : Bulk insert Task is Initiated ,and Bulk insert task is completed.However the actual data is not copied on to the table.Hope this will help. Thank you.

Please don't cross post. It's rude. Read the forum rules. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

Please don't cross post. It's rude. Read the forum rules. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

Use the FTP task to copy the file to an accessable directory, then you can create a data flow task which uses a flat file source, processes the file and then puts the data in the appropriate data flow destination. Your package designer should resemble this: FTP Task --> Data Flow Task Open the Data flow task (double-click) and it should resemble this: Flat File Source --> [intermediate transformations you may need (if any)] --> Sql Server Destination Just drag the items mentioned to the designer surface, open each item and set the properties needed. Mark's blog: developMENTALmadness.blogspot.com

http://msdn2.microsoft.com/en-us/library/system.net.ftpwebrequest.aspx[^] That has code examples on deleting a files on an ftp server, displaying files, and other useful information My current favourite word is: Nipple! -SK Genius

Did you take regular backups of your database? If so, restore from the last backup. If not, then you've lost it forever. Maybe this will teach you the importance of taking regular backups. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

I'm not sure that I understand the scenario here. Is this the query that you will use in the trigger? or is the query that makes the insert in the master? amyway, check the CREATE TRIGGER[^] syntax from msdn Hesham A. Amin My blog

As one of the messages on that article states..."what a mess". There is no way that using the Cache is a good way to schedule tasks, mostly because you cannot guarantee that the cached item will not be removed before you ask it to (ie, in low memory conditions). You end up having to bolt workaround after workaround on top of this olution to handle early expiration of cache items. Do yourself a favour and write a VBS and use windows scheduler as someone suggested above.

Google: SQL decryptor There are many products that handle this task.

Check this out http://support.microsoft.com/kb/914277[^] Vasudevan Deepak Kumar Personal Homepage Tech Gossips A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

kibromg wrote: I am trying to encode in to my website using Flash media encoder. Can any one let me about the parameter in My object tag? Are you suffering from some wierd form of whiplash that prevents you from raising your eyes to the top of the page and see that this forum is about C#? Deja View - the feeling that you've seen this post before. My blog | My articles

hi kibromg, First of all you are using internet, you must search on Google with your error as query to Google. Please check given link, hope this will help you. http://forums.asp.net/p/905409/1880054.aspx If this will not help you go to following link. It is Google query of your error. http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=HPND,HPND:2006-26,HPND:en&q=Unable+to+connect+to+visual+studio%27s+local+web+server First try to make research on the internet after that make query to forums. Thanks & Regards Dilip Kumar Vishwakarma Programmer .Net Consulting

kibromg wrote: Thank for your response.Let me explain it a bit further What response? This is your first post in the thread. kibromg wrote: I do not want to refresh my page i.e. every 5 seconds, i just want to refresh it ONLY on server change just like desktop applications do. I don't think this is possible. Web applications aren't the same as desktop applications. You're going to have to poll the server periodically to refresh the page. A good compromise would be to employ caching in your ASP.NET pages so that your pages aren't being built from scratch every time you hit the server. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

Hi, Thank for your response.Let me expain it a bit further Say i have a server process which listens for some changes in database. When a change occurs i want to refresh my page in browser by notyfinig it. I do not want to refresh my page i.e. every 5 seconds, i just want to refresh it ONLY on server change just like desktop applications do. The problem is that refreshing evry n seconds has to much impact on my web server. The refresh action should be taken only when something really happens that makes sense Is it possible ?

kibromg wrote: Step 2. I inserted the following anywhere inside the tags: <--> var OpSys = checkOS(); document.write(OpSys); //--> </--> You are using document.write inside a script. I guess it wont work. . Instead you can have a alert statement. kibromg wrote: <--> function checkOS() { if(navigator.userAgent.indexOf('IRIX') != -1) { var OpSys = "Irix"; } else if((navigator.userAgent.indexOf('Win') != -1) && (navigator.userAgent.indexOf('95') != -1)) { var OpSys = "Windows95"; } else if(navigator.userAgent.indexOf('Win') != -1) { var OpSys = "Windows3.1 or NT"; } else if(navigator.userAgent.indexOf('Mac') != -1) { var OpSys = "Macintosh"; } else { var OpSys = "other"; } <b>alert("OpSys");</b> return OpSys; } // --> </-->

kibromg wrote: Could you please give me an Html code/Java script code to detect an opertaing system before opeing a web page? Google[^] not working where you live? Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush