DTS Packages

Hi,

I want to know what are DTS packages, how are they used, and the benefits.

Do DTS packages still exist in SQL 2005?

Thanks

SQL 2005 has replaced DTS with Integration Services. It is a totally new paradign and the previous DTS packages are not compatible.

You can get a lot of information for either at:

www.sqldts.com

www.sqlis.com

Also, Look in Books Online for more information, DTS in SQL 2000, SSIS in SQL 2005.

|||

DTS is the ETL tool available in SQL Server 7 and 2000

http://vyaskn.tripod.com/sql_server_dts_best_practices.htm

In SQL Server 2005 , DTS been replaced by SQL Server Integration Services (SSIS) which is a complete, feature rich,control rich ETL tool. there are many enhancement in SSIS. DTS is still suppored by SQL Server 2005 for backward compatibility , but it is not recommended for new development..

Madhu

|||Yes, they still exist. They've changed format, however. You can convert DTS packages from SQL Server 2000 into SQL Server Integration Services packages. Or, you can continue to run the old packages. SQL Server Integration Services is far richer than DTS was, so packages can't be converted from SSIS back to DTS.

You can read lots more about SSIS in the SQL Server Integration Services section of this site.

DTS package does not exist?

I ran the DTS package using the DTSRun as following:
SET @.action = 'DTSRun /S'+@.server+' /U "sa" /P "correctpassword" /N
"DataMover" '
exec master.dbo.xp_cmdshell @.action
It ran fine in one server. And failed in another server. The error message
is:
Error: -2147217900 (80040E14); Provider Error: 14262 (37B6)
Error string: The specified DTS Package ('Name = '"DataMover"
'; ID.VersionID = {[not specified]}.{[not specified]}') d
oes not exist.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
The verified the DTS package named as "DataMover" does exist on the problem
server. The DTS packages in two servers are exactly the same. I'm confused
why it worked on one and failed on the other one.
Thanks a lot,
FLXI changed the
/N "DataMover"
to
/NDataMover
It woked about the change. I still don't understand why it performs
differently on two servers. FLX
"FLX" <nospam@.hotmail.com> wrote in message
news:%23paHNQDDEHA.4080@.TK2MSFTNGP09.phx.gbl...
> I ran the DTS package using the DTSRun as following:
> SET @.action = 'DTSRun /S'+@.server+' /U "sa" /P "correctpassword" /N
> "DataMover" '
> exec master.dbo.xp_cmdshell @.action
>
> It ran fine in one server. And failed in another server. The error message
> is:
> Error: -2147217900 (80040E14); Provider Error: 14262 (37B6)
> Error string: The specified DTS Package ('Name = '"DataMover"
> '; ID.VersionID = {[not specified]}.{[not specified]}')
does not exist.
> Error source: Microsoft OLE DB Provider for SQL Server
> Help file:
> Help context: 0
>
> The verified the DTS package named as "DataMover" does exist on the
problem
> server. The DTS packages in two servers are exactly the same. I'm confused
> why it worked on one and failed on the other one.
> Thanks a lot,
> FLX
>
>|||Hello,
The behavior you described is mostly like a bug mentioned below:
308801 FIX: DTSRUN Fails with Errors If the Arguments Have Multiple Space
http://support.microsoft.com/?id=308801
To resolve this problem, obtain the latest service pack for Microsoft SQL
Server 2000. For additional information, click the following article number
to view the article in the Microsoft Knowledge Base:
INF: How to Obtain the Latest SQL Server 2000 Service Pack
http://support.microsoft.com/?id=290211
Please check the service pack on your 2 servers.
321185 HOW TO: Identify Your SQL Server Service Pack Version and Edition
http://support.microsoft.com/?id=321185
If the services packs on your 2 servers are different, we can explain why
it performs differently on two servers.
I am looking forward to hearing from you soon.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

DTS Help

Hey guys,
In my DTS package I have an ActiveX Script that basicaly checkes if records exist in a table something like this:
Const adOpenKeyset = 1
Const adLockOptimistic = 3

Function FindRec()

Dim objConn
Dim sql
Dim rs

Dim Success

Success = 0

sqlconn = "DSN=SAConn;UID=PSI_Admin;PWD=psiadmin001;DATABASE= SA"

Set objConn = CreateObject("ADODB.Connection")
objConn.Open sqlconn

sql = "SELECT NAM FROM tblUnassignedNAM "

Set rs = CreateObject("ADODB.RecordSet")
rs.Open sql, objConn, adOpenKeyset, adLockOptimistic

If rs.EOF = False Then

Success = 1

End If

rs.Close
Set rs = Nothing

objConn.Close
Set objConn = Nothing

If Success = 1 Then
FindRec = DTSStepExecResult_Success
ElseIf Success = 0 Then
FindRec = DTSStepExecResult_Failure
End If

End Function

If you notice at the end I say
If Success = 1 Then
FindRec = DTSStepExecResult_Success
ElseIf Success = 0 Then
FindRec = DTSStepExecResult_Failure
End If

So if there are no records it should fail and do something else, but the process does not fail it's successful. Why is that?You are simply returning the numeric value of the errors. You are not throwing an error.