October 17, 2012 at 1:59 pm
Hi,
I appended date and time(yymmddhhmm) to the csv file generated by the SSIS package through adding variables and expression in the connection string.
However, when I tried to send the file through SFTP task, the package failed to run and return message: 'Source: SFTP Task SFTP Task Description: The File "Flat File Connection Manager" doesn't contain file path(s).'
I set the local 'flat file connection manager' in my SFTP task. It worked well in the past but started to have issue recently.
Could anyone help out?
Thank you very much.
October 17, 2012 at 2:55 pm
Does anyone have any idea on this? Thanks in advance.
October 18, 2012 at 1:08 am
I have had a similar problem. I tkink I solved it by setting the root folder. It was looking in the wrong folder.
Ian Cockcroft
MCITP BI Specialist
October 18, 2012 at 7:22 am
so you mean by setting the local the root folder?
I think the issue is also related to the running time of package..It only happens when it takes more than 1 min to run...as I append hour and min to the file name, I wonder is it because when the file finishes running, SFTP can't find the file attached with current time?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply