Im looking for a sample Data Transformation Script

Question

Im looking for a sample Data Transformation Script

Paul Hunt

SSC Journeyman

Points: 83
More actions
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.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Peter P SSCrazy Points: 2777 More actions · Answer 1

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

Jeremy Kemp SSCertifiable Points: 6754 More actions · Answer 2

Here is another site that might help you

http://www.sqldts.com/

Jeremy

rschaeferhig SSCrazy Eights Points: 8776 More actions · Answer 3

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.

Russel Loski SSCertifiable Points: 7059 More actions · Answer 4

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

amackay_1 Ten Centuries Points: 1240 More actions · Answer 5

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.