Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tooba
Posting Yak Master
224 Posts |
 Posted - 2010-06-23 : 17:18:23
|
| Want to insert a text file into database table, but during the upload want to change a column called as months - January, Feb, etc to a code, - 1,2,3.. .This code can be read from another database table called months. After the conversion of the data , upload the file. Ifthere are any errors, write to error table. Then for all errors, read errors from database, create a file, and mail it to the supervisor.How would you accomplish this task in SSIS?Thanks in advance. |
|
|
|
|
|
Need Help