I am faceing problem while export data using DTS in Visual basic after
installing service pack 2 on window XP. Before installation of service pack
2 on window XP DTS exporting successfulling in VB.

I am exporting 20 tables using DTS in VB. This problem come 11th table which
contain larger data then other tables.

Can anyone help me in this?

Regards,
AH

In article <OL4p2h9mEHA.1248 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Abdul Hafeez wrote:

Larger data?

Is that larger in count of rows or larger in attribute size?

Error messages?

I am running XP SP2 so if you can give me a structure with which to work I may
be able to reproduce.


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

Index out of bounds sounds as though something changed.

Have you tried redefining the DatPump again from scratch on the SP2 box?

If you want you can throw me the table def + file (zipped) and i can have a
look.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know