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 Script Tasks Expand / Collapse
Author
Message
Posted Saturday, February 14, 2009 5:39 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 6, 2012 2:18 AM
Points: 117, Visits: 87
Comments posted to this topic are about the item SSIS Script Tasks
Post #657266
Posted Monday, February 16, 2009 7:27 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 6, 2012 3:06 AM
Points: 63, Visits: 53
I think this question was misleading. All of the activeX script tasks in DTS will be converted to activeX script tasks in SSIS. They will likely have issues but they will be migrated, which is what the question asked.
Post #657696
Posted Monday, February 16, 2009 9:08 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, September 21, 2010 4:57 AM
Points: 80, Visits: 41
Agreed. A poorly written question, where even the explanation technically supports both answers.
Post #657837
Posted Monday, February 16, 2009 9:23 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, July 19, 2012 12:50 PM
Points: 385, Visits: 170
I felt the question was misleading as well. The ActiveX Task will migrate from SQL 2K DTS to SSIS, but the SSIS version may or may not execute properly depending upon how the task is utilized.
Post #657856
Posted Monday, February 16, 2009 9:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 6, 2012 2:18 AM
Points: 117, Visits: 87
Hi
Thanks for your valuable suggestion. Infact, now I felt, it a little misleading.
The intention of the question is what the probability of success in migrating a package and running without doing any modification is 0% for ActiveX Script Tasks.

However, when one expects to upgrade his package, he does not expect a code that does not work. We expect it to be ready, with the slightest of modifications.

(Wherever he is present, please read as he/she).

Post #657883
Posted Tuesday, February 17, 2009 9:26 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 3:19 AM
Points: 5,363, Visits: 1,391
Glad to see that Karteek accepts his mistakes. This is a very good quality. Keep the good work...


Post #658614
Posted Tuesday, December 7, 2010 8:33 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:30 PM
Points: 8,830, Visits: 9,388
I liked the question, and was rather surprised to see the comments saying that it's ambiguous.
I suppose that people have got so used to MS thinking they have done something useful when all they've actually done is create a shoddy mess that they have come to believe that "migrate a script" means "bodge up something that has no chance of working"; the question is only ambiguous if that is your meaning for "migrate" - of course it is MS's meaning, but MS sometimes get things wrong, don't they.


Tom
Post #1031267
Posted Wednesday, December 8, 2010 5:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 6, 2012 2:18 AM
Points: 117, Visits: 87
Thanks Anirban
Post #1031799
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse