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 |
|
reddy444
Starting Member
5 Posts |
 Posted - 2013-11-27 : 08:25:44
|
| Hi i am new to ssis can any on explain the given scenarioWant 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.reddy |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-27 : 10:39:17
|
| you need a SSIS package with data flow taskthe data flow task will have flat file source and OLEDB destination.In between you will have lookup task to lookup table containing month details to get code------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
reddy444
Starting Member
5 Posts |
Posted - 2013-11-27 : 11:38:48
|
| Hi Visak,Thank You for quick reply. i am bit confused in setting the properties for lookup transform in between source and destination.how do i need to map the columns in lookup columns tab. so could you please explain the scenario in detail, i tried to upload screen shot of my screen but could'nt find the insert option here.please help.reddy |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-27 : 13:02:21
|
| yep..you need to map between month column from source to montn column in the other table. then select check box against Code field to get it added to data flow pipeline. Then in final step map Code field to correct field in your destination.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
|
|
SSIS PACKAGE