forum.venkateswarlu.net
      Register      Login
A scenario:

1 replies to this topic

Soujanya Chava #1
Member
32 Points
 Posted on 14 May 2012 03:45 PM IST
Want to insert a text file into database table, but during the upload wantto change a column called as months - January, Feb, etc to a code, - 1,2,3.. .This codecan be read from another database table called months. After the conversion of thedata , upload the file. If there are any errors, write to error table. Then for all errors, readerrors from database, create a file, and mail it to the supervisor.How would you accomplish this task in SSIS? 
SSIS     939 views     Reply to this topic
Ravikrishna Avula #2
Member
22 Points
 Replied on 31 May 2012 11:08 AM IST Hi,

Actually you scenario is not that much clear to understand. What data the plain text file contains?? this textfile contains months data or what? could elabarate more? 
Reply to this topic