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

Creating Dynamic Outputs in SSIS Expand / Collapse
Author
Message
Posted Tuesday, August 17, 2010 9:50 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 2:57 AM
Points: 405, Visits: 1,137
Tim - Thanks for posting.

I've managed to create a dynamic ETL process to split data into SQL tables (including creating the table if required) using this process with a few mods and it works like a charm!



_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #970547
Posted Tuesday, August 17, 2010 10:10 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 1, 2014 1:40 PM
Points: 1,045, Visits: 2,724
Dave,

That might make a good article in itself :)

Tim




Tim Mitchell, SQL Server MVP
Independent Business Intelligence Consultant
www.TimMitchell.net
@Tim_Mitchell

Post #970565
Posted Wednesday, August 18, 2010 2:13 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 2:57 AM
Points: 405, Visits: 1,137
Sure,

I've got no problem in creating an article for it. Should be pretty quick to knock together.


_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #970974
Posted Wednesday, November 10, 2010 7:47 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 11:09 AM
Points: 3,098, Visits: 786
Thanks Tim. Followed this article step by step with no problem.

Thomas


Thomas LeBlanc, MCITP DBA 2005, 2008 & MCDBA 2000
http://thesmilingdba.blogspot.com/
Post #1018620
Posted Wednesday, March 21, 2012 10:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 20, 2012 4:34 PM
Points: 1, Visits: 18
Hi Tim,
Great article, your solution worked perfectly for me. I was wondering if you could point me in the right direction or expand on your article to enable dynamic Folder creations? I would like to learn more about being able to output a file and create a directory that relates to it:
EG:
\Site1\Site1.txt
\Site2\Site2.txt

Thanks for your time.
Post #1270613
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse