SSIS Script Tasks

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Aswani Karteek... » SSIS Script Tasks

SSIS Script Tasks

Rate Topic

Display Mode

Topic Options

Author

Message

Karteek

Posted Saturday, February 14, 2009 5:39 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 06, 2012 2:18 AM
Points: 117, Visits: 87

Comments posted to this topic are about the item SSIS Script Tasks

Post #657266

dalcock

Posted Monday, February 16, 2009 7:27 AM

Valued Member

Group: General Forum Members
Last Login: Monday, August 06, 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

benetsys

Posted Monday, February 16, 2009 9:08 AM

SSC 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

Ken Garrett

Posted Monday, February 16, 2009 9:23 AM

Old 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

Karteek

Posted Monday, February 16, 2009 9:40 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 06, 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

Anipaul

Posted Tuesday, February 17, 2009 9:26 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:35 AM
Points: 4,789, Visits: 1,336

Glad to see that Karteek accepts his mistakes. This is a very good quality. Keep the good work...

Post #658614

L' Eomot Inversé

Posted Tuesday, December 07, 2010 8:33 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:01 AM
Points: 7,112, Visits: 7,185

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
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.

Post #1031267

Karteek

Posted Wednesday, December 08, 2010 5:18 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 06, 2012 2:18 AM
Points: 117, Visits: 87

Thanks Anirban

Post #1031799

« Prev Topic | Next Topic »

Permissions