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 «««123

Real World Foreach Loop Container example Expand / Collapse
Author
Message
Posted Friday, November 13, 2009 1:37 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 5:00 PM
Points: 51, Visits: 798
x
Post #818865
Posted Friday, November 13, 2009 1:40 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 5:00 PM
Points: 51, Visits: 798
mona.togatorop (5/21/2008)
I'm new to SSIS so this might be a very basis error but I'd appreciate some
help...

I've got error in Delete Old log File (File system Task) :

Variable VarDeleteFileSName is used as a source or destination and is empty



Please help me..

Thank you


I know this is six months late, but I resovled this exact scenario by placing a default value for varDeleteFileSName when declaring the global variable in the package. After that, the File System Task ran as expected. I supposed it needed to know there was a value before it executes. And because the script had not yet assigned a value to the variable, the File System Task would not start.
Mark Maddox.
Post #818867
Posted Wednesday, March 31, 2010 1:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 31, 2010 2:32 PM
Points: 1, Visits: 13
Hi
veru use full information. I have another type of question. I have used Foreach loop to import multiple files. But if one file has some problem whole package is erroring out, Instead of going for another file it stops.

How do I solve this problem ?


Saritha
Post #894182
Posted Friday, April 8, 2011 4:56 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 9:19 PM
Points: 1, Visits: 61
I would like to note that as of 4.8.2011, the images in the article are not viewable and give broken link errors. Thanks.
Post #1091004
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse