Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: SSIS - FTP TASK - DYNAMIC FILENAME

    Thank you for the validation. I was thinking along those lines also. The job is JUST small enough for me to try recreating the task, and if necessary recreating the...

  • RE: SSIS - FTP TASK - DYNAMIC FILENAME

    VERY HELPFUL lesson. The results in the variable are:

    User::FTPLocalPath {\\\\CorrectServer\\d_drive\\ABCD_DEPARTMENT_EXTRACT\\ABCD_DEPARTMENT_EXTRACT_20111101.txt}String

    For this file to exist the following was true and used successfully by a Data Flow Task (different variable name same...

  • RE: SSIS - FTP TASK - DYNAMIC FILENAME

    Excellent question and suggestion.

    Answer to Question: at the task, not during validation.

    I will try to set the breakpoint, however full disclosure: I haven't much experience with breakpoints and my feeble...

  • RE: SSIS - FTP TASK - DYNAMIC FILENAME

    My SSIS package was working perfectly. I populated the FTP Local Path via a variable FTPLocalPath that was an expression "@[User::ArchiveSourcePath] + @[User::RootFileName] + @[User::FileDateStamp]". Each of those variables are...

  • RE: Dynamic Connection String in File Connection Manager Throwing error

    Thank you for responding so fast!

    As soon as I changed that property and closed the dialog box I got this error:

    "TITLE: Microsoft Visual Studio

    ------------------------------

    Nonfatal errors occurred while saving the package:

    Error...

Viewing 5 posts - 1 through 5 (of 5 total)