How to use DTS run time DTSexec in express/workgroup version of sql server 2005
In MSDE sql server 2000 dtsrun was available to execute the dts packages but now with sql server 2005 express edition integration service is not part of express/workgroup edition and the dtsexec run time is also not available.
Can anyone tell me what my options are other than using different edition of sql.
My current configuration is Windows XP pro with MSDE 2000 and want to upgrade to sql server 2005 express edition.
[428 byte] By [
VivSas] at [2008-2-12]
Things have changed with regards to features, and Integration Services does not ship with Express, so if you want to use it then you need a different edition of SQL. I don't understand what else you would expect. There is the Import/Export wizard, but clearly not the same from an automation perspective. If you have a full server instanace then move the processing to there.
I am ready to use a standard edition to create the packages that is not a problem but the problem I am having is I cannot use standard edition on the system where the packages have to be executed.
Is there any way I can execute the packages from c# or install integration service on that system with sql express. I am read to pay for integration service lisencing. Will microsoft support something like that.
