November 30, 2005 at 10:47 am
Hi all,
I used DTS to create a package to do auto daily import.
The package is very simple. Delete all data in the table then import data from a text file into the table. Everything look OK except the last column Reissue, the char 'Y' did not import for three rows(only three rows have flag 'Y', all others have null), those three rows still have data null.The column definition look like the following.
[Reissue] [char] (1) NULL
But when I manually delete the data in the table and import data(DTS-->all task-->import data) from the text file to the table, I see the char 'Y' in the last column for those three row.
What's going on, I am completely confused.
can someone help? Please.
Betty
December 1, 2005 at 1:00 pm
What does the target table look like?
What is your mapping from text to table?
Can we see a few sample rows of data?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply