I have mograted a simple DTS package to SSIS 2008. All seemed fine during migration.
Step 1: delete contents of an MS Access table - works fine
Step 2: transfer rows from SQL tables to MS Access table - Works fine
Step 3: FTP MS Access DB using a control file - will not parse/test.
I get a red exclamation mark against step 3 and the error:
Package Validation Error (Package Validation Error)
Error at FTP using control file [Execute Process Task]: File/Process "" is not in path.
Error at FTP using control file: There were errors during task validation.
32 flags, DataWarehouseProjectManage
r manager, IOutputWindow outputWindow, DataTransformationsProject
tem prjItem, String taskPath)
Not sure what this means. I look at the properties of the task and it has (what I think should be) the correct info.
arguments is correct path to the ftp txt file containing paths and authentication details
executable is ftp.exe
working directory is C:\WINDOWS\system32
Other than that I am not sure what else should be set or what is wrong with the current settings