DTS Execute SQL Task failing in SQLServer 2005

Hello All,
We migrtated to SQLServer 2005 yesterday. On the same server, I uninstalled
SQLServer 2000 Enterprise Edition 32-bit Sp4 and installed SQLServer 2005
Enterprise Edition 32-bit SP2.
The new version is working fine and the performance is also comparable. For
the DTS packages, I download and installed the DTS Runtime components. All
the DTS packages work except for one. The package, calls a SP residing in the
user database in "Execute SQL" Task and then copies the data into a flat file
via DataPump Task on a remote share. The remote share is available all the
time.
Last night the Execute SQL task had failed and this morning I troubleshooted
it and found out that this is happening randomly and whenever it fails I see
this in log that it writes to. I tested it once after the migration and I ran
it once again now and in both the cases it worked fine.
This process never used to fail in SQLServer 2000. So, I was wondering if
this has anything to do with SQLServer 2005.
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:[DBNETLIB][ConnectionRead (recv()).]General network
error. Check your network documentation.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0
Thanks,
rgnHi
Error number 80004005 is a generic error and has quite a wide range of
causes for instance:
http://tutorials.aspfaq.com/8000xxxxx-errors/80004005-errors.html
http://tinyurl.com/2s9qqm
In the long term you should be considering moving over to SSIS.
John
"rgn" wrote:
> Hello All,
> We migrtated to SQLServer 2005 yesterday. On the same server, I uninstalled
> SQLServer 2000 Enterprise Edition 32-bit Sp4 and installed SQLServer 2005
> Enterprise Edition 32-bit SP2.
> The new version is working fine and the performance is also comparable. For
> the DTS packages, I download and installed the DTS Runtime components. All
> the DTS packages work except for one. The package, calls a SP residing in the
> user database in "Execute SQL" Task and then copies the data into a flat file
> via DataPump Task on a remote share. The remote share is available all the
> time.
> Last night the Execute SQL task had failed and this morning I troubleshooted
> it and found out that this is happening randomly and whenever it fails I see
> this in log that it writes to. I tested it once after the migration and I ran
> it once again now and in both the cases it worked fine.
> This process never used to fail in SQLServer 2000. So, I was wondering if
> this has anything to do with SQLServer 2005.
>
> Step Error Source: Microsoft OLE DB Provider for SQL Server
> Step Error Description:[DBNETLIB][ConnectionRead (recv()).]General network
> error. Check your network documentation.
> Step Error code: 80004005
> Step Error Help File:
> Step Error Help Context ID:0
> Thanks,
> rgn

DTS Executable error

