Viewing 15 posts - 8,971 through 8,985 (of 11,678 total)
Gianluca Sartori (9/14/2011)
I come from a contry on the edge of bailout, but I still can spell. 😉
Hihi 😀
September 14, 2011 at 6:58 am
Not to use SSIS? When you are moving data between tables on the same server and there is little logic, and you don't need logging, event handling et cetera, I...
September 14, 2011 at 6:52 am
Phil Parkin (9/14/2011)
What you should not do, by the way, is ask the user for run-time input via some sort of dialog box.
Indeed. SSIS is meant for ETL and/or maintenance...
September 14, 2011 at 6:49 am
brodak (9/13/2011)
did you get an answer for this?
The only real limition is the size of the machine's memory (RAM) where the package is running on, as SSIS loads...
September 14, 2011 at 6:42 am
sqlfriends (9/9/2011)
I am testing a package in design time, if I run in visual studio, will it use the connection string in the connection manager or...
September 14, 2011 at 6:39 am
I would do this in TSQL with the TRY ... CATCH construct, as it is impossible for SSIS to know which stored procedure failed. For SSIS, it is just the...
September 14, 2011 at 6:36 am
The "unknown" is the unknown bucket that is created automatically by each dimension. The cube will place all values that have no corresponding surrogate key to that dimension in the...
September 14, 2011 at 6:30 am
Congratulations Jeff! Well deserved!
September 14, 2011 at 5:24 am
Pretty easy question, if you eliminate incorrect answers.
@b-2 is never used, so the first and the last answer were impossible.
I knew there wasn't any incorrect syntax with the aliases, so...
September 13, 2011 at 12:23 am
CooLDBA (9/12/2011)
What's the solution?
Did you read the other topic where I linked to?
September 12, 2011 at 3:31 pm
palotaiarpad (9/9/2011)
Actually the question was: what will the above code output: no right choice, alter procedure fails instantly.
If you run the script on AdventureWorks2008R2, it is the constuction of the...
September 12, 2011 at 6:23 am
srikanthms (9/8/2011)
such as procedure must be already created, UnitMeasure table to be created with production user etc.
Because of this, this has to...
September 12, 2011 at 6:22 am
Viewing 15 posts - 8,971 through 8,985 (of 11,678 total)