Viewing 15 posts - 9,886 through 9,900 (of 11,678 total)
sql_2005_fan (3/7/2011)
But if I modify the package on my local copy(visual studio) , how can I update...
March 8, 2011 at 2:52 am
dndaughtery (3/7/2011)
The thing that irritates me is I haven't found a way to get the Estimated Row Length, if someone knows how to do that please let me know.
I answered...
March 8, 2011 at 2:49 am
Nice and easy, thank you very much.
(Easy is not a bad thing, it is good for one's self esteem that it is not necessary to dive into BOL to find...
March 8, 2011 at 2:05 am
In the somewhat special case of ETL, I'd sometimes like to turn of logging.
If a data load fails, the destination table can be truncated and the load can start over...
March 8, 2011 at 2:02 am
If I'm not mistaken, the estimated buffer length is the sum of sizes of the data types of all your columns. If you have data types with variable size, you...
March 7, 2011 at 7:39 am
I have been looking around the net a bit, but I don't seem to find a solution for your problem.
You could try to convert the file to a more appropriate...
March 7, 2011 at 7:36 am
camiloaguilar1 (3/7/2011)
Thank you very much to both of you. I'll check that right know.
Great! If you have additional questions, don't hesitate to ask.
ps: it is my opinion that anyone working...
March 7, 2011 at 6:47 am
The first step you have to take is determine what the maximum timestamp is. You do this in a seperate Execute SQL Task and you store the result in a...
March 7, 2011 at 5:16 am
You downloaded the SQL 2008 version, which is different from the 2008 R2 version.
You can find the R2 download here:
March 7, 2011 at 5:08 am
goldspoon (3/6/2011)
In change data capture the new tables(Audit tables) are created in that database only.i want to give other database as destination (capture instance).. is it possible?
I do not think...
March 7, 2011 at 4:01 am
You'll need a recursive CTE for that.
This MSDN article explains the concept:
March 7, 2011 at 3:41 am
As datawarehousing is an important aspect of BI, I would recommend the Kimball's Data Warehouse Toolkit:
A great book with some introduction to the concepts of BI and a general overview...
March 6, 2011 at 11:49 am
eric.johnson 33562 (3/4/2011)
March 5, 2011 at 4:23 am
Viewing 15 posts - 9,886 through 9,900 (of 11,678 total)