Viewing 15 posts - 166 through 180 (of 358 total)
When I looked again it really is going to be hard for some of us 'Just BI' people to get through the certification. However I am sure that will cut...
April 23, 2012 at 12:39 am
463 is not what I'd call DBA focused. It's SSIS, MDS and DQS.
OK, will re read the spec for that exam
Books Online? Though if you've never done any DBA...
April 18, 2012 at 3:42 am
Tried Char rather than string, same thing! Just put 5000 characters in and it would not evaluate
:crying:
March 16, 2012 at 7:14 am
Daniel Bowlin (3/16/2012)
Have you tried DT_STR? In SQL Server an NVARCHAR is limited to 4000 characters because each character takes...
March 16, 2012 at 7:04 am
I really did not want to start creating stored procedures as well as packages. Always my methodology is to keep it as simple as possible.
I have looked at using...
March 16, 2012 at 6:55 am
This is an OLEDB source rather than an execute SQL task. The SQL for it is sourced from a variable. In my case PkgSQLBanana. PkgSQLBanana is a package scoped variable...
March 16, 2012 at 5:40 am
2008R2
March 16, 2012 at 5:22 am
Koen,
I did not assume it was inside a transaction.
Good Point
Mark:-)
March 8, 2012 at 1:04 am
Excellent, very descriptive response
Many thanks
Mark
March 7, 2012 at 4:51 am
Truncate table will not add to the transaction log, so where possible this is better.
Data Warehouses I have worked on have generally gone for Simple rather than full recovery...
March 7, 2012 at 1:52 am
Kind of
"Any variable that is marked as sensitive. The marking of variables is controlled by Integration Services.
Whether Integration Services considers a property sensitive depends on whether the developer of the...
March 7, 2012 at 1:37 am
Is there anything else that is affected by dont save sensitive?
Like the SQL Server connection string?
By default most of my packages use config files for Server \ Database Names for...
March 7, 2012 at 1:17 am
Have been looking into this a bit more.
There appears to be two components to the security.
1. The ability to edit the package
2. The security of passwords
I already use config files...
March 6, 2012 at 12:44 pm
Many thanks. Makes perfect sense now.
Cheers
Mark
March 5, 2012 at 3:08 am
Just reading through 70-461 Skills Measured and came across this
•Design views.
?This objective may include but is not limited to: ensure code non regression by keeping consistent signature for procedure, views,...
March 5, 2012 at 2:28 am
Viewing 15 posts - 166 through 180 (of 358 total)