Send file with dynamic name through SFTP

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Send file with dynamic name through SFTP

Send file with dynamic name through SFTP

Rate Topic

Display Mode

Topic Options

Author

Message

canny9832

Posted Wednesday, October 17, 2012 1:59 PM

Forum 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

canny9832

Posted Wednesday, October 17, 2012 2:55 PM

Forum 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

Ian C0ckcroft

Posted Thursday, October 18, 2012 1:08 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 13, 2013 4:26 AM
Points: 843, Visits: 746

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

canny9832

Posted Thursday, October 18, 2012 7:22 AM

Forum 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 »

Permissions