Background.....
I have Front End VB6, and Back End Access...
Access is mainly a Data Dump...a bunch of tables and data...NO queries, forms etc in Access...just Data and indexes
My Question is....
Is the DTS Import Feature supposed to convert Access(including Indexes, Primary Indexs) into SQL Server B/c as far as i can it is doesnt do that
If so where in SQL Server should I be looking b/c i must be blind.
Second, i am getting this error when importing tables via the DTS...i have gotten this s few times before and found it was bad data...but this record the data is good..and i cant seem to figure out what SQL is telling me.
ERROR MSG*******
Error at Destination for number 5568. Errors encountered so far in this task:1. Insert Error, column 3('Field3', DB_TYPE_DBTIMESTAMP), status 6: Data overflow. Invalid character value for cast specification.
Here is Record 5568 in my Access DB
Key 10232 (Long Integer)
ShipNumber 205789 (String)
Field3 11/17/04 (Date/Time)-Short Date
Ship_Time 13:17 (String)
Here is SQL Server Tbl Layout
Key (int)-4
ShipNumber (nvarchar)-22
Field3(smalldatetime)-4
Ship_Time (nvarchar)-5
What in the world is wrong b/c i am not seeing it....Please help thanks.
This is interesting....i get that Overflow error as stated above...and i completely delete the Row in Access and SQL DTS still errors on the same record...it is like SQL has lost its mind....what does everone else think
SQL DTS
Dan Heidel
Wade Heisen
It sounds like you may be trying to 'move' the data In which case you should read up on the Upsizing wizard that is in Access.
Gaston
if you click on the source or any transform in the data flow you will see a red arrow, this allows you to redirect rows. So you could first add text file destination and then connect the red arrow to it so your error rows dump to a file. You can also then right click the red line you connected with and add a dataviewer...so you could 'view' the data flowing down the error row path during execution.
You may want to read this topic in books online, its one of the tutorials.
Adding Error Flow Redirection
lemec
5568 is not the row number of the erroring row.
You can edit the package and divert all erroring rows for examination later. I recommend you try doing that.
-Jamie
NJB123
Animesh Misra