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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2007-08-03 : 01:39:45
|
| Hi allI need help ..I want to create one SSIS...my requirement is I have text file having three column like 300;Dev Fot;30097400;Kit Mol;79684now i have to insert this in DB with SSIS but at the same time I want another column insert in DB table with IDlike 1;300;Dev Fot;300972;400;Kit Mol;79684my table structure isTable_name (ID not null,EmpID not null;desc Not null;FinID Null)my input to package is my text file path and ID How shud i process??T.I.A |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-03 : 11:17:17
|
| Make id column identity so sql will generate value for the column. |
 |
|
|
|
|
|
Add extra column in DB table through SSIS