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 12»»

Extract multiple files from multiple directories with a data flow task Expand / Collapse
Author
Message
Posted Thursday, October 27, 2011 12:02 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:27 PM
Points: 123, Visits: 881
Comments posted to this topic are about the item Extract multiple files from multiple directories with a data flow task
Post #1196743
Posted Thursday, October 27, 2011 7:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 6:31 AM
Points: 6, Visits: 561
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
Posted Thursday, October 27, 2011 8:53 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:27 PM
Points: 123, Visits: 881
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
Posted Thursday, October 27, 2011 10:50 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, January 2, 2014 9:57 AM
Points: 554, Visits: 863
Thanks For this article excellent explanation :)
Post #1197322
Posted Friday, October 28, 2011 7:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 13, 2014 2:38 AM
Points: 7, Visits: 86
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
Posted Friday, October 28, 2011 9:27 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:27 PM
Points: 123, Visits: 881
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
Posted Friday, October 28, 2011 10:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 13, 2014 2:38 AM
Points: 7, Visits: 86
Yes you right, my data files were not into the correct location.
Thanks
Post #1197567
Posted Sunday, October 30, 2011 1:17 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:06 PM
Points: 36,711, Visits: 31,160
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1197829
Posted Sunday, October 30, 2011 2:50 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 8:42 AM
Points: 535, Visits: 750
Great package and article. Thank you! I am saving this one


Post #1197835
Posted Sunday, October 30, 2011 3:11 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:27 PM
Points: 123, Visits: 881
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 »

Add to briefcase 12»»

Permissions Expand / Collapse