We just installed SP3. The problem is that when I'm executing a DTS package
remotely from my client machine, it bombs when on the task that call an exe
cutable (error #128).
I don't get this error when I execute the DTS on the Server.
ThanksDavid,
If you can't install SQL client tools on the client machine, you're going to
have fun now.
Visit: http://www.sqldts.com/default.aspx?6,105,225,0,1
James Hokes
"David" <anonymous@.discussions.microsoft.com> wrote in message
news:6529CE21-68FF-4394-B2F3-0C3AF9F93959@.microsoft.com...

quote:

---

> We just installed SP3. The problem is that when I'm executing a DTS

---

package remotely from my client machine, it bombs when on the task that call
an executable (error #128).

quote:

---

> I don't get this error when I execute the DTS on the Server.
> Thanks

---

sql

DTS Executable error

We just installed SP3. The problem is that when I'm executing a DTS package remotely from my client machine, it bombs when on the task that call an executable (error #128)
I don't get this error when I execute the DTS on the Server
ThanksDavid,
If you can't install SQL client tools on the client machine, you're going to
have fun now.
Visit: http://www.sqldts.com/default.aspx?6,105,225,0,1
James Hokes
"David" <anonymous@.discussions.microsoft.com> wrote in message
news:6529CE21-68FF-4394-B2F3-0C3AF9F93959@.microsoft.com...
> We just installed SP3. The problem is that when I'm executing a DTS
package remotely from my client machine, it bombs when on the task that call
an executable (error #128).
> I don't get this error when I execute the DTS on the Server.
> Thanks

DTS designer

64b SQL2005 EE and all clent tools installed on the same server. Logged as
local admin user Im trying to create a new connection in DTS Designer but
after succesful test of the connection it errors out with
The new connection manager couldnt be created. Additional info : Exeption
from HRESULT 0xC0010014
Do you know if the client tools are installed by default in x86 Program
files folder and is it possible uninstalling and reinstalling in Program
files will fix the issue?
Any idea whats the problem and how to fix it ?
In our case the problem was SP1 unfinished /unsuccesful instalation. After
sql2005 setup REBOOT and when is up stop all sql services from Control panel
and then install SP1. Ensure you dont get open files errors if so close the
guilty apps and then continue and if so reapply the SP1 once again.
"Ellie" wrote:

> 64b SQL2005 EE and all clent tools installed on the same server. Logged as
> local admin user Im trying to create a new connection in DTS Designer but
> after succesful test of the connection it errors out with
> The new connection manager couldnt be created. Additional info : Exeption
> from HRESULT 0xC0010014
> Do you know if the client tools are installed by default in x86 Program
> files folder and is it possible uninstalling and reinstalling in Program
> files will fix the issue?
> Any idea whats the problem and how to fix it ?
>

DTS Design Error - Access is denied

I am pretty new to MS SQL Server ...

I have installed SQL Server Enterprise Manager Version 8.0. I am getting the following error while try to create a new DTS Package.

"DTS designer Error ... Access Denied"

getting the DTS packge design window but there is no TASK icon visible
either in the tool bar or menu....

Enterprise Manager Version 8.0

OS : Windows XP pro with SP1If you go to the msdb database, the user you are using needs to have EXEC permissions on the procs that have dts in the name. This is by default granted to public, so I'm not sure why your user wouldn't have that. ?|||See whether this KBA http://support.microsoft.com/default.aspx?scid=kb;EN-US;814113 is any help to you.

DTS and Sql Server 2005 Express

OK, I'm still trying to get DTS on SqlExpress. I installed Service Pack 1 and there was nothing extra in the "90" folder. Is there a way to get Excel spreadsheets into the express version? If so, spell it out for me and I'll use it.

Thanks in advance

I finally got it. The magic bits are in the SQLEXPRESS_TOOLKIT package.

DTS and Excel

Do you need to have excel installed to export files to excel using dts?

I don't think it does but I don't ever remember working on a computer without excel installed... can someone confirm? thank you very much in advance for your help.

No, DTS will create an xls formated file (csv) that can then be opened and used by Excel.

But Excel does NOT have to be on the server.

DTS 2000 package designer and SQL Server 2005

I am not sure where to ask this question. So I figured here may be ok

I have several DTS 2000 packages and I have SQL 2005 installed on my local machine. However the rest of the company is still using SQL 2000 (for now). So I do not want to convert them to ssis yet. One of the things we just did to the packages is make all flat files use \\localhost and any servers point to (local). Now in ssis this works fine but using the DTS 2000 package designer it does not like either of these at all. The reason we wanted to do this is so when we switch out servers there is no changes to our DTS packages.

I have found some problems using \\localhost as a UNC path in SSIS packages (for whatever reason it occassionally returned a duplicate name exception). Instead, try using \\127.0.0.1\ssis , which is essentially a loopback share onto the package execution host machines. Naturally, you would need to create the share on each machine. I haven't used or looked at DTS in eons so I couldn't tell you whether that works with DTS let alone migration issues.|||

yes the 127.0.0.1 worked for paths, however the (local) for servername does not. I Think it is a bug because the DBA that has SQL Enterprise manager can put (local) for servers and localhost for paths. But when I use SQL Server management studio (2005) and the DTS 2000 package designer neither works (except like I said 127.0.0.1).

Now if I build a new ssis then I can use (local) but you are right I think you still have to use 127.0.0.1 for paths.

Thanks for your reply.

DTS 2000 not running in SQL Server 2005

I'm having a problem running a legacy DTS in SQL 2005. I've installed the
Feb 2007 feature pack and my DTS jobs still are not working. I open package
and click start, the package runs for a few moments and then abruptly closes
Management Studio. I've tried running this from SQL Agent and it still
failes.
The package was created with the BI accelerator.
Thanks,
--
RonHi Ron
Have you run SQL profiler against it to see what is happening? If this uses
a third party component has his been installed correcly?
John
"Ron" wrote:
> I'm having a problem running a legacy DTS in SQL 2005. I've installed the
> Feb 2007 feature pack and my DTS jobs still are not working. I open package
> and click start, the package runs for a few moments and then abruptly closes
> Management Studio. I've tried running this from SQL Agent and it still
> failes.
> The package was created with the BI accelerator.
> Thanks,
> --
> Ron|||John,
Thanks for the reply. Actually the BI Accelerator is/was a Microsoft
Application (Microsoft Accelerator for BI), but I believe it's been retired.
I think the issue was with the compatibility level of my DB's. I had them
set to 80 instead of 90. I'm going to do a bit more testing, but I hope that
was the problem.
If you can think of anything else I should check please let me know.
Thanks,
--
Ron
"John Bell" wrote:
> Hi Ron
> Have you run SQL profiler against it to see what is happening? If this uses
> a third party component has his been installed correcly?
> John
> "Ron" wrote:
> > I'm having a problem running a legacy DTS in SQL 2005. I've installed the
> > Feb 2007 feature pack and my DTS jobs still are not working. I open package
> > and click start, the package runs for a few moments and then abruptly closes
> > Management Studio. I've tried running this from SQL Agent and it still
> > failes.
> >
> > The package was created with the BI accelerator.
> >
> > Thanks,
> > --
> > Ron

DTS -> SSIS -> ??

Anyone know where SSIS is? I installed the SQL Server 2005 evaluation
and found several app folders, and SSBID, but no SSID.
It took a bit of research to find and install DTS and I finally
imported a flat file of 500+ fields to begin normalizing, but I don't
see an application called SSIS to automate the process.SSIS is a service, which you have to select when you install (can be added later by running SETUP
again). You create SSIS packages using "SQL Server Business Intelligence Development Studio).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<thomasjbs@.gmail.com> wrote in message news:1191101123.446974.123480@.22g2000hsm.googlegroups.com...
> Anyone know where SSIS is? I installed the SQL Server 2005 evaluation
> and found several app folders, and SSBID, but no SSID.
> It took a bit of research to find and install DTS and I finally
> imported a flat file of 500+ fields to begin normalizing, but I don't
> see an application called SSIS to automate the process.
>

DTS - ActiveXScripting Not Working on 64bit AMD Cluster on SQL Server 2005 SP2

I have a problem with DTS - ActiveXScripting that it cannot initialize the script engine, I have the backward compatibility stuff installed, even tried a repair but still does not work.

Many thanks for any help you can provide on this problem.

Paul

Error Information below:

Date 17/04/2007 13:07:32
Log Job History (Test ActiveX Script)

Step ID 1
Server GBCONV1A002V03
Job Name Test ActiveX Script
Step Name Step 1: Exec TestActiveX script
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: WW004\ConSrvSQLAgentA002. ...TSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220487 (800403F9) Error string: ActiveX Scripting was not able to initialize the script execution engine. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 Error Detail Records: Error: -2147220487 (800403F9); Provider Error: 0 (0) Error string: ActiveX Scripting was not able to initialize the script execution engine. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 Error: -2147220440 (80040428); Provider Error: 0 (0) Error string: Package failed because Step 'DTSStep_DTSActiveScriptTask_1' failed. Error source: Microsoft Data Transformation Services (DTS) Package Help file: ... Process Exit Code 1. The step failed.

Try asking in the DTS usenet group.

http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg

DTS

I just downloaded and installed DTS for SQL 2005. Now the million
dollar question
How it I run it is there a button, link, click, dropdown, or setup of
external tools I need to do?
Hi
Check out the information in books online or at
http://msdn2.microsoft.com/en-us/library/ms143706.aspx, hopefully that will
point you in the right direction!
John
"frogman7" wrote:

> I just downloaded and installed DTS for SQL 2005. Now the million
> dollar question
> How it I run it is there a button, link, click, dropdown, or setup of
> external tools I need to do?
>
|||Hi
Check out the information in Books online or at
http://msdn2.microsoft.com/en-us/library/ms143706.aspx hopefully that will
point you in the right direction!
John
"frogman7" wrote:

> I just downloaded and installed DTS for SQL 2005. Now the million
> dollar question
> How it I run it is there a button, link, click, dropdown, or setup of
> external tools I need to do?
>
|||The mySQL DBA told me about DTS and that in SQL 2000 it was a button
click then the dialog box displayed asking for source and destination
of data to move. I added an external tool to this location:
C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\VSShell\Common7\IDE\DTExecUI. exe
Is this the right exe file to use?
|||Hi
DTSRun.exe is the program to use to run SQL 2000 packages DTExecUI.exe
is for SSIS packages.
John
"frogman7" wrote:

> The mySQL DBA told me about DTS and that in SQL 2000 it was a button
> click then the dialog box displayed asking for source and destination
> of data to move. I added an external tool to this location:
> C:\Program Files\Microsoft SQL
> Server\90\Tools\Binn\VSShell\Common7\IDE\DTExecUI. exe
> Is this the right exe file to use?
>
|||I have done something wrong because the only DTSRun.exe just runs
command prompt window and goes away.
This is the path to the file:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn
I am using SQL 2005 and downloaded the 2005 version from MS web site.
Is there a better place to get the file from.
|||Hi
DTSrun is used to run the packages, try DTSRUN /? from a command prompt to
get the command line options. If you have installed SQL Server2005_DTS.msi
then you should have a package called "SQL Server 2000 DTS Designer
Components" in Control Panel's Add/Remove Programs. You will the be able to
access and open packages through the legacy branch in the Object Explorer in
SQL Server Management Studio.
HTH
John
"frogman7" wrote:

> I have done something wrong because the only DTSRun.exe just runs
> command prompt window and goes away.
> This is the path to the file:
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn
> I am using SQL 2005 and downloaded the 2005 version from MS web site.
> Is there a better place to get the file from.
>

DTS

I just downloaded and installed DTS for SQL 2005. Now the million
dollar question
How it I run it is there a button, link, click, dropdown, or setup of
external tools I need to do'Hi
Check out the information in books online or at
http://msdn2.microsoft.com/en-us/library/ms143706.aspx, hopefully that will
point you in the right direction!
John
"frogman7" wrote:
> I just downloaded and installed DTS for SQL 2005. Now the million
> dollar question
> How it I run it is there a button, link, click, dropdown, or setup of
> external tools I need to do'
>|||Hi
Check out the information in Books online or at
http://msdn2.microsoft.com/en-us/library/ms143706.aspx hopefully that will
point you in the right direction!
John
"frogman7" wrote:
> I just downloaded and installed DTS for SQL 2005. Now the million
> dollar question
> How it I run it is there a button, link, click, dropdown, or setup of
> external tools I need to do'
>|||The mySQL DBA told me about DTS and that in SQL 2000 it was a button
click then the dialog box displayed asking for source and destination
of data to move. I added an external tool to this location:
C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\VSShell\Common7\IDE\DTExecUI.exe
Is this the right exe file to use?|||Hi
DTSRun.exe is the program to use to run SQL 2000 packages DTExecUI.exe
is for SSIS packages.
John
"frogman7" wrote:
> The mySQL DBA told me about DTS and that in SQL 2000 it was a button
> click then the dialog box displayed asking for source and destination
> of data to move. I added an external tool to this location:
> C:\Program Files\Microsoft SQL
> Server\90\Tools\Binn\VSShell\Common7\IDE\DTExecUI.exe
> Is this the right exe file to use?
>|||I have done something wrong because the only DTSRun.exe just runs
command prompt window and goes away.
This is the path to the file:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn
I am using SQL 2005 and downloaded the 2005 version from MS web site.
Is there a better place to get the file from.|||Hi
DTSrun is used to run the packages, try DTSRUN /? from a command prompt to
get the command line options. If you have installed SQL Server2005_DTS.msi
then you should have a package called "SQL Server 2000 DTS Designer
Components" in Control Panel's Add/Remove Programs. You will the be able to
access and open packages through the legacy branch in the Object Explorer in
SQL Server Management Studio.
HTH
John
"frogman7" wrote:
> I have done something wrong because the only DTSRun.exe just runs
> command prompt window and goes away.
> This is the path to the file:
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn
> I am using SQL 2005 and downloaded the 2005 version from MS web site.
> Is there a better place to get the file from.
>

DTS

I just downloaded and installed DTS for SQL 2005. Now the million
dollar question
How it I run it is there a button, link, click, dropdown, or setup of
external tools I need to do'Hi
Check out the information in books online or at
http://msdn2.microsoft.com/en-us/library/ms143706.aspx, hopefully that will
point you in the right direction!
John
"frogman7" wrote:

> I just downloaded and installed DTS for SQL 2005. Now the million
> dollar question
> How it I run it is there a button, link, click, dropdown, or setup of
> external tools I need to do'
>|||Hi
Check out the information in Books online or at
http://msdn2.microsoft.com/en-us/library/ms143706.aspx hopefully that will
point you in the right direction!
John
"frogman7" wrote:

> I just downloaded and installed DTS for SQL 2005. Now the million
> dollar question
> How it I run it is there a button, link, click, dropdown, or setup of
> external tools I need to do'
>|||The mysql DBA told me about DTS and that in SQL 2000 it was a button
click then the dialog box displayed asking for source and destination
of data to move. I added an external tool to this location:
C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\VSShell\Common7\IDE
\DTExecUI.exe
Is this the right exe file to use?|||Hi
DTSRun.exe is the program to use to run SQL 2000 packages DTExecUI.exe
is for SSIS packages.
John
"frogman7" wrote:

> The mysql DBA told me about DTS and that in SQL 2000 it was a button
> click then the dialog box displayed asking for source and destination
> of data to move. I added an external tool to this location:
> C:\Program Files\Microsoft SQL
> Server\90\Tools\Binn\VSShell\Common7\IDE
\DTExecUI.exe
> Is this the right exe file to use?
>|||I have done something wrong because the only DTSRun.exe just runs
command prompt window and goes away.
This is the path to the file:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn
I am using SQL 2005 and downloaded the 2005 version from MS web site.
Is there a better place to get the file from.|||Hi
DTSrun is used to run the packages, try DTSRUN /? from a command prompt to
get the command line options. If you have installed SQL Server2005_DTS.msi
then you should have a package called "SQL Server 2000 DTS Designer
Components" in Control Panel's Add/Remove Programs. You will the be able to
access and open packages through the legacy branch in the Object Explorer in
SQL Server Management Studio.
HTH
John
"frogman7" wrote:

> I have done something wrong because the only DTSRun.exe just runs
> command prompt window and goes away.
> This is the path to the file:
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn
> I am using SQL 2005 and downloaded the 2005 version from MS web site.
> Is there a better place to get the file from.
>