Viewing 15 posts - 2,941 through 2,955 (of 9,707 total)
Koen Verbeeck (1/14/2015)
Luis Cazares (1/14/2015)
Congratulations Koen! When I grow up I want to be like you. :hehe:Action figures will soon be available! 😎
With or without superhero capes?
January 14, 2015 at 12:01 pm
The dynamic SQL is going to be hard to get around unless you hard code all your USE DATABASE statements.
There are two ways of getting around the sp_MSforeachdb. The...
January 14, 2015 at 10:08 am
Koen Verbeeck (1/13/2015)
Jimmy123 (1/13/2015)
Fairly certain. Think I has been stung by this recently. I am now definitely thinking convert to csv.
I tested it and the numeric value is imported as...
January 14, 2015 at 6:04 am
Koen Verbeeck (1/13/2015)
FYI, I received the Author of the Year award at MSSQLTips.com!Thanks everyone for voting!
Congrats!
January 14, 2015 at 6:02 am
Excellent.
Apparently option 1 is the option of choice. My only worry was that if you were in production, it might stop stuff in the middle of processing.
Does that help?
January 13, 2015 at 9:05 am
IncidentalProgrammer (1/6/2015)
Grant Fritchey (1/6/2015)
January 13, 2015 at 9:01 am
Jason,
Is this production or a non-prod environment?
January 13, 2015 at 8:58 am
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
Viewing 15 posts - 2,941 through 2,955 (of 9,707 total)