Hi

I am using sql server version 8.0 and vb6. From sql serveri have exported
access db to SQL Server and i saved the file as Visual basic module file
(DTS). then from my program (vb6) i am try to export the data from access db
to SQL server its working fine.

but my client using sql server version 7.0. here the same module not working
in 7.0.

any idea to solve this problem?

thanks
bala

You do not mention versions of each version of DTS/SQL Server or any error
messages. Have a look here


Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223)



--

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


"Bala" <Bala (AT) discussions (DOT) microsoft.com> wrote

Hi

i didnt get any error message. i am generating vb dts module on SQL
Server8.0 and try to exuecte the vb module on SQL Server7.0.

but i have seen sql server 7.0 there is no option for saving the dts package
as vb module.

any idea how to solve this problem.

thanks
bala

"Allan Mitchell" wrote: