|
Replies:
5
-
Pages:
1
-
Last Post:
Apr 13, 2012 1:19 PM
by: mike1234_82
|
|
|
Posts:
26
Registered:
4/28/10
|
|
|
|
question
Posted:
Apr 13, 2012 6:34 AM
|
|
|
I'm not sure it's a bug, but I'm trying to import a 2 column txt
file to a 3 column table.
The 1st column is identity column.
the import fails (Null value cannot be inserted to not null column....)
But it should be ok as that column is identity column....
I can overcome it easily using excel, but I think it should work using the
import wizard as well...
Dani
|
|
|
Posts:
794
Registered:
6/16/10
|
|
|
|
RE: question
Posted:
Apr 13, 2012 7:12 AM
in response to: kaplan.dani
|
|
|
|
|
Did you use ‘Identity inserts’ option during import?
I just tried to import txt file to such kind of table and all was fne.
regards,
Alexander Maximov
|
Alexander Maximov, DELL
|
|
Posts:
26
Registered:
4/28/10
|
|
|
|
RE: question
Posted:
Apr 13, 2012 7:15 AM
in response to: Alexander.Maximov
|
|
|
|
|
Tried both ON and OFF, it failed on both until I have provided my own valued and
set it to ON
On Apr 13, 2012 5:12 PM, "Alexander Maximov" < alexander.maximov@quest.com >
wrote:
Did you use ?Identity inserts? option during import?
I just tried to import txt file to such kind of table and all was fne.
regards,
Alexander Maximov
|
|
|
Posts:
26
Registered:
4/28/10
|
|
|
|
RE: question
Posted:
Apr 13, 2012 7:16 AM
in response to: Alexander.Maximov
|
|
|
|
|
But i didnt set it. My bad saw the arrow now.
On Apr 13, 2012 5:12 PM, "Alexander Maximov" < alexander.maximov@quest.com >
wrote:
Did you use ?Identity inserts? option during import?
I just tried to import txt file to such kind of table and all was fne.
regards,
Alexander Maximov
|
|
|
Posts:
26
Registered:
4/28/10
|
|
|
|
Re: question
Posted:
Apr 13, 2012 7:21 AM
in response to: kaplan.dani
|
|
|
|
|
Well, My Wizard doesn't look like yours !
I have on the Target table column a column name and not type, and I can't
set it to identity as you did....
Dani
2012/4/13 Kaplan Dani < kaplan.dani@gmail.com >
But i didnt set it. My bad saw the arrow now.
On Apr 13, 2012 5:12 PM, "Alexander Maximov" < alexander.maximov@quest.com >
wrote:
Did you use ?Identity inserts? option during import?
I just tried to import txt file to such kind of table and all was fne.
regards,
Alexander Maximov
|
|
|
|
|
|
|
Re: question
Posted:
Apr 13, 2012 1:19 PM
in response to: kaplan.dani
|
|
|
Hi Dani,
I can confirm the original issue with attempting to insert null even with insert
option checked or unchecked. I've created CR #98813 to track, and we should have
this fixed by the next release.
Once this issue is fixed, if you choose not to perform identity inserts, you'll
need to make sure to skip those identity columns from your source.
Also, you have the same wizard as Alex. The column names just happen to be named
after the data types. 
--Mike Wilson
Software Developer
Quest Software
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
