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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-24 : 08:26:30
|
| Robert writes "I hope you can assist with this DTS problem. I created a DTS package using the "Import and Export Data" feature in SQL 2000. The package was output as a visual basic file. I then added the script created by this process into my Visual Basic program. I have this program deployed to eight clients. All clients ran a setup package that included DtsPkg.dll, DtsPump.dll. Two of our clients are getting an "Automation Error" "The specified procedure could not be found" "-2147024769". The two clients having problems are running MDAC version 2.7 sp1 on Windows 2K operating systems. I have isolated the problem line to be the line "Set goPackage = goPackageOld" following the line "gstrErrorControl = "UET-0006" ' added 02/15/04 RJM" in the code below, not all code is shown. (I added the gstrErrorControl = ...... to locate the program line causing the problem. '****************************************************************'Microsoft SQL Server 2000'Visual Basic file generated for DTS Package'File Name: C:\DTSUpdate2EDIV2.bas'Package Name: DTSUpdate2EDIV2'Package Description: DTS package description'Generated Date: 2/5/2004'Generated Time: 4:05:23 PM'****************************************************************Option ExplicitPublic goPackageOld As New DTS.PackagePublic goPackage As DTS.Package2Sub UpdateEDITablesMain() gstrErrorControl = "UET-0006" ' added 02/15/04 RJM Set goPackage = goPackageOld gstrErrorControl = "UET-0007" ' added 02/15/04 RJM" |
|
|
|
|
|
DTS Package error