Real World Foreach Loop Container example

Question

Real World Foreach Loop Container example

Viewing 9 posts - 16 through 23 (of 23 total)

You must be logged in to reply to this topic. Login to reply

Paul Clancy SSC Eights! Points: 858 More actions · Answer 1

My pleasure, thank you very much for your kind comments.

oleg yuriev-460662 SSC Enthusiast Points: 184 More actions · Answer 2

Just wonder how to set a folder (directory) using a global variable? When i use my variable Directory user:: , the SSIS finishes with message - "no files in the specified directory" (or something like that, no failure though). Yet , files are there and when i "hard-code" the path and execute the SSIS again, everything works. What am i missing?

sam arteaga Grasshopper Points: 13 More actions · Answer 3

Hi Paul,

I read your article and it helped me a lot. One question I have is how can I add the file creation date to my table?

Thanks a lot

Sam

thierry.vandurme Hall of Fame Points: 3340 More actions · Answer 4

Great article, thanks! Will help me to get started

But at the end you wrote: "And that's it! Running the package deletes all backup files that haven't been restored except the newest sixteen".

You do mean "that HAVE been restored", right? 🙂

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 5

great article

some time ago i played with something similar to import csv files with performance data but never got it to work in importing only the files that haven't been imported before. going to look at this again using a slightly modified version of your procedure

mmaddox 39987 SSC Enthusiast Points: 127 More actions · Answer 6

mmaddox 39987

SSC Enthusiast

Points: 127

November 13, 2009 at 1:37 pm

#1079246

x

mmaddox 39987 SSC Enthusiast Points: 127 More actions · Answer 7

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.

saritha.ijjurouthu Newbie Points: 5 More actions · Answer 8

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

phouse Newbie Points: 5 More actions · Answer 9

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.