May 6, 2010 at 4:38 am
Hi Experts,
I have been asked to give a session on SSIS Deployment.I dont know what are all the thinks i should mention and where to start?
Can anyone please help me on this?
Thanks In Advance
May 6, 2010 at 5:25 am
Hi Raathesh,
You may begin in the following order...which I am comfortable with:
1. Package execution in BIDS.
2. Package execution in SQL Server environment.(Running/Stored packages)
Storage options(MSDB and File System) and Msdtssvr.ini file structure
3. Configuration management and benefits in multi server deployment environment.
4. DTExec(UI) and relative commands.
5. you might also cover logging and various modes or logging available.
I hope this helps.
Raunak J
May 6, 2010 at 10:57 pm
Thanks alot Raunak,
Can you please provide detailed information on the same??
any docs,links ??
Many thanks
May 6, 2010 at 11:35 pm
Thanks Raunak,
I selected the link http://www.databasejournal.com/features/mssql/article.php/3600201/SQL-Server-2005-Integration-Services---Packages-Deployment---Part-23.htm.
I hope i selected the right one..
Is ther any link for SQL 2008?
May 6, 2010 at 11:39 pm
Hi Ratheesh,
Books Online (BOL) is the best resource...
Anyways what are the milestones you wish to cover in SQL Server.:-):-):-)
Raunak J
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply