Cannot get file list to work

Mar 20, 2013 at 4:31 PM
I currently use sftp task to pull down files succesfully and it works great. Now I am trying to get a list of the files and put them in an object variable, but it keeps failing. I have seen two different error messages "[SSISSFTTask] Error: Error : Object reference not set to an instance of an object." and sometimes i receive an error that a value cannot be NULL. The "object reference" error happens 99% of time.

and sometimes if I set a breakpoint on pre-execute wait 10-15 seconds it works!?! This does not work 100% of time otherwise I would just set a task to wait 10-15 seconds then execute.

This is running on BIDS version 2008 on a windows 7 desktop.

Screenshots are at below links. I blotted out sensitive info.

pic.twitter.com/0ILTgG18Jn
pic.twitter.com/cnGBp4IZzF
pic.twitter.com/Zt797xvUkL
Coordinator
Mar 20, 2013 at 4:52 PM
Hi Nick,

Your Ftp_List variable, is an object type variable?

Thank you,
Cosmin
Mar 20, 2013 at 5:00 PM
Edited Mar 20, 2013 at 5:04 PM
Yes it is.
Mar 20, 2013 at 5:42 PM
I believe I have it working consistently now. I changed the package run time to 32 bit mode.
Mar 20, 2013 at 6:35 PM
I believe I have it working consistently now. I changed the package run time to 32 bit mode.
Mar 20, 2013 at 6:35 PM
I believe I have it working consistently now. I changed the package run time to 32 bit mode.