I have a database that has many tables and for the most part each table has primary keys that are autogenerated. I have to update a table with many new records. I am able to open up my management console and manuallly add entries to it. but the problem is that i have close to 200 records to input.
I decided to go the SSIS route. unfortuntately when i go through the wizard i get an error message. which is attached.
I created a file that has the next auto number manually added. I have also done an import without filling out anything in the id field.
table has 5 columns
id int no nulls
costcat int nulls
costcode varchar5 nulls
definition varchar80 nulls
active varchar1 nulls
Im not much of an SQL admin but im trying to learn as i go along. Please let me know what other peice of info might be needed.