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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-26 : 09:53:40
|
| Al writes "I'm experiencing a catch-22 with DTS. I'm trying to set up A DTS package to import a spreadsheet (one we get from a customer regularly) and append into a SQL Server Table. With some judicious use of transformations, the columns are matched correctly. However, the DTS execute fails, reporting that it cannot insert a <NULL> value into my Identity Field. I find this funny because you can't normally insert anything else into it either! Ok, so I suppose I could set identity_insert on and try to find a number, but that's a lot more trouble than I think should be necessary.. besides, I'm not convinced that I have that kind of control over the Query generated by the DTS package in the first place. Any help would be appreciated.- Al." |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-06-26 : 10:18:37
|
| could you post the create statement for the table your populating on here? It should auto increment, my only thought is you haven't declared the int column correctly.-----------------------Take my advice, I dare ya |
 |
|
|
|
|
|
DTS import of Excel Sheet fails because of Identity Field