Ignore DTS tbale mport errors
-
Hiya.
Im trying to import data tables from MS Access. they contain about 20,000
rows of data.
When I attempt to use the DTS wizard for the import I receive a message
stating an error occurred and the copy was incomplete. Now, I cant keep
going through the tables and correcting the data type errors such as
incorrect date entries and such, but their are just too many rows to make the updates to.
The errors are not harmful to to the table, as they are simple data format errors, such as dates.
Is their a way that I can import the tables and suppress/ignore the import errors
from DTS, and still import the table???
Please help.
-
Are you using transform data task to do the transfer data ? If you do, then when you click on the tab 'Transformation' - if it already has a link, you can delete the link, and click new, then you can write your own active x script, datetime transfer, copy column.
There is also another way, if you read the data from Access, instead of using the table name as source, can you write the select statement ? Then you can change the format of the data before it transfers to the SQL Server table.
Just some suggestions.
-
Im still a learner.
What is "transform data task" is this a different utility to the DTS?
-
What is "transform data task" It is the task within a DTS package that transforms data between the Source and Destination
If you are trying to create the package then use the wizard but do not run the package, save it instead
Open the saved package
You will see icons for Source and Destination plus and arrow joining the two, this is the data transfomation task
Double click on the arrow and you will see a screen called 'Transform Data Task Properties'
Click on 'Transformations'
You will see each column and lines joining them, these are the column 'Transformations'
Change the 'Transformation' for each 'Date' column that is giving you problems and change it to ActiveX to check data validity
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply