October 8, 2008 at 8:36 pm
Currently, we are developing with SQL Server 2000 standard edition as our backend.
We create DTS packages and saving it as vbs script and creating exe's using visual basic.
Now we are trying to purchase SQL Server 2008. But I am being asked if workgroup edition will meet our needs. I know workgroup is cheaper, but I see that workgroup does not have:
1. business intelligence development studio. Is this where the data transformation package resides?
2. In intergration services it doesn't have "basic task and tranformations" Is this the dts package?
I read that business intelligence development studio is included in visual studio 2008 professional is this true?
Please advise and thank you in advance for clarifying my confused head.
October 9, 2008 at 5:27 am
In SQL 2005, DTS (Data Transformation Services) was replaced by SSIS (SQL Server Integration Services).
Development for SSIS packages is done using the Business Intelligence Studio - which is a project type in Visual Studio.
The workgroup edition includes a basic import/export ability. If you need to create SSIS packages with any data transformation you need to get the standard edition or better.
DTS and SSIS are very different. I would recommend you get a book and read up on the subject.
October 9, 2008 at 12:27 pm
Thanks Michael. I request to my supervisor to order the standard edition.
and Yes, I will read up some SSIS information. I wonder how it is going to affect our exe's we are creating using dts.
Thank you very much.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply