Search results for query: *

I am getting an error that the file already exists. How can i successfully increment to the next letter? if the file with 'A' doesn't exist, the file will be written, but it it does, I get an an error that it exist. i need to go to the next letter if this is recognized. I tried, do loops...

Hi. I have an application that moves files to a folder every 20 minutes. My users told me that there are bound to be duplicate files and that they usually handle the duplicates by manually adding letters to the files: Microsoft-IE8-23809-02.edi at 10am this comes in again and becomes...

Hello. I created a console application (I don't need the actual window) which runs perfectly on my development box. But when I run the application on the production server, the process does not run. I just copied the .exe file from the bin\Debug folder to a new folder on the Production...

I am creating a package in SSIS which imports CSV files and dumps the data into a few tables. The files are initial csv reports run by the user and then saved to the folders that the package searches. The problem is that the csv files contain a field for the title which has the following...

I created a package in SSIS which inserts data into a table from a flat file. The table is Logs_ASRUN. I am planning for the fact that the flat file the user pulls may have records that already exist in the table. So I created another table called Logs_ASRUN_all, whcih should have the clean...

Hello. I have a package that imports data from a flat file source to a sql server destination. I want to check to data to determine if the record already exists before importing. Is there a way to do this in my package? For example, there are 2 columns main: program and programming code and...

I have a small macro where I need delete all rows with dates: Sub allDates() Dim i As Long For i = 1 To Cells.SpecialCells(xlCellTypeLastCell).Row Debug.Print Cells(i, "a").Value If Cells(i, "a") < "6/1/2010" Then Cells(i, "a").EntireRow.Delete...

Hello. I want to record changes to a table when a user tries to delete a record. I initially thought that a Delete Trigger would be sufficient, but after searching online, I realize that a BEFORE DELETE statement may be better. I am using sql server 2005. how would the trigger be called from...

I have a rather funky text file, in which most of the information runs in columns and one portion runs in a row: Unit address / Type / Name | | Authorization Tier Mask ------------------------------ -------- 000-03136-65330-122 DC2 Cat epoch # 045, ID 0606...

Hello. My cousin is having a big problem with his computer. Earlier he kept getting pop-ups. So, he did a system scan with McAfee- full scan and short scan. McAfee asked if he wanted to shut down and he did so. He received a message that said no disk space. He was able to restore his...

Hello. I have a simple gridview that employs add/edit/delete events. My delete event is working perfectly, but I am getting an error in update event. I checked my actual stored procedure and all of my parameters are present. I am not sure why i am getting the error. I am doing most of work...

I have a small application that uploads, copies and then logs the actions to a text file. I have my functions enclosed in try/catch statements, but the application seems to still move, copy the files and write to the log even if the upload was unsuccessful. Could this be happening because of...

One of my reports is returning the incorrect data for the user who made the last update. The report is showing the system user (or only the system admins) who made changes, and not the actual user. So if for example, John updated his password, but Jill is the actual system administrator who...

I have a small program that allows files to be uploaded, moved, and the evidence written to a text file. However, I getting the following error: Error: The files have not been copied or archived. System.ObjectDisposedException: Cannot write to a closed TextWriter. at...

Hi. I have the following data where the duplicates are the episode numbers. The problem is that there is a date associated with each record. I need to show the date as well as the program title in addition to the episode. I executed a delete process, but the duplicates are not removed...

I have a gridview in which I want my client to be able to edit and add information. I am getting an error on updates as well as adding the records. I am getting the following error for edit: There was an error updating the information for record 224 System.NullReferenceException: Object...

Hello. I need to import text files over a four year period (which is well over 1000 text files). The text files are tab delimited (text is organized in columns...tab delimited right?) and I only want 4 columns from the files. The text files have headers. I was thinking that my best option...

Hello. Can anyone tell me how to properly combine Sql String Functions? I have the following data to export and I need to remove everything after the first hyphen. Everything else is either an episode number or a description. Program SPECIALS-MVSP7EDDIE - ENTIRELY EDDIE...ENTIRELY...

I have 2 spreadsheets to compare. I need to perform a search on 1 column, 'Episodes Missing from Master' in the Spreadsheet1 to see if any of the numbers appear in the Spreadsheet2. Everything has to be copied to Spreadsheet3, with details on the episodes found or not found. Spreadsheet3...