Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jlassiter76
Starting Member
1 Post |
 Posted - 2012-08-20 : 11:36:26
|
| My company has been using SQL 2000 for many years, and we have built several custom DTS packages to process our daily jobs.Our new software requires that we now use SQL 2005, and it is only the Express Edition which has no SSIS features. Without SSIS or DTS, how can I setup some of the same packages in order to get our data processed properly? Should I use a VS solution? Microsoft Access? Can I possibly work with the SQL 2005 tables in SQL 2000 and use our same DTS packages?I'm very new to this...so thank you in advance.-Jen |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-08-20 : 11:56:31
|
| Take a look at this thread, and in particular Bill Elicson's response - he is saying you can download the express toolkit which will give you DTS capabilities.: http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/546f4407-0aa4-4b04-96f3-e6f0ba39a9d1/ |
 |
|
|
xhostx
Constraint Violating Yak Guru
277 Posts |
Posted - 2012-08-20 : 13:39:09
|
| if you are exporting data for good from the SQL 2000 you can always write a a quick script that export all your data.--------------------------Joins are what RDBMS's do for a living |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-20 : 16:57:30
|
quote:
Originally posted by jlassiter76
My company has been using SQL 2000 for many years, and we have built several custom DTS packages to process our daily jobs.Our new software requires that we now use SQL 2005, and it is only the Express Edition which has no SSIS features. Without SSIS or DTS, how can I setup some of the same packages in order to get our data processed properly? Should I use a VS solution? Microsoft Access? Can I possibly work with the SQL 2005 tables in SQL 2000 and use our same DTS packages?I'm very new to this...so thank you in advance.-Jen
you can use DTS packages in SQL 2005 also. just need to migrate them to SQL 2005 instance. If you're edit or modify them, then you need to install dts designer component in sql 2005 though!------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
What can I do without DTS?