Protect the Excel files generated by SSIS package-Part I
It is not only the data within the database that requires protection but any report generated using SQL Server needs to be protected before being mailed
2010-10-28
12,280 reads
Integration Services (SSIS)
SSIS Events and Handlers
Explore how SQL Server 2008 Integration Services' events are triggered during package execution and the ability to react to their outcome through event handlers.
2010-09-30
2,337 reads
2010-09-20
3,070 reads
2010-09-13
2,985 reads
Top 10 SQL Server Integration Services Best Practices
Learn the top 10 best practices for large scale SSIS packages from a real world DBA.
2010-09-13
13,639 reads
2010-09-07
3,222 reads
Automatic Restart of SSIS packages after Failover or Failure
SSIS makes it possible to minimize work lost by starting after the last successfully executed control flow task upon restarting a failed package. From there, one challenge many seek to overcome is automatically restarting that package at that point without any manual intervention. This would make it possible for your SSIS packages to be running, your cluster to failover, and your SSIS packages to restart and complete without you having to respond to the failover and restart them.
2010-09-03
2,181 reads
Parsing an ADO result set into a comma separated string in SSIS
This article describes a way to parse a result set in SSIS using For each loop container, variables and SQL task.
2010-09-01
9,417 reads
2010-08-30
2,934 reads
A deadlock was detected while trying to lock variables in SSIS
Error: 0xC001405C at SQL Log Status: A deadlock was detected while trying to lock variables "User::RowCount" for read/write access. A lock cannot be acquired after 16 attempts. The locks timed out. Have you ever considered variable locking when building your SSIS packages? I expect many people haven’t just because most of the time you never see an error like the one above. I’ll try and explain a few key concepts about variable locking and hopefully you never will see that error
2010-08-26
3,320 reads
Blogs
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
KDA: Echoes of Deception - Case 4
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Forums
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Calculating the Harmonic Mean in Power BI
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers