ssis features or dts features

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » ssis features or dts features

ssis features or dts features

Rate Topic

Display Mode

Topic Options

Author

Message

charipg

Posted Monday, September 14, 2009 3:44 PM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 AM
Points: 378, Visits: 897

i have a dts package in sql2005.
how to find out this package have ssis features or dts features.

Post #787790

Elliott Whitlow

Posted Monday, September 14, 2009 3:54 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

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

charipg

Posted Monday, September 14, 2009 4:02 PM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 AM
Points: 378, Visits: 897

correct........

i want to find out this package have dts features or ssis features.

Post #787797

Elliott Whitlow

Posted Monday, September 14, 2009 4:11 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

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 »

Permissions