Error when moving a file in SSIS,

503 views Asked by At

"The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters"

That is the error whenever I try to move a file from one folder to other. The same file is getting loaded into a table but when I try to move, its throwing the error.

I am using a file system task to move the file from one folder to another. The file system task is throwing out that error.

Did anyone encounter the same error? How did you overcome? Please help me solve this error..

1

There are 1 answers

0
Raj On

There is a tool to address just this. Can be found at http://PathTooDeep.com

Alternately you can use expressions to rename and move the file using a File System task.