Sandra:
Using 0 for the int column worked, but it would not accept the 0000-00-00 value in the datetime column. However, I was able to put in a real date value, and then update both columns to null after the import. Thanks for the help.
Penny
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Sandra Ashby Sent: Wednesday, September 22, 2010 9:02 PM To: Tabor, Penny Subject: RE: [Tessitura Technical Forum] SQL Import
For a tab file leaving nothing between the tabs indicates it is NULL.
Another option might be to put a 0 in there for the int and after importing you do an update to set it to NULL? A similar thing for the date of 0000-00-00. At least this way you can see if it really is the NULLs causing the issue and not something else.
Hope that helps.
S.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Penny Tabor Sent: Thursday, 23 September 2010 9:22 AM To: Sandra Ashby Subject: RE: [Tessitura Technical Forum] SQL Import
I am trying to import data from a tab delimited text file into a local table in our test system. The table has an int column and a datetime column that allows nulls, however, I keep getting errors for those columns when I try the import. How do I specify null values in the int and datetime columns of the text file? I have tried NULL, ‘NULL’ and ‘’ and none of those worked.
-- View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/3370/11195.aspx#11195 or reply to this message -- This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
-- View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/3372/11197.aspx#11197 or reply to this message -- This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!