forum.venkateswarlu.net
      Register      Login
Interview Question(ssis)

1 replies to this topic

Harikrishna Sikhakolli #1
Member
108 Points
 Posted on 07 Jun 2012 07:09 AM IST I have a txt file.The data in the txt file like this
EMPID EMPSAL
12 12000
13 13000
14 14000
NAME NO
BUSNO BUSNAMe
PERSONNO PERSONNAME
Here data is a combination of numeric and headers data
I want superate the numeric data into one destination and
Header data into another destination.
How can we achieve this one and what are the transformations required to achieve this one. 
SSIS     689 views     Reply to this topic
Harikrishna Sikhakolli #2
Member
108 Points
 Replied on 14 Jun 2012 07:25 PM IST Here is the solution for the above Question
1.Here data is in .txt file
2.first take the flatfilesource in dataflow.
3.Take the data conversion transforamtion.
4.connect from flatfile source to dataconversion transformation.
5.In dataconversion transforamtion change the datatype of the column name empid as fourbytesigned int.
******Here we set configure error output option to REDIRECTROW in dataconversion transformation********
6.Take the two flatfile destinations.
7.Greenpath from dataconversion to one flatfiledestination.
8.Redpath from dataconversion to second flatfiledastination.  
Reply to this topic