whats a good SQL book to learn DTS?

[richardycc]

trying to write a simple DTS package, its hard than I thought...any good book rec?

 

[imported_Dhaval00]

Is it the "old" DTS or the new SSIS? Frankly, there are no good books with lots of step-by-step examples for SSIS yet. I also attended the first worldwide delivery of MS training modules for SSIS late last year... the feedback was mixed, and so MS has those classes on hold for some time I believe.

But then, I read almost all the books on SSIS available out there, and kept practicing in Visual Studio. End result was a huge success for a couple of our customers. The best book amongst the ones I read was Sams Microsoft SQL Server 2005 Integration Services. I find Jamie Thomson's Conchango blog a great SSIS resource. With that being said, there are soooooo many caveats in SSIS that haven't been documented properly, and the best way to learn them is by banging your head against the table for days

By the way, if you were looking for resources for the "old" DTS, then that pretty much renders my post useless!

 

[richardycc]

this is for the 'old' DTS, we are still using sql server 2000. I am basically need to do a DTS to do some query and if the rowcount is not 0, it will then send out an email. I am having problem passing the rowcount as a global varible to the activex script...maybe I don't even need to use activeX for something this simple?? this looks so easy, but I am having problem connecting things together to make it work... I have the stored proc done and the send out the email part done already, just need to connect them together.

 

[imported_Dhaval00]

Have you looked at any of the samples installed by default with SQL Server 2000? Most people forget that these samples sometimes offer invaluable information. I believe by default they are all installed to C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Dtspackages. Here is a list of the different examples on TechNet: http://technet.microsoft.com/e.../aa217035(SQL.80).aspx. Another good resource when it comes to SQL Server in general is TechNet.

Also, I spoke to one of the older developers on my team and he mentioned that the SQL Server 2000 DTS Step by Step from Microsoft Press is a good source for getting started.

Good luck.

 

[richardycc]

can anyone help? I tried everything, like raiserror, but the DTS will error out instead of failure, so the email didn't send out.