Extract multiple files from multiple directories with a data flow task

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 Stan Kulp » Extract multiple files from multiple...

20 posts, Page 1 of 2

1 2 »»

Extract multiple files from multiple directories with a data flow task

Rate Topic

Display Mode

Topic Options

Author

Message

Stan Kulp-439977

Posted Thursday, October 27, 2011 12:02 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 9:04 PM
Points: 79, Visits: 602

Comments posted to this topic are about the item Extract multiple files from multiple directories with a data flow task

Post #1196743

wlblee38

Posted Thursday, October 27, 2011 7:26 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 20, 2013 10:48 AM
Points: 6, Visits: 425

Good job, very well written and demonstrated. Awesome!

Do you have something for connecting to a remote sever and downloading files? I think that's the next thing you should add to this.

Thanks again, Super!

Post #1197291

Stan Kulp-439977

Posted Thursday, October 27, 2011 8:53 PM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 9:04 PM
Points: 79, Visits: 602

That's what this job actually does. I just used local directories for demonstration purposes.

You would simply change the directory path from c:\folder\ to \\server\folder\, if I understand your question correctly.

Post #1197307

deepak.a

Posted Thursday, October 27, 2011 10:50 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, August 13, 2012 10:04 AM
Points: 554, Visits: 861

Thanks For this article excellent explanation :)

Post #1197322

e.t.anicet

Posted Friday, October 28, 2011 7:33 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, January 09, 2013 8:25 AM
Points: 7, Visits: 82

Hi,

You have done a very good demonstration.
I did try what you have done in my visual studio 2005 but it doesn't work. It seems like the vb script code doesn't work well.
After I have configurated your package (MultipleFileExtraction2005.dtsx) in my 2005 environment, when I run it just the "Get list of data files" (Script task) and the "Loop through list of data files" (ForEach Loop task) what are became green and the other tasks not

Post Attachments

package.jpg (2 views, 70.28 KB)

Post #1197480

Stan Kulp-439977

Posted Friday, October 28, 2011 9:27 AM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 9:04 PM
Points: 79, Visits: 602

Sounds to me like it is not finding the data files. Make sure you have the paths set correctly, and files actually in the folders.

Post #1197547

e.t.anicet

Posted Friday, October 28, 2011 10:00 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, January 09, 2013 8:25 AM
Points: 7, Visits: 82

Yes you right, my data files were not into the correct location.
Thanks Wink

Post #1197567

Jeff Moden

Posted Sunday, October 30, 2011 1:17 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 7:36 PM
Points: 32,931, Visits: 26,820

1. What kind of privs does the SSIS job need to be able to run the VB.Net scripts for this job?
2. What kind of privs does someone need to run this job?

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1197829

mishaluba

Posted Sunday, October 30, 2011 2:50 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 5:54 PM
Points: 525, Visits: 617

Great package and article. Thank you! I am saving this one Wink

Post #1197835

Stan Kulp-439977

Posted Sunday, October 30, 2011 3:11 PM

SSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 9:04 PM
Points: 79, Visits: 602

It is the connection manager used by the SQL statement in the script task that determines whether the SQL statement can be executed.

If your connection manager is using authentication that would allow you to execute the SQL Statement in SQL Server Management Studio, it will allow you to execute that same statement from an SSIS script task.

Post #1197837

« Prev Topic | Next Topic »

20 posts, Page 1 of 2

1 2 »»

Permissions