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-11-12 : 01:28:21
|
| Hi I need some information In server 2005 for numeric datatype when i try to insert null value through text file import/export I am getting numeric 0 as entered value in database tablemy scenario is remove all FK-PK relationship then i import text file in tables and again apply FK-PK but as i am getting 0 value entered in my table i m unable to reapply FK-PKwhat should i do to entered null value as it is in DB table..I set column property default to NULL allow...T.I.A |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-12 : 10:37:12
|
| save the ssis package from the import wizard, then open it using BIDS. click on the data flow tab, double click on the flat file source, check the box "Retain null values from the source as null values in the data flow" |
 |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2007-11-12 : 12:13:59
|
| Hi..Really thankful to you it worked for me :)Thanks again |
|
|
|
|
|
|
Numeric datatype getting numeric 0 instead of NULL