Post reply

Im looking for a sample Data Transformation Script

  • May 12, 2004 at 1:04 pm

    #161330

    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

    #506201

    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

    #506266

    Here is another site that might help you

    http://www.sqldts.com/

     

     

    Jeremy

  • May 13, 2004 at 5:00 am

    #506270

    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

    #506284

    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

    #506462

    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