Viewing 15 posts - 32,836 through 32,850 (of 59,102 total)
Almost forgot to ask... how many "fields" did you have per "record" and what was the average length of each record in bytes for the delimited string method you were...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2011 at 7:34 pm
SQLRNNR (8/18/2011)
Jeff Moden (8/18/2011)
Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.
I've never used them. I've always used something else because they didn't use to be available....
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2011 at 7:32 pm
Evil Kraig F (8/18/2011)
Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.
I see it as the first step needed for ORM and RDBMS to start liking each other...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2011 at 6:39 pm
Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.
I've never used them. I've always used something else because they didn't use to be available. Not sure...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2011 at 6:37 pm
David Lester (8/18/2011)
"Ok, write this reporting app, based off the data in this db. Oh, small point, the db is presently an Omnidex "database"...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2011 at 6:18 pm
Evil Kraig F (8/18/2011)
Not exactly... but..... you need xp_cmdshell to trigger independent dtexec's... :hehe:
I have just three words for that very ironic statement...
BWAAAAA-HAAAA-HAAAAAAAAAAAAAA! 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2011 at 6:15 pm
OzYbOi d(-_-)b (8/18/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2011 at 6:13 pm
Welsh Corgi (8/18/2011)
Jeff Moden (8/18/2011)
dji (8/18/2011)
If I understand correctly, though, most folks I know say that SSIS won't import "text qualified" files (files with double quotes in them if a...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2011 at 6:10 pm
dji (8/18/2011)
Apologies, Jeff!I was most definitely referring to my solution of trying to squeeze the out dated OPENROWSET into the 64 bit environment when mentioning band-aid 🙂
Understood and thank you...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2011 at 4:59 pm
Heh.... I actually take exception to anyone calling any import method other than SSIS a "band aid solution". Let me ask... can you execute two instances of the same...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2011 at 3:30 pm
Gary Varga (8/18/2011)
Jeff Moden (8/17/2011)
shew (8/17/2011)
We are a "locked down" hosting facility (xp_commandshell as well as a host of other features is not allowed),
Heh... xp_CmdShell. 🙂 One of...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2011 at 3:23 pm
@Gus,
Dang... I knew there was something else I wanted to ask and forgot it for a moment. If it's not obvious that I'm no SSIS-Ninja, let me say that...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2011 at 2:55 pm
GSquared (8/18/2011)
Jeff Moden (8/18/2011)
David Lester (8/18/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2011 at 2:50 pm
David Lester (8/18/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2011 at 2:45 pm
Marios Philippopoulos (8/18/2011)
Databases are usually restored from prod backups on QA and dev environments, and those are generally non-secure environments, accessed by a lot of users.
That may be but there's...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 18, 2011 at 1:45 pm
Viewing 15 posts - 32,836 through 32,850 (of 59,102 total)