Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

ssis execel Expand / Collapse
Posted Monday, July 30, 2012 5:23 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 22, 2016 3:21 AM
Points: 216, Visits: 4,717

I'm working with a set of data from SQL Server that I'd like to get into a group of Excel files. This task needs to be automated to run on a monthly basis. The data looks like

Site ID FirstName LastName
------ ------- --------- ---------
North 111 Jim Smith
North 112 Tim Johnson
North 113 Sachin Tedulkar
South 201 Horatio Alger
South 205 Jimi Hendrix
South 215 Bugs Bunny
I'd like the results to look like

In Excel sheet named North.xls

ID FirstName LastName
111 Jim Smith
112 Tim Johnson
113 Sachin Tedulkar

In Excel sheet named South.xls

ID FirstName LastName
201 Horatio Alger
205 Jimi Hendrix
215 Bugs Bunny
There are between 70 and 100 values in the Site column that I'd like to split upon. I'm using SSIS to perform this task, but I'm getting stuck after I've pulled the data from SQL Server with a OLE DB Source task. What should come next? If there is an easier way to do this using other tools I'm open to that too.
Post #1337181
Posted Tuesday, July 31, 2012 9:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 18, 2013 4:25 AM
Points: 27, Visits: 40
Use SSIS Data transformation component "Conditional Split".
Post #1338000
Posted Wednesday, August 1, 2012 11:31 AM



Group: General Forum Members
Last Login: Thursday, October 6, 2016 8:43 PM
Points: 7,932, Visits: 14,339
Related post:

There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1338706
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse