Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2010-02-05 : 12:59:06
|
| I have 50 rows in the source as400 file, when it gets loaded using DTS package into the sql table, about 1550 rows are getting loaded into the sql table.I am not sure what's causing that to happen. Here is what I am doing: we have set up linked server between sql server 2000 and AS400 and the driver is from IBM. I wrote a DTS package to load the data from AS/400 to sql table. I am using a simple query to get the source data: Source sql query:select * from linkedserver.library.object where column='Y'I am clueless, any ideas what's causing that.Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-05 : 13:03:22
|
| are you giving this inside loop or something? |
 |
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2010-02-05 : 13:25:46
|
| No, it's a simple transform data task inside DTS |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-05 : 13:34:05
|
| are 1550 rows duplicates with same values for all fields? |
|
|
|
wooldawg
Starting Member
12 Posts |
Posted - 2010-02-11 : 17:02:38
|
| Not sure if this is any help at all, but there is alot of this sort of thing (selecting data from AS/400 that is) going on at my place. In general DTS is not used, rather there are a bunch of store procs that scheduled in SQL Server Agent. Most them do something like truncate table mySQLtableInsert into mySQLtableSELECT * FROM AS400..BPCS.VENDORLIBTo my knowledge I have not experienced the problem you have described though. There are dozens of procedures running here with statements like the one above. |
|
|
|
|
|
|
Loading data from AS/400 to SQL server table