SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


can I export data from a package variable object to an SQL destination?


can I export data from a package variable object to an SQL destination?

Author
Message
dave-dj
dave-dj
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4428 Visits: 1149
Can anyone point me in the right direction.

I have a package that in short does a WMI Query for available disk space on a list of servers and then populates a package variable in a table format.

How can I export data from a package variable object to an SQL destination??

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Dave23
Dave23
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1583 Visits: 1806
I've never tried it on data that would comprise multiple columns in an output table at once, but for simple package variables, you can use a derived column transformation to insert them into the data flow.
dave-dj
dave-dj
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4428 Visits: 1149
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)
dave-dj
dave-dj
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4428 Visits: 1149
Almost got this working now:

I used a script component as a source to access the details in the data in the ADO record set.

However, one problem still remains.

Once I have read in each server in the For Each Loop Container Server Quer the WMI Query is executed.

I've set the properties for the WMI Data Reader Task as follow:

OutputType: Data Table
OverwriteDestination: Append to Destination
DestinationType: Variable
Destination: User:BigGriniskUsageResults

User:BigGriniskUsageResults is a package level varaible of type object.

.... the remaining issue is that once the WMI query runs, it then executes the script component and Dataflow.

I have to do a for each loop container after each WMI Query in order to get the details out to the OLE destination.

Why does the WMI Data reader 'replace' the ADO table despite me setting the OverwriteDestination to Append to Destination?

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search