Hi

I am using SQL Server 2000. In SQl Server 2000 and it saves the package to a
VB module file. i try to execute the VB module on using sql server 7.0. it
wont execute and its not return any error also.

The idea is from my vb program the user can able to export all the values
(access to sqlserver) and same way he can able to export all the details (sql
server to access). here i dont know the access path. so from vb program the
user should select the access db.

Is any other idea to solve this problem.

thanks
bala

Hmmm. It sounds as though you have a versioning problem with dts (2000 - 7)

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


You can set the name of the Access connection easily through code but
remember to get the user to specify it before you invoke DTS. This will
negate the "Lunchtime lock" possibilities

--
--

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