seema.nare@oasis-bs.com
Active member
- Joined
- May 19, 2006
- Messages
- 27
- Programming Experience
- Beginner
I am using sql server 2005 management studio to export the data.
1. Firstly,When I export the data in the table, in the destination table I find the records are shuffled. The corresponding fields values are correct. But I dont see those sorted properly on PK as it was in source table
2. Secondly, my constraints added in source table gets removed in destination table. eg default values, primary keys etc.
I already have tried option of "Insert identity" true while exporting.
Another solution I tried was:
I tried using SSIS package from business intelligence studio but it gives me
foll error while doing so.
Error:
"[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..". "
I am using server server authentication.
Any other way?How can I get rid of this?
Thanks.
1. Firstly,When I export the data in the table, in the destination table I find the records are shuffled. The corresponding fields values are correct. But I dont see those sorted properly on PK as it was in source table
2. Secondly, my constraints added in source table gets removed in destination table. eg default values, primary keys etc.
I already have tried option of "Insert identity" true while exporting.
Another solution I tried was:
I tried using SSIS package from business intelligence studio but it gives me
foll error while doing so.
Error:
"[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..". "
I am using server server authentication.
Any other way?How can I get rid of this?
Thanks.
