Creating Dynamic Outputs in SSIS

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 Tim Mitchell » Creating Dynamic Outputs in SSIS

15 posts, Page 2 of 2

««1 2

Creating Dynamic Outputs in SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

dave-dj

Posted Tuesday, August 17, 2010 9:50 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 11:47 AM
Points: 380, Visits: 1,014

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! BigGrin

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)

Post #970547

Tim Mitchell

Posted Tuesday, August 17, 2010 10:10 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 4:11 PM
Points: 1,033, Visits: 2,593

Dave,

That might make a good article in itself :)

Tim

Tim Mitchell
SQL Server MVP
www.TimMitchell.net
twitter.com/Tim_Mitchell

Post #970565

dave-dj

Posted Wednesday, August 18, 2010 2:13 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 11:47 AM
Points: 380, Visits: 1,014

Sure,

I've got no problem in creating an article for it. Smile

Should be pretty quick to knock together.

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)

Post #970974

Thomas LeBlanc

Posted Wednesday, November 10, 2010 7:47 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 3:33 PM
Points: 2,703, Visits: 717

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

aecusack

Posted Wednesday, March 21, 2012 10:03 PM

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

15 posts, Page 2 of 2

««1 2

Permissions