Can anyone tell me what all steps in creating DTS package , how it saves,
how it re executes... what all steps ... and how it makes?
Thanks
Aravind
SQL Server 2005 has replaced DTS with a new ETL toolset: SQL Server Integration Services, or SSIS.
Are you asking about DTS, or SSIS?
If you're asking about SSIS, then the place to start is here: http://msdn2.microsoft.com/en-us/sql/aa336312.aspx.
As you're probably aware, you're asking questions that it would take several books (and not just a quick forum reply) to answer. Here are these books:
Microsoft SQL Server 2005 Integration Services (SQL Server Series) by Kirk Haselden Professional SQL Server 2005 Integration Services (Programmer to Programmer) by Brian Knight, Allan Mitchell, Darren Green, and Douglas Hinson http://www.amazon.com/s/ref=nb_ss_gw/102-5091542-4864925?url=search-alias%3Daps&field-keywords=ssis
No comments:
Post a Comment