Real World Foreach Loop Container example

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Paul Clancy » Real World Foreach Loop Container example

24 posts, Page 2 of 3

««1 2 3 »»

Real World Foreach Loop Container example

Rate Topic

Display Mode

Topic Options

Author

Message

Paul Clancy

Posted Friday, February 29, 2008 3:38 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:48 PM
Points: 41, Visits: 175

Sorry I couldn't get back to you earlier on this and save you the long search, but the cause of your problem was the OLEDB connection. My example uses an ADO.NET connection for the Execute SQL Task (this wasn't explicitly mentioned in the article - my apologies), in which case you need to use the (@FileName) syntax as described on the article.

Post #462236

laura garcia

Posted Thursday, March 20, 2008 11:42 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, June 28, 2008 9:41 PM
Points: 8, Visits: 33

Oh, good, the (?) parameter works. You still have to do the Parameter Mapping in the Execute SQL task (the parameter name = 0).
Laura

Post #472456

mona.togatorop

Posted Wednesday, May 21, 2008 3:04 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, May 03, 2009 8:58 PM
Points: 1, Visits: 15

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

Post #504296

Paul Clancy

Posted Wednesday, May 21, 2008 7:55 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:48 PM
Points: 41, Visits: 175

You'll need to do a bit of debugging. The first place I'd look is in the SQL statement that populates the varDeleteFileList variable; if you run this as a query in the Management Studio do you get a result set? If not, that's your problem.

If you do, try adding breakpoints in the script code just before the Dts.TaskResult line (for instance). That way you'll be able to see which (if any) values are being passed along.

Post #504481

to.bobs

Posted Saturday, February 14, 2009 9:30 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, November 14, 2009 8:49 AM
Points: 2, Visits: 10

Paul - Just wanted to thank you for putting this "Real World" article up. I'm working on adapting an existing full-blown ETL/OLAP iterative process to use SSIS looping tasks to provide high-level control of detail low-level SP processing. The details of your Var defs, DeleteList DataFlow, and Convert Object variable script were just what I was looking for - thanks for taking the time to do this.

-- BobS --

Post #657174

Paul Clancy

Posted Saturday, February 14, 2009 2:11 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 12:48 PM
Points: 41, Visits: 175

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

Post #657248

oleg yuriev-460662

Posted Sunday, July 26, 2009 11:34 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, November 29, 2011 3:50 PM
Points: 2, Visits: 42

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?

Post #759886

sam arteaga

Posted Wednesday, July 29, 2009 6:05 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 16, 2009 5:16 PM
Points: 1, Visits: 80

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

Post #762054

thierry.vandurme

Posted Friday, November 13, 2009 3:20 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 2:48 AM
Points: 582, Visits: 287

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? :)

Post #818342

alen teplitsky

Posted Friday, November 13, 2009 12:22 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:15 PM
Points: 1,409, Visits: 4,509

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

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]

Post #818798

« Prev Topic | Next Topic »

24 posts, Page 2 of 3

««1 2 3 »»

Permissions