I have DTS procedure return in SQL 2000 which transfer data from As/400 system to SQL database. When I run this procedure , data get stored in the table SQL 2000 different way (I dont have primary key, index on the SQL table) but still it sort in differnt manner.
When I move DTS procedure to SQL 2005 converted to SSIS and tried to run. Procedure makes a connection to As/400 and transfer the data in the table as it gets from AS/400. SQL 2005 doesnt sort the data like i had in SQL 2000.
Can someone please help
Here is DTS for SQL 2000
1) TRUNCATE TABLE PS_CRM
2) mAKE as/400 connection and transfer data in PS_CRM.
same procedure is defined on SQL 2005.
| Top Expert: |
acperkins |
| Expert Since: |
05/29/2001 |
| Accepted Solutions: |
6895 |
| Computer Expertise: |
Beginner |
acperkins has been an Expert for 7 years 7 months, during which he has posted 36778 comments
and answered 6895 questions. acperkins is just one of 2167 experts in the MySQL Server Zone.
20081119-EE-VQP-48 - Hierarchy / EE_QW_2_20070628
