Home Forums SQL Server 2005 SQL Server 2005 Integration Services can I export data from a package variable object to an SQL destination? RE: can I export data from a package variable object to an SQL destination?

  • December 4, 2008 at 8:04 am

    #907607

    hi thanks, i tried that, but SSIS is complaining that it doesn't have an Input to the derived columns.

    Also another issue now I can see whats coming out a script task compent to display the ADO recordset details, is that it's only showing the last record.

    On the WMI query i've set the destination to append, but it doesn;t seem to be doing that?

    (I know I could export to a CSV file, but I'd rather do all this processing in memory).

    Any ideas ?

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)