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

Hi All, I have this problem that i could not solve for two days.I have tried to google and only with No luck. I have tried to get the WEBDEV.WEBSERVER.exe file from a working machine.I have also tried to stop and start IIS. However the error still comes Up. I am Running windows Xp. Is there anything i can do please? Your help is much appreciated. Thank you

modified on Tuesday, May 13, 2008 7:51 AM

Your Help is much appreciated, What i want mark now is how to select files that are not picked up from the Ftp site and only load them as they are not copied. That is to say for instance You Have a file name : -- 20080430_11.csv file generated from Ftp site at 11 O'clock today. and --20080430_12.csv for 12 hours ftp. How will the FTP task remembers that it has copied one file but not another one? Thank you once again. Reagrds

modified on Wednesday, April 30, 2008 11:53 AM

Thank you mark, I have manged to copy the file from the FTP task to the local Pc where SQl is running.However now would like to update my table with the Bulk Insert task in to the table. How will I make sure that every 30 Minutes its getting a new file from the Ftp and then Insert it to My table in Sql2005.No Duplicated data will be enterd in to the table more than once. As I am dumping the file on two one folder how will the bulkinsert task remembers this file is used and the other one is going to be used. Thank you

Hi all, I am trying to fetch a CsV file from an Ftp site on to a SQL table every three hours.The Csv has the same fields as the table in Sql. How do i go about this problem? your ideas are most appreciated. Please advice. Thank you

Hi All, I want to count records any time from Mid day(12:00:00.000') of a given date up to the next day MID Day get all the count in to the first date. For instance for a date '2008-04-23' count is made between '2008-04-23 12:00:00.000 and 2008-04-24 12:00:00.000'. If my date Query is Between '2008-04-20' and '2008-04-23' then 1. '2008-04-20' --------- count on '2008-04-20 12:00:00.000 and 2008-04-21 12:00:00.000'. 2. '2008-04-21' ---------- count on '2008-04-21 12:00:00.000 and 2008-04-22 12:00:00.000'. etc.. Can you give me a script for this one? Thank you regards

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.

Thank you very much for your response.Its much appreciated.To be very specific i have used the Ftp Task to download the file from the FTP server to a local Pc where the Sql Database runs.The next step is to Upload the file on to the Sql table i have used Bulkinsert Task.I have manhed to upload a flat file (*.txt) file.However when i Use a Csv File excatly in the same format to the flat file It doesnot copy the data on to my table. I hope its clear now. Thank you

Hi All, Could you please let me know how to set up a CSV file transfet from an FTP site to a Table in a SQL Database table ? Do i have to use Ftp Bulk Insert Task? How do set up? Please advice. Thank you

Hi all, I am trying to bulk insert a Csv file from an FTP site to a table in SQL2005.Can any one advice me on how to do it using SQl server integration services.(SSIS package) I havent used this before ,however i have seen an FTP task on the tool box. Your views are much appreciated. Thank you

Hi all, I am trying to bulk insert a Csv file from an FTP site to a table in SQL2005.Can any one advice me on how to do it using SQl server integration services.(SSIS package) I havent used this before ,however i have seen an FTP task on the tool box. Your views are much appreciated. Thank you

Hi All, I am trying to get a file from an Ftp and Copy data (*csv file) on to one of my tables in SQL 2005 database. I am not sure but SQL server 2005 integration service has a way to create a package that allows me to do this task. Can any one tell me how to go about it? your ideas are much appreciated. Thank you

Thank you very much.Your help is much appreciated. Can you please give me a little more tips please? Thank you.

Hi all, Can you please assist me with any relevant code in Csharp/ASp.net that helps me reading a CSV file off an Ftp site and populate a table in my database. Thank you very much.

Hi Guys, Accedientally i delted a record in table when i was trying to do it on a temporary table.How do i recover the data in the table.Could you please let me know to ROll Back my data in table. Your help is much appreciated. Thank you Kibrom

Hi All, Could you please let me know how to set up a trigger for the following senario? How could i setup a trigger to populate a back_up table every time i do an Insert on the master Table. //-------------------------------------------------------------- INSERT INTO [repor32].[dbo].[Master_table] SELECT * FROM [repor32].[dbo].[Back_up] WHERE [ADETDATE] NOT IN (SELECT [ADETDATE] FROM [repor32].[dbo].[Master_table]) Thank you

whats wrong with you man!Can you please be Polite. Take it easy.

Thank you very much for your response. How will i setup the following URL to run every 2 hour. http://localhost:1257/Update\_Table/Default.aspx Thank you kibrom

Hi All, I a page in ASP.net i want this page to run every two hours with out any manual intervation. How could i do it please? Inshort,i want the application to execute itself every two hours. Thank you.

Hi All, I a page in ASP.net i want this page to run every two hours with out any manual intervation. How could i do it please? Inshort,i want the application to execute itself every two hours. Thank you.