Ken, A lot of what had to be done in VB can now be done natively in SSIS. It is really designed as a tool for migrating data from a transactional system to a data warehouse. There is also a really good work flow capability which was very basic in DTS.
Because of work flow, it is sometimes easier to do SPs than DTS. At 02:28 AM 12/19/2008, you wrote: >Date: Thurs, Dec 18 2008 7:38 am >From: "Ken Auenson, II" > > >So, I have not yet been exposed to SISS in SQL Server 2005, but I am >maintaining a few DBs that are SQL Server 2000 that had a lot of DTS >packages. >At one point, I re-wrote most of them to be straight stored procedures. >I find this to be a lot easier to maintain and a lot easier to actual work >with. >What tasks and added power to DTS and/or SISS have that you cannot do in >straight stored procedures? >In other words, what features/benifits am I missing out on? > >Thanks, >Ken Robert Stewart ProjecTools.com 713-371-9840 X1305 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en -~----------~----~----~----~------~----~------~--~---
