December 27, 2011 at 5:09 pm
Hi All,
I had text file of customer from all over the india.
the column name is custname,custstate,custzipcode.
But i want to integrate this data in to SQL Server Database.
But i want differentiate all cust records according to state wise.
But i am using conditional split in data transformation task.
please help me how to configure this transformation.
Thanks in Adavnce,
Jignesh
December 28, 2011 at 9:42 am
Why do you want to use the conditional split? How will this solve your issue?
Raunak J
December 30, 2011 at 9:54 am
So I understand you want a different record set for every state? You can dump all the data into one table and create a procedure that pulls the data by accepting a parameter for state, or if null pulls everything. I think we need to understand you purpose better. If for reporting, SSRS can create a report that will group/summarize data by state. If you need to create a out file for every state then you can do that using bcp command in a cursor within a proc. Do a lookup of BCP.
----------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply