Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DCSage
  • Order by date
  1. DCSage

    Need help incrementing, won't go past 1 in loop

    ...{ string dupePathDir = @"J:\Dealmaker\EDI_TG\Sent to MSA\"; String[] thebigFiles = Directory.GetFiles(dupePathDir, "*.edi"); string newfilename = Path.GetFileName(somefile); string extension = Path.GetExtension(somefile); string...
  2. DCSage

    Need help incrementing, won't go past 1 in loop

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

    Need help incrementing, won't go past 1 in loop

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

    Moving Duplicate files, appending letters to the filenames

    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 =...
  5. DCSage

    Moving Duplicate files, appending letters to the filenames

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

    How to execute console application in task scheduler

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

    How to execute console application in task scheduler

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

    How to execute console application in task scheduler

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

    Error when using split function

    Thank you all so much!
  10. DCSage

    Error when using split function

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

    Error when using split function

    ...Integer Range("A2").Select Do Until IsEmpty(ActiveCell.Value) And IsEmpty(ActiveCell.Offset(1, 0)) If ActiveCell Like "*-*" Then ActiveCell = Left(ActiveCell, InStr(ActiveCell, "-") - 1) ActiveCell.Offset(1, 0).Select End If...
  12. DCSage

    Error when using split function

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

    Error when using split function

    I want to remove everything after the first hyphen.
  14. DCSage

    Error when using split function

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

    Insert Trigger

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

    Insert Trigger

    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?
  17. DCSage

    Insert Trigger

    ...the following trigger, but it is incorrect as no data was inserted: if exists (select PrdNumber from Logs_Asrun Group By PrdNumber Having count(*) = 1) INSERT INTO Logs_Asrun_All (Title, PrdNumber, Network, ScheduleDate) SELECT Title, PrdNumber, Network, ScheduleDate FROM INSERTED...
  18. DCSage

    Check data within flat file before importing to database

    Thank you. I actually considered that as my altrnative.
  19. DCSage

    Check data within flat file before importing to database

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

    How to merged rows with dates in Excel

    I am looking into merge area now and trying to figure out how to implement it.

Part and Inventory Search

Back
Top