October 11, 2011 at 10:10 am
Hi,
I am trying to send out reports appended with dates.
my package includes
file system task-->data flow task-->script task-->sftp task
i edited script task and the expression for the destination of the sftp task..however everytime i try to run it..the error shows up:
Description: The connection "ABC20111011.csv" is not found.
Source : SFTP TASK
i did not use variable in this package..when i tried with variable, it still does not work.
Could anyone help me out? Where should i edit the expression if i want to use variable? or did i miss something in my current method? I do it this way coz ppl did this before and it works fine...but it just does not work out for me..
Many thanks!!!!!!!!!!
October 11, 2011 at 12:00 pm
Does anyone have some ideas?
When i did it with variables, I
1.create a variable
2. edit the expression of connection string in the flat file connection manager in data flow task
3.edit the expression of local in the SSH connection manager
Though the file with dates (i.e ABC20111011.csv) is created in the folder, I am still not able to send it out..the error message is still 'the connectin 'abc20111011.csv' is not found', error source is SFTP task.
October 11, 2011 at 12:10 pm
Is that the existing file name or did you create that file name in your package?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 11, 2011 at 12:13 pm
Hi SQLRNNR,
I need to create that in my package and send it out.
Thanks!
October 11, 2011 at 12:18 pm
How are you getting to this:
Description: The connection "ABC20111011.csv" is not found.
Did you put a static connection to a file by that name in your package?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 11, 2011 at 12:22 pm
No. I got the date because I edited the expression of the connection string in the flat file connection manager, the queries I use are:
@[User::ABC] +(DT_STR,4,1252) DatePart("yyyy",getdate()) +
Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) +
Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2)+".csv"
I did not create a file with static name ABC20111011.CSV since the file is sending out everyday with different dates.
Thank you!
October 11, 2011 at 12:37 pm
multiple files or a single file?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 11, 2011 at 12:42 pm
Single file.
Did you happen to send out a report with dynamic dates appended before? How did you do that?
Thanks!!!
October 11, 2011 at 12:44 pm
Numerous times, each time has been different since it vastly depends on the requirements and what you already have created.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 11, 2011 at 12:45 pm
Please post the config screenshots for your sftp connection item.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 11, 2011 at 1:13 pm
Hi SQLRNNR,
Attached is the screenshot.
Please let me know if further info is required.
Many thanks!
Jochang
October 11, 2011 at 1:19 pm
I haven't used CozyRoc before. Have you checked this page for info?
http://www.cozyroc.com/ssis/sftp-task
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 11, 2011 at 1:24 pm
I am checking it now. Anyway, thank you very much!
October 11, 2011 at 1:29 pm
jozhang (10/11/2011)
I am checking it now. Anyway, thank you very much!
Sorry couldn't be of more assistance - I hope you get it straightened out.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 13, 2011 at 10:52 am
Hi SQLRNNR,
I tried it in a new way..seems that there is no error when the package is running...
1. I deleted the expression in the Cozy Roc SFTP Task and
2. simply set the local(similar to the destination thing in the file system task) of the SFTP task the flat file connection manager..
3.Set the DestinationConnection of the file system task the flat file connection manager
I understand you never used Cozy Roc before..but I guess the logic here is similar..I am just confused that will the SFTP task send the file(appended with dynamic date) created by the flat file connection manager?
Many thanks~~!!!!!!!!!!!!
Could anyone help?? Thank you very much!!!!!!!!!
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply