Search results for query: *

Thank you jmeckley for your help! I had a few problems with the function and it's finally resolved: My main issue was the paths and my process. I failed to check the existence of the file in the destination directory. Final Code: public static string appendLetter(string somefile)...

Corrected code for letter, but won't go past 'a' if file exists still: string newfile; char letter = 'a'; int i = 0; while (i < 26) { newfile = fname + "_" + letter.ToString() + extension; if...

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...

I rewrote my function: foreach (string myfile in files) { //Grab Basic file information filename = Path.GetFileName(myfile); fu = new FileInfo(filename); string afile = fu.Name; String dest =...

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 figured out that the error revolved around my paths. Although I had the server information in my initial development code, for some reason, the paths were creating conflicts on production. I did the following in my code: string srcDir = @"J:\\Dealmaker\EDI\"; string src =...

Thanks for your quick response. I figure this has something to do with permissions. The admin just gave me full rights to the production server, bu tthe problem persists. Here's the breakdown on the files: I mapped the servers that I need to move the files around: A common string in...

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...

Thank you all so much!

sorry. the user pulls the information from a website and literally pastes the data into an excel worksheet (I have no control over this process). The users saves the file as a .csv file into a specified folder. I have a SSIS package that then loops over the files in the folder and exports the...

Thank you Everyone! The following is my completed code, which ran without errors: Option Explicit Sub ModifyShow() Dim cellData As String Dim x As Integer Range("A2").Select Do Until IsEmpty(ActiveCell.Value) And IsEmpty(ActiveCell.Offset(1, 0)) If ActiveCell...

I revised my code as i want to search through the entire A column. But when I run the macro from excel, I get the following error: invalid procedure call or argument revised code: Sub ModifyShow() Dim cellData As String Dim x As Integer Range("A2").Select Do Until...

I want to remove everything after the first hyphen.

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...

This works perfectly. I did the following: 1) I have an OLE DB Destination Data Flow Component. In the properties of this component, I typed, Fire_Triggers in the FastLoadOptions. good you direct me to a good resource on ssis? for my package, I want to integrate 2 processes - pull from 2...

the trigger is still not inserting anything into the table logs_asrun_all. when the ssis package executes, only the main table, logs_asrun, is receiving the inserted records. is there another way to approach the trigger perhaps within the package?

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...

Thank you. I actually considered that as my altrnative.

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 am looking into merge area now and trying to figure out how to implement it.