>>If you buy developer version for about $50 you would have the tools to develop SSIS packages. Not sure if the express server will run them but I believe they can still be run from a command line utility. Craig, Naomi - do you know if this would be a viable option?
>>
>
>Good point. I actually hav eth edeveloper version from 2005 lying around somewhere I think. Maybe I could use that just to test.
Just remember that there is a significant difference between SSIS in 2005 an 2008 - the former uses VBA the later uses the .NET engine so you can write C#. I really recomment getting the 2008 version. A big step up ( ( I have been forced to use 2005 in a project lately and really don't like it.)
For all things SSIS I have found Kevin Goff's stuff invaluable. Go to his blog and go the code-magazine.com to read all the great stuff in his Baker's Dozen column on SSIS
One other thing - don't install BIS 2005 until you are SURE you are not going with SSIS 2008 - they do not play well together on the same box
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.