Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Send file with dynamic name through SFTP Expand / Collapse
Author
Message
Posted Wednesday, October 17, 2012 1:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 22, 2013 9:26 AM
Points: 3, Visits: 11
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.
Post #1374036
Posted Wednesday, October 17, 2012 2:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 22, 2013 9:26 AM
Points: 3, Visits: 11
Does anyone have any idea on this? Thanks in advance.
Post #1374063
Posted Thursday, October 18, 2012 1:08 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, April 18, 2014 4:07 AM
Points: 849, Visits: 768
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
Post #1374168
Posted Thursday, October 18, 2012 7:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 22, 2013 9:26 AM
Points: 3, Visits: 11
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?
Post #1374340
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse