"Are there any values in the first column that can't be converted to a 4 byte integer?"

Are you attempting to convert 456.54667from your sample data to an int?  Remember no...

As others have said for security it all depends upon your environment.  You may have a 3rd party applicaiton that may need SA rights or some other such specific circumstance.

As...

"SBS limits you to a max of 50 users "

That was on versions prior to SBS 2003.  The current limit is 75 although as stated above you would need a...

I'd imagine depending on your environment you may want to use WSUS or SMS2003.  Here is a link that shows the differences between the MS offerings for what you are...

Good article Steve.  I'm in the process of determining if consolidation and or virtualization would benefit my company right now.  Good to know I'm heading in the right direction...

I don't know anything about dharma interfaces, but I have had to pull data from an RMS datasource on a VMS box before.  The product I used was from Connx...

From the error you are receiving it sounds as if your connection strings are not correct. 

You mentioned you changed server names?  Do you mean you are using the same...

Again with no errors I can only guess but another problem I'd seen from time to time was when someone did a lot of changing of service user accounts and...

Glad to help

Since I'm not a developer although I know Coldfusion and I'm just beginning to learn VB6, vb.net I'm not sure which language you are using there. 

However, in T-SQL, Coldfusion...

From you code it looks liek you are accepting a money variable for @images.  So when you call your stored procedure you just need to pass it to the SP...

Any reason why somethign like the following wouldnt' work?

DECLARE @vcvalue varchar(8)

SELECT @vcvalue = '$1123.45'

SELECT CONVERT(money, @vcvalue, 0) AS MyvarcharASMoney

Not that I really think it will make a difference, but have you checked the 'Close Connection on Completion' Checkbox on the Workflow options|options tab? 

Also, what about throwing a...

Are you passing any parameters to the process?  If so you will need to put them on the parameters line.

Also make sure you are specifying the proper parameters in the...

From the transform data task properties, to top section where is states exceptionfile name.  type the path to a log file on your machine.  Then save and run your package...