July 30, 2012 at 5:23 am
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.
July 31, 2012 at 9:40 am
Hi,
Use SSIS Data transformation component "Conditional Split".:-)
August 1, 2012 at 11:31 am
Related post:
http://www.sqlservercentral.com/Forums/Topic1337190-147-1.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply