Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ssis features or dts features Expand / Collapse
Author
Message
Posted Monday, September 14, 2009 3:44 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 10:54 PM
Points: 430, Visits: 1,068
i have a dts package in sql2005.
how to find out this package have ssis features or dts features.
Post #787790
Posted Monday, September 14, 2009 3:54 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:02 PM
Points: 6,032, Visits: 5,284
I am a little unclear as to what you are asking.

If you have a DTS package in SQL 2005 it is a DTS package. You would potentially see it in SSMS in Management|Legacy|Data Transformation Services.

Can you clarify?

CEWII
Post #787794
Posted Monday, September 14, 2009 4:02 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 10:54 PM
Points: 430, Visits: 1,068
correct........

i want to find out this package have dts features or ssis features.
Post #787797
Posted Monday, September 14, 2009 4:11 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:02 PM
Points: 6,032, Visits: 5,284
But you aren't being clear what you mean by features..

A DTS Package will have DTS features, end of story.

An SSIS package can have a DTS package embedded in it but that DTS package will still just be a DTS package.

Is there something more you are asking.

CEWII
Post #787802
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse