Ssis Package For Moving/renaming File

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rush81
    New Member
    • Feb 2008
    • 6

    Ssis Package For Moving/renaming File

    i'm trying to create an ssis package for renaming and moving the file. It gives error at the file system task:

    [File System Task] Error: An error occurred with the following error message: "Could not find file 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\a bc123.xlsabc.xl s'.".

    the file is abc123.xls. Now why is it pointing to the C drive?

    I have set up five variables as FileName, SourcePath, DestPath, FullSourcePath and FullDestPath.

    Can I get some help on this asap

    thank you in anticipation
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    If your file is "abc123.xls " why is it looking for "abc123.xlsabc. xls". Check your dynamic query. It looks like you need a space there.

    -- CK

    Comment

    Working...