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 |
|
nhamdan
Starting Member
19 Posts |
 Posted - 2005-06-09 : 05:29:33
|
| I have created a DTS package that just copy rows from one SQL Server table to another. i executed it on the same server it succeed. But when i executed it from an a VB 6.0 application that is connected to the same server it gives error as follow:Package Failed Because Step 'DTSStep_DTSDataPumpTask_1' Failed |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-11 : 02:03:51
|
| Well that error doesn't give us enough information to troubleshoot. However, I can offer an alternative solution. To copy data from one table to another, just use T-SQL instead of DTS:INSERT INTO DestinationTable (Column1, Column2)SELECT Column1, Column2FROM SourceTableIf you are going across servers, you can use linked servers along with the four part naming convention. Let us know if this is the case and if you need help on this.Tara |
 |
|
|
nhamdan
Starting Member
19 Posts |
Posted - 2005-06-11 : 02:09:28
|
| Thanx for the help, but the problem is more complicated. The DTS package that i have created is copying records from Oracle database on linked server to my sql server table. but it failed from any client PC and works only on the server. And i created a simple DTS that copies from table to table in sql server and the DTS still not running so when i solve this i will solve the DTS for oracle. So your solution wont work in my situation. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-11 : 02:11:47
|
| Please post how you are calling the DTS package from your VB 6.0 application.Tara |
|
|
|
nhamdan
Starting Member
19 Posts |
Posted - 2005-06-11 : 02:20:21
|
| Dim obj As DTS.Package Set obj = New DTS.Package ' Key1,key4,key5 represent the login parametrs to ssql server DB ' FromOrclToSql the DTS package name obj.LoadFromSQLServer key1, key4, key5, , , , , "FromOrclToSql" obj.FailOnError = True obj.Execute obj.UnInitialize Set obj = Nothing |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-11 : 02:25:27
|
| I was hoping you were using dtsrun.exe via your VB application as I'd be able to help with that. Unfortuneately, I have never called a DTS package the way that you have. However, on the below site, you should find code examples of how it is done:http://www.mindsdoor.netIf that doesn't help you, check out this site as well:http://www.sqldts.comTara |
|
|
|
|
|
|
|
|
DTS Running from remote PC failed ?