Im looking for a sample Data Transformation Script

  • 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.

  • 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

  • Here is another site that might help you

    http://www.sqldts.com/

     

     

    Jeremy

  • 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.

     

  • 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

  • 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