Post reply

Add SSIS Package to SQL Server Agent Job

  • October 19, 2010 at 5:27 pm

    #239987

    Hi There,

    I'm having issues with scheduling a SSIS package under SQL Server Agent/Jobs. We have an ERP system running on informix data. I would like to syn some tables from informix to sql2008 daily. I successfully created the SSIS package under management/import wizard. I added this package under Jobs. When i right click on the job and start it the following error comes up.

    19/10/2010 8:32:41 AM

    LogJob History (melb_salesman_copy)

    Step ID1

    ServerMENORA-SQL

    Job Namemelb_salesman_copy

    Step Namemelb_salesman_copy

    Duration00:00:01

    Sql Severity0

    Sql Message ID0

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted0

    Message

    Executed as user: MENORA_FOODS\administrator. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 8:32:41 AM Error: 2010-10-19 08:32:42.03 Code: 0xC0047062 Source: Data Flow Task 1 Source - Query [1] Description: Microsoft.SqlServer.Dts.Runtime.DtsCouldNotCreateManagedConnectionException: Could not create a managed connection manager. at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, Object transaction) at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction) at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction) End Error Error: 2010-10-19 08:32:42.03 Code: 0xC0047017 Source: Data Flow Task 1 SSIS.Pipeline Description: component "Source - Query" (1) failed validation and returned error code 0x80131500. End Error Error: 2010-10-19 08:32:42.03 Code: 0xC004700C Source: Data Flow Task 1 SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2010-10-19 08:32:42.03 Code: 0xC0024107 Source: Data Flow Task 1 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:32:41 AM Finished: 8:32:42 AM Elapsed: 0.609 seconds. The package execution failed. The step failed.

    Has someone come across this issue.

    Please note we have sql2000 server when it ran successfully for the last 4 years.

    Thanks,

    Vikash

  • October 20, 2010 at 10:23 am

    #1239802

    is your Informix driver certified for Windows x64?

  • October 20, 2010 at 4:32 pm

    #1239995

    Yes it is certified for windows x64

  • October 20, 2010 at 4:40 pm

    #1239997

    Yes the informix driver is certified for windows x 64. I tried to syn a table from MSSQL 2000 DB to MSSQL2008 and got the same error message. I suspect it is some thing specific to SQL2008 setup.

  • October 21, 2010 at 4:03 pm

    #1240645

    Vikash

    presumably when you designed the package you ran with a connection configured to a test database. Now you have deployed the package did you change the connection to connect to the correct database?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 5 posts - 1 through 4 (of 4 total)

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