If you don't like this behavior you can write a script later in your SSIS package to clean up these empty files. ... He is also the President of the Colorado Springs SQL Server User Group.

Working with SSIS Variables in Script Tasks. ... SQL Server MVP, is the owner of Consortio Services in Colorado Springs providing IT systems management and technology consulting.

SQL Server 2005 also promises better performance. I didn’t run performance benchmarks for this review, but in addition to allowing DBAs to partition the database to balance load, Microsoft has ...

Execute SQL tasks run stored procedures or SQL queries from SSIS packages. A task executes any SQL statements that have been passed to it in sequential order. It provides you with a handy way to ...

Designed and integrated into SSIS, Attunity SQL Server -CDC for SSIS integrates SQL Server data efficiently and in real-time. Dramatically simplifying the creation of CDC solutions, accelerating ...