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"...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.