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!

  • Congratulations Mike Lewis 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: *

  1. kccoolrocks

    SSIS FTP task - folder is not showing in the development environment

    I need to automate an excelsheet transformation process. for that I need to take the file from a ftp location. I can see all folders and the required folder "xyz" in the ftp location when we browse it within the SSIS 2005 FTP task from my laptop. I also can see all the folders except "xyz"...
  2. kccoolrocks

    FTP folder location is not showing in the production server but exist in the development server.

    Thanks kindly for your reply. User name and Password is working. this is not only a FTP transaction, we need automate the process to get the file from the ftp location and do some transformation. i can se all the other folders in the FTP server location "t01/app/" except "_res" folder in the...
  3. kccoolrocks

    FTP folder location is not showing in the production server but exist in the development server.

    Hi, a wired glitch in my SSIS 2005 package in production server where the FTP folder location is not showing but its existing in my laptop version EX: - t01/app/_res folder When i open the package from the production server "res" is not showing within the remote path in the file transfer...
  4. kccoolrocks

    Find fist character if its '-' and replace space

    Hi, need to find the fist character if its '-' and replace space in the derived column. thanks, ab
  5. kccoolrocks

    Loop through excelsheet rows and lookup another sheet

    Hi, Have an excel sheet with 20 Columns. One Column has a Concatenated two vlookups that referes to another sheet. Eg: Sheet one InsuranceType column includes - CONCATENATE((VLOOKUP(Q2,'Sheet2'!AX:AY,2,FALSE))," / ",(VLOOKUP(R2,'Sheet2'!AX:AY,2,FALSE))). Q2 and R2 get two different offers and...

Part and Inventory Search

Back
Top