Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

CozyRoc Data Flow Source Expand / Collapse
Author
Message
Posted Friday, July 18, 2014 2:37 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 9:34 AM
Points: 42, Visits: 469
I'm having issues with CozyRoc's Data Flow Source. It seems pretty straightforward: I've created the Data Flow Destination in Data Flow Task A, and created a Package Connection with the "Connection to Current Package" option selected. In Data Flow Task B, I created a Data Flow Source and selected the Package Connection in the Connection Managers tab, but in the Component Properties tab I get the error: "Failed to retrieve active package." Even if I type in the name of the Data Flow Destination, it says, "Please specify valid package connection." Creating the Package Connection and Data Flow Destination is pretty easy, so I'm not sure what I'm missing. I am on SQL Server 2008 R2, and CozyRoc 1.6 SR-1. Any help would be appreciated.
Post #1594239
Posted Friday, July 18, 2014 2:58 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 9:34 AM
Points: 42, Visits: 469
Well, I closed and reopened the package and got it to work. I suppose it needed to refresh.
Post #1594243
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse