Viewing 15 posts - 16 through 30 (of 157 total)
In your SSIS dataflow, you could try using a Data Conversion Transformation, and convert the outbound flat file date column into a [DT_DBTIMESTAMP2] with a scale of 6. That...
December 22, 2011 at 1:51 pm
At first there was an issue with native audit failing to capture the literal value in parameter queries, it would only show the variable name. This was fixed by...
December 12, 2011 at 2:58 pm
Which version of SQL Server are you needing to audit?
When I needed to audit SQL Server 2005, I looked at SoftTree DB Audit Expert, Idera SQL Compliance Manager,...
December 12, 2011 at 2:23 pm
I use a combination of native SQL Server 2008 Audit and CDC for this in my environment. Before switching from '05 to '08, I assessed several third-party tools, but...
November 2, 2011 at 8:06 am
You can also use the the Activity Monitor in SSMS to see if there are excessive wait states or blocking while your SSIS solution is running.
October 17, 2011 at 2:14 pm
In my experience, good security is a collaborative effort. It is absolutely true that management buy-in is essential, but even a top-down mandate won't matter if the developers, sysadmins,...
September 14, 2011 at 11:01 am
In an instance of great irony, a third-party auditing application that I assessed for use in SQL Server 2005 required the use of the sa login. Not even another...
September 14, 2011 at 7:56 am
I don't know if it would make it a viable option for you, but with regard to SQL Server Auditing, there is an update available that will cause the actual...
September 13, 2011 at 11:01 am
Excellent! I'm glad that took care of it.
September 12, 2011 at 11:57 am
It looks like it's a general Visual Studio 2008 issue, rather than specific to BIDS:
I used to get devenv errors when running BIDS 2008 on XP Professional, but...
September 12, 2011 at 11:04 am
It sounds like your layout settings are not properly saving when you exit. Once you have your interface the way you like it, you can use the 'Tools > Import...
September 9, 2011 at 7:08 am
I don't know if I can offer any assistance. I've not used table-based configurations, all of the SSIS solutions that I build use config files without a problem. ...
September 2, 2011 at 5:59 am
Can you provide some detail as to what problem that you're having? No one can help you if you don't describe what's wrong.
September 1, 2011 at 10:27 am
If you right-click on the Variables tab, and select 'Floating', you should be able to drag it away and decouple it from the Toolbox. Then set the Toolbox to...
September 1, 2011 at 7:12 am
If you need to capture the actual rows that have been deleted or inserted, you can use Change Data Capture, since you're in Enterprise edition. I've had to implement...
August 16, 2011 at 1:15 pm
Viewing 15 posts - 16 through 30 (of 157 total)