SQLServerCentral / Discuss Content Posted by J.D. Gonzalez / Article Discussions / Article Discussions by Author / The SSIS File Sweeper / Latest Posts

RE: The SSIS File Sweeper

davidspeare — Tue, 18 May 2010 17:54:21 GMT

Has anyone seen any tool or code that will actually script out the ssis package?

RE: The SSIS File Sweeper

ed 42468 — Mon, 17 May 2010 22:42:44 GMT

All of the others code should be put in a Try block. The Catch block at a minimum should contain the statement:Dts.TaskResult = Dts.Results.Failure

RE: The SSIS File Sweeper

Gaurav.Vinodkumar — Mon, 17 May 2010 12:44:20 GMT

Thanks All...this makes sense now.Gaurav Mittal

RE: The SSIS File Sweeper

J.D. Gonzalez — Mon, 17 May 2010 12:26:40 GMT

[quote][b]jreece (5/17/2010)[/b][hr]Gaurav,He left out some important details about the inner loop. That one should be configured as a Foreach File Enumerator, not and ADO enumerator. The rest of the instructions will make more sense once you select the right enumerator. It's on the Collection tab of the Foreach Loop Editor.HTH,Jean[/quote]I appears that I left that out. There are two foreach loops. One is to get the data that contains which folders you want to evaluate and the inner foreach loop does the actual deleting.

RE: The SSIS File Sweeper

jreece — Mon, 17 May 2010 11:57:59 GMT

Gaurav,He left out some important details about the inner loop. That one should be configured as a Foreach File Enumerator, not and ADO enumerator. The rest of the instructions will make more sense once you select the right enumerator. It's on the Collection tab of the Foreach Loop Editor.HTH,Jean

RE: The SSIS File Sweeper

SQLRNNR — Mon, 17 May 2010 11:42:07 GMT

Thanks for sharing.

RE: The SSIS File Sweeper

Gaurav.Vinodkumar — Mon, 17 May 2010 10:35:55 GMT

Hello Mr. Gonzalez,I am confused on how the properties Directory, FileSpec, Resource are assigned to variables...based on my understanding the foreach loop container(Locate Files) has ADO enumerator and in this case the container will not show these propoerties...Are there properties (Directory, FileSpec, Resource ) are assigned in the "Check for Delete" container?If yes then what will be the enumerator and connection string in this container...thanks for help on this.Gaurav Mittal

RE: The SSIS File Sweeper

Manie Verster — Mon, 17 May 2010 02:38:27 GMT

Mr.Gonzalez,I apologize for the "File" part. I never saw the part where you said at the top we must add System .IO.

RE: The SSIS File Sweeper

Manie Verster — Mon, 17 May 2010 02:23:43 GMT

Dear Mr Gonzalez,Your article lack somewhat in explanation. You keep refering to "your example" and "if we used your example" but then you use variables that was not created in your article. The table you created has the following names:filePath, pattern, daysToKeep, includeSubFoldersYou created variables:daysToKeep, fileMetaData, filePath, includeSubFolders, patternbut all of a sudden you talk about a variable called FileName???? Maybe I am silly, stupid or just incompetent but now I do not know whether you meant filePath or should I create a variable "fileName". I am rather new in ssis but not in visual studio so I sort of find my way around and tried to do this but till I came to the scripting portion and Visual Studio give me an error. "File" is not defined. I am stumped. I do not know enough and would like to use ssis more often. :hehe::hehe::hehe::hehe::hehe::hehe:

The SSIS File Sweeper

J.D. Gonzalez — Sat, 15 May 2010 13:55:38 GMT

Comments posted to this topic are about the item [B]The SSIS File Sweeper[/B]