Viewing 15 posts - 2,956 through 2,970 (of 9,714 total)
Quick technical question (don't hurt me!). Google Fu refuses to tell me the max size of an object variable in SSIS 2008. Anyone know this off the top of their...
January 13, 2015 at 8:22 am
Jeff Moden (1/13/2015)
Tony++ (1/13/2015)
To ask the silly and obvious: Are they both either compressed or uncompressed?Doing full as compressed & diffs as uncompressed could get you that closeness in size.
I...
January 13, 2015 at 8:18 am
Brandie Tarvin (1/13/2015)
What about the other three tabs, Parameter Mapping, Result Set, and Expressions?
January 13, 2015 at 8:15 am
Brandie Tarvin (1/13/2015)
January 13, 2015 at 8:02 am
That is just the General tab, and not even all the information on it (timeout, codepage, bypassPrepare). What about the other three tabs, Parameter Mapping, Result Set, and Expressions?
Side Note...
January 13, 2015 at 7:54 am
jasona.work (1/12/2015)
January 13, 2015 at 7:17 am
SAMDEV (1/13/2015)
I would like to use same technique while inserting records into existing table. Is it possible by any way?
As per my knowledge IDENTITY function can be used...
January 13, 2015 at 7:14 am
Benki Chendu (1/12/2015)
January 13, 2015 at 7:10 am
You've posted this in the wrong forum. I'll ask Steve to move this to the 2012 forum.
January 13, 2015 at 7:03 am
Without knowing a few more details, this one is hard to answer.
Can you post pics of all tabs on your EXECUTE SQL task?
Also, how many is "more records"? Have...
January 13, 2015 at 7:02 am
SQLisAwE5OmE (1/13/2015)
GilaMonster (1/13/2015)
Likely to...
January 13, 2015 at 6:58 am
Peter2012 (1/12/2015)
We're using SQL server 2008 R2 and have been receiving the following error messages recently.
----------------------------------------------------------------------------------
Error: 14421, Severity: 16, State: 1.
Date12/1/2015 12:06:00 PM
LogSQL Server (Current - 12/1/2015 5:45:00 PM)
Sourcespid55
Message
Error:...
January 13, 2015 at 6:47 am
The other possibility (correct me if I'm wrong, everyone) is to use the DTSX Import Wizard from the 2008R2 server to grab the data from the 2005 server. It won't...
January 13, 2015 at 6:44 am
Koen Verbeeck (1/13/2015)
You can also set TypeGuessRows to 0 in the registry. It then scans the first 60,000 rows or so.
WOW. I did not know about that hack. Thanks, Koen.
January 13, 2015 at 6:39 am
Can you try explaining in more English and less code what you're trying to accomplish?
January 13, 2015 at 6:37 am
Viewing 15 posts - 2,956 through 2,970 (of 9,714 total)