Hi

Looking at your error, I say it's either your variable is defined or your server connection string blank - possibly as a result of the variable not being mapped to the right index.

Couple of initial things to check,

1. have you defined the User::ServerConnString in the variables pane?

2. Have you defined the scoped the variable to Package level.

3. If your source table where your getting your server address from has more than 1 column, then make sure you map the variable User::ServerConnString to the correct column (i.e. table column 1 is index 0, table column 2 is index 1 etc etc.

Also, I'm not sure if you've looked at the pdf download, or just the main forumn article, but my pdf is probably a little clearer as I used screen shots etc. Here's the download http://www.sqlservercentral.com/Files/WMI%20QUERY%20Article.pdf/3897.pdf

Let me know how you get on.:hehe: