Post reply

SSIS T-SQL task connection manager not available

  • April 7, 2009 at 12:52 am

    #208225

    In SQL 2005 SSIS. when i try to create t-SQL task, connection manager is not available , even i have create a connection manager, its not showing.

    And not able to create new connection also, as it doesn't give error also.

    can you guys guide me how i can work with this?

  • April 7, 2009 at 10:35 am

    #973600

    To access your existing connection manager, Click on the New button on on the Execute T-SQL Statement Task window to open the Connection Properties window, then type in the name of your existing connection manager. see attached screen shot.

    You can also enter or select a server name.

    Hope this helps.

Viewing 2 posts - 1 through 1 (of 1 total)

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