May 12, 2004 at 1:04 pm
Hello. I'm trying to write my first data transformation script and nneed a sample to start from. I have been looking at the sql server books on-line but haven't been able to find one.
Thanks for any help.
May 12, 2004 at 1:12 pm
Hi,
DTS scripts range from the sumblime to the extremely complex. So without knowing exactly what you are trying to do, here is a link that might help you out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspcust_5ru3.asp
May 13, 2004 at 4:20 am
May 13, 2004 at 5:00 am
Also, "Professional SQL Server 2000 DTS" by Chaffin, Knight and Robinson $34.99 on Amazon.com. This gets into a lot more detail than MSDN.
May 13, 2004 at 6:30 am
I cut my teeth on DTS by using the import wizard. I do an import, choose the objects to import, then rather than running the import right away, I save the package. I then examine the package to see how MS did it.
Russ
Russel Loski, MCSE Business Intelligence, Data Platform
May 14, 2004 at 6:48 am
I learned DTS by using the wizards initially as well.. I learned on SQL 7 and found the packages created using the wizards could be buggy, especially if you try to change them after being created by the wizard, but I was able to learn some techniques from them. It's a good way to learn the basics.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply