Home » Database » Ms SQL Server 2005 » Looping Operations in SQL Server Integration Services
Looping Operations in SQL Server Integration Services
1165
Category : Database » Ms SQL Server 2005
I defined two connections in a new SSIS package, a regular SQL Server data source pointing towards the SQL log shipping monitor/target server and an ADO.NET connection pointing towards TEMPDB on the target SQL server.
Download File Free PDF eBooks Download Database Ms SQL Server 2005
Content Summary :
The Foreach Loop container is one of the most flexible and useful
controls available to SQL Server Integration Services developers, but
the fact that it's relatively poorly documented means that it may not
get used as often as it deserves. In this example I'll describe how I
used it to build a workaround for a problem in SQL Server log shipping.
Due to low disk space we needed to delete log files as soon as they
were no longer needed without changing the log maintenance
configuration, but this had to be both automated and failsafe. The
Foreach Loop container made this possible. You can adapt this solution
for any situation where operations need to be regularly performed on an
unknown number of files with no fixed filenames. I'm assuming that
you're familiar with using the SQL BI Dev Studio tools and building
basic packages. If this isn't the case, I recommend working your way
through the Integration Services Tutorial in SQL Books Online to become
familiar with the basic concepts. Jamie Thomson's blog is an invaluable
resource when you're ready to go further with SSIS.
Favorite Ms SQL Server 2005 PDF File
12190
SQL Server 2005 For Oracle Professionals
category Database » Ms SQL Server 2005
It compares SQL Server and Oracle database architecture and provides information . Unlike the Oracle temporary tablespace users can create temporary .
2813
MS SQL 2005 Yukon And Oracle 10g Features Strengths And Weaknesses Comparison
category Database » Ms SQL Server 2005
Even in MSSQL server 7 and or 2000 you can disable lock escalations by using the . MSSQL 2000 on top of a Microsoft Cluster will failover to the other server .
6258
Sample Content From Microsoft SQL Server 2005 Analysis Services Step By Step
category Database » Ms SQL Server 2005
Understand how Microsoft SQL Server Analysis Services 2005 implements OLAP. . So what makes Microsoft SQL Server 2005 Analysis .
14958
SQL Server 2005 Express
category Database » Ms SQL Server 2005
Microsoft Acirc reg SQL Server 2005 Express Edition is the free easy to use . Microsoft Visual Studio Acirc reg 2005. and SQL Server Express reduce this complexity by .
7698
Microsoft SQL Server 2005 Database Mirroring
category Database » Ms SQL Server 2005
Microsoft SQL Server 2005 Database Mirroring Applied Technology Guide. 2 . following diagram is from SQL Server 2005 Books Online and demonstrates the .
