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 |
|
amaithani
Starting Member
2 Posts |
 Posted - 2008-06-12 : 08:10:50
|
| 1. I have a table lets say ABC in which the datatype of one of the column lets say MNO is int identity.3. Inserted some records into this table using SSIS. the values in the column MNO are from 1 till 202. i want insert more records into this table ABC using SQL task in SSISHow do i do this. can any body help me out.Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-19 : 11:24:39
|
quote:
Originally posted by amaithani
1. I have a table lets say ABC in which the datatype of one of the column lets say MNO is int identity.3. Inserted some records into this table using SSIS. the values in the column MNO are from 1 till 202. i want insert more records into this table ABC using SQL task in SSISHow do i do this. can any body help me out.Thanks in advance
Didnt understand difficulty in this. just useINSERT INTO YourTable (field1,field2,...)VALUES (val1,val2,..)all fields except identity field should be specified. the identity value will be autoincremented. |
 |
|
|
|
|
|
How to increment the row