April 7, 2009 at 12:52 am
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
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy