January 30, 2009 at 4:40 am
Hi,
Through SSIS packages I will import the tables to SQL Server 2005 from Access database.
Is there any way to check the correctness of data imported at SQL end?
(similar post - I posted in T-SQL zone
Title - Comparing tables in Access and SQL
-- regret)
Thanks
Thanks,
Santhosh
January 30, 2009 at 6:44 am
Without defining "correctness" there is little to tell you.
SSIS and MSSQL will verify that your data matches the data types in your desintation table and error if the data does not. Assuming that is what you mean by correct, it is automatic. If you mean does "joe" still end up "joe" when transferring a varchar(10) to a varchar(10) - the answer is that you do not have to worry about it - if you do not trnasform the data, it will be the same when it gets to the destination.
January 30, 2009 at 7:01 pm
Are you asking whether it is possible to write a query that accesses data from SQL Server and Access?
I agree that you need to expand on what you mean by "correct".
Phil
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 31, 2009 at 1:04 am
yes, this is the first thing you must always do when you migrate data from one source to another. you must always check your data consistency whether it is in correct format or not.
most of the time when you have very large table then some of the data of that table gets corrupted but table still work fine in lower version like sql 2000 or access. but when you access same data in sql server 2005 then it reports error.
So, my advice to you is that you should always run dbcc checktable command with all_error_msgs option on, once you finish importing your data to sql server 2005.
February 1, 2009 at 10:07 pm
Michael Earl (1/30/2009)
Without defining "correctness" there is little to tell you.SSIS and MSSQL will verify that your data matches the data types in your desintation table and error if the data does not. Assuming that is what you mean by correct, it is automatic. If you mean does "joe" still end up "joe" when transferring a varchar(10) to a varchar(10) - the answer is that you do not have to worry about it - if you do not trnasform the data, it will be the same when it gets to the destination.
Yes I meant the same...
If you mean does "joe" still end up "joe" when transferring a varchar(10) to a varchar(10) - the answer is that you do not have to worry about it
You mean to say, the tables imported from Access to SQL will be same as Access if no transformations are applied right?
Thanks
Thanks,
Santhosh
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply