Post reply

Error Runing the Package SSIS.

  • January 11, 2011 at 11:25 am

    #230023

    I Written script that I implemented as a job. ran it test and it work fine.

    need to do it in a ssis package..

    put the Execute SQL task.. did the connection manager but when try the execute package get this error.

    [Execute SQL Task] Error: Executing the query "" failed with the following error: "Retrieving the COM class factory for component with CLSID {7816B7A3-CD60-4539-BD38-C35AFC61F200} failed due to the following error: 80040154.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    I ran the same script in a package home on sql server 2008 .. works like a charm. when i came to work and did that in ssis 05 getting this error ??

    what I am doing wrong.??

    Thanks in advance.

  • January 11, 2011 at 5:47 pm

    #1272146

    any one has any idea?

    Thanks

  • January 11, 2011 at 5:59 pm

    #1272147

    Post the script? My guess is you've got invalid 2k5 syntax (IE: MERGE). The other option is you need to turn on bypass prepare.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • January 12, 2011 at 12:28 am

    #1272207

    qur7 (1/11/2011)

    --

    I ran the same script in a package home on sql server 2008 .. works like a charm. when i came to work and did that in ssis 05 getting this error ??

    what I am doing wrong.??

    Thanks in advance.

    Are you using the same package? SSIS 2008 packages cannot be downgraded to SSIS 2005.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • January 12, 2011 at 7:30 am

    #1272360

    No I am not using the same package.. I created a new package and offcourse used the same script.

    this is the script by the way.

    DECLARE @dbName varchar(200);

    DECLARE @mirroringStatus int;

    DECLARE myCursor CURSOR LOCAL KEYSET FOR

    SELECT d.name, dm.mirroring_state FROM master.sys.database_mirroring dm INNER JOIN master.sys.databases d ON dm.database_id=d.database_id

    WHERE mirroring_guid IS NOT NULL;

    OPEN myCursor;

    FETCH NEXT FROM myCursor INTO @dbName, @mirroringStatus;

    WHILE @@FETCH_STATUS != -1

    BEGIN

    IF @@FETCH_STATUS = -2

    BEGIN

    PRINT 'The mirroring was removed for some of the databases while running this script' -- do nothing - the underlying record was modified in the meantime - probably somebody manually turned off DB mirroring for that DB

    END

    ELSE

    BEGIN

    IF (@mirroringStatus IN (2, 4, 5, 6)) -- running and: synchronizing(2) or synchronized(4) or not_synchronized(5) or synchronized_with_some_problem(6)

    BEGIN

    EXEC('ALTER DATABASE [' + @dbName + '] SET PARTNER SUSPEND');

    END

    -- states "3 = Pending Failover", "1 = Disconnected from the other partner" are not covered, because mirroring is not working for them right now

    END

    FETCH NEXT FROM myCursor INTO @dbName, @mirroringStatus;

    END

    CLOSE myCursor;

    DEALLOCATE myCursor;

    Hope some one has a answer here, banging my head for 2 days now ont this.

    Thanks in advance.

  • January 12, 2011 at 11:38 am

    #1272530

    Any help ?

  • January 12, 2011 at 11:43 am

    #1272533

    Any help ?

  • January 12, 2011 at 11:55 am

    #1272544

    I'm sorry to be a little punchy about this, but did you bother to google this before you posted the question?

    I mean I googled:

    "7816B7A3-CD60-4539-BD38-C35AFC61F200" 80040154

    And the first result was:

    http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/817c6cfc-b8b2-4a6e-af59-82b2c8ebfd9a/[/url]

    This result looks like it will fix your problem..

    CEWII

  • January 13, 2011 at 7:49 am

    #1273050

    The link in the solution provided in not working ....not the msn link.. the the link in the other forum that takes you to the solution page... they are taking about

    "registering SQLTaskConnections.dll using RegSvr32."

    With Rgards,

  • January 13, 2011 at 8:39 am

    #1273094

    will try to register it and hope it will work.. keep you guys updated .

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply