Viewing 15 posts - 8,611 through 8,625 (of 11,678 total)
I think it is worth mentioning you are also working with SSIS.
Why are you trying to store rowversion into a variable?
Wouldn't it be easier to do the comparison directly in...
December 8, 2011 at 3:34 am
Can't you use User!UserID?
http://blogs.msdn.com/b/tudortr/archive/2004/07/20/189398.aspx?wa=wsignin1.0
December 8, 2011 at 2:59 am
Senthilkumar-456461 (6/27/2007)
Hello all,
I'm having 8+ months of experience in SSIS, Can any one tell me Some Interview point of questions for me, I have an interview from PWC.
Pls help me.......
Are...
December 8, 2011 at 2:51 am
martin.whitton (12/8/2011)
Is there an error message for just this occurrence?
And, no, Philip,...
December 8, 2011 at 2:47 am
Hmmm. When I click on the Forums link on the homepage, I get the maintenance page.
(http://www.sqlservercentral.com/Forums)
However, the link http://www.sqlservercentral.com/forums - with a lower f - works.
The forums themselves obviously work...
December 8, 2011 at 2:25 am
Christian Buettner-167247 (12/8/2011)
Why not in prod?Don't you have 82 GB left for 32,767 empty Databases? 😉
I do. It is the angry DBA I am worried about 😀
December 8, 2011 at 2:16 am
The best, most maintainable way is to store your packages in the MSDB database, and not on the filesystem.
If that is not an option, go with package configurations.
December 7, 2011 at 11:53 pm
The problem is that you are processing two versions of the same business key in the same batch.
When you do a lookup on your destination, the business key doesn't exist...
December 7, 2011 at 11:51 pm
Angelindiego (12/7/2011)
December 7, 2011 at 11:45 pm
:w00t: Easy one! Thanks!
It should be easy to test.
WITH CTE_Numbers (number)
AS
(SELECT ROW_NUMBER() OVER (ORDER BY sc1.name) AS number
FROM master.sys.columns sc1, master.sys.columns sc2)
SELECT TOP 32767 'CREATE DATABASE Test' +...
December 7, 2011 at 11:38 pm
SQLRNNR (12/7/2011)
Took the plunge on 70-451
Congrats and good luck with the BI track.
December 7, 2011 at 11:27 pm
Although they almost look identical, they are surely not. The first one has 4 column, the last one 3.
You can do some preprocessing, by removing the final comma from the...
December 7, 2011 at 11:25 pm
Ah yes, you are still using the MIN aggregate, so you will of course get only one result.
I should drink more coffee.
I just noticed you are using in fact "MIN...
December 7, 2011 at 5:36 am
It creates a new column in your dataflow with the name that you provided in that property.
December 7, 2011 at 5:30 am
mic.con87 (12/7/2011)
December 7, 2011 at 3:49 am
Viewing 15 posts - 8,611 through 8,625 (of 11,678 total)