Solved

Wierd error while transfering data from FTP server using SSIS Package?

Posted on 2014-02-10
4
581 Views
Last Modified: 2016-02-10
i am working on SSIS package to recieve .csv files to my SQL DB.
MY FTP server is
ftp.sql.att.com

where i can find lot of csv files but i need to pick up only the before day report file so i am using varaible to check and connect to the previous date file.For that i am using below expression
"//Call_"+
RIGHT("0" + (DT_WSTR, 2)  MONTH(dateadd("d", -1, getdate())), 2)
+RIGHT("0" + (DT_WSTR, 2) DAY(dateadd("d", -2, getdate())), 2)
+(DT_WSTR, 4)  YEAR(dateadd("d", -1, getdate()))+ ".csv"

The output of varaible is     Call_02082014.csv


While executing i am getting below error


[FTP Task] Error: An error occurred with the following error message: "Object reference not set to an instance of an object.".


If with out using varaible if i connect directly to that .csv file SSIS task working properly but when i use varaible i am getting weird error.

Note:I cant run every day ssis package so that is the reason i cfreated varaible so it can check the date and pick up exact file..


Can any one help me to solve this issue please ..
0
Comment
Question by:GreatLakes07
  • 2
  • 2
4 Comments
 
LVL 17

Expert Comment

by:Barry Cunney
Comment Utility
Hi GreatLakes,
Please confirm if you have set the EvaluateAsExpression=TRUE in the variable properties
0
 

Author Comment

by:GreatLakes07
Comment Utility
Yes i set to TRUE.
0
 
LVL 17

Accepted Solution

by:
Barry Cunney earned 500 total points
Comment Utility
Hi GreatLakes
In the FTP Task Editor on the FileTransfer page, please confirm if you have set IsRemotePathVariable = TRUE
0
 

Author Closing Comment

by:GreatLakes07
Comment Utility
great
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now