|
Beak for yourself - I'm happy to just wing-it.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
Flocking easy for you to say!
... such stuff as dreams are made on
|
|
|
|
|
Migrate retorts are just too much for you!
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
Nest u gonna say I'm the one talking a lotta gull.
... such stuff as dreams are made on
|
|
|
|
|
And, do they congregate around dead meet?
... such stuff as dreams are made on
|
|
|
|
|
megaadam wrote: ... such stuff as dreams are made on
SMUT - the stuff that dreams are made of.*
*and made of dreams.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
W∴ Balboos wrote: SMUT - the stuff that dreams are made of.*
WTF does that mean?
it is: "such stuff as dreams are made on" - Shakespeare.
Sin tack
the any key okay
|
|
|
|
|
Ask a consenting adult . . .
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
What the elephant would I have to consent to, to qualify? 
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
OriginalGriff wrote: What the elephant would I have to consent to, to qualify?
He asked, sheepishly.
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
need carrion because nowhere to stow checked baggage
Sin tack
the any key okay
|
|
|
|
|
Quote: need carrion because nowhere to stow checked chicked baggage
FTFY 
Cheers,
Mike Fidler
"I intend to live forever - so far, so good." Steven Wright
"I almost had a psychic girlfriend but she left me before we met." Also Steven Wright
"I'm addicted to placebos. I could quit, but it wouldn't matter." Steven Wright yet again.
|
|
|
|
|
That's aviary fowl one indeed!
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
The culture of the vulture is condoned by the department of agriculture 
|
|
|
|
|
Oblighters xkcd: xkcd: Time Vulture
If you have an important point to make, don't try to be subtle or clever. Use a pile driver. Hit the point once. Then come back and hit it again. Then hit it a third time - a tremendous whack.
--Winston Churchill
|
|
|
|
|
|
|
It seems you can't run dtsx packages AT ALL on sql server express. I guess I'm going to have to resort to writing an app that uses MEF to load a specified DLL that I have to then write...
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
SSIS, yuck. I've been doing nearly exclusively that for about five years now.
I have come to the conclusion that using an ETL package to do a whole friggin' lot of E and L but hardly any T is just not a wise course of action.
Writing some simple code to do just E and L based on some list of sources and destinations is the smarter choice. But there's no way to convince PHBs of that; to them it's like your claiming to be smarter than Microsoft.
And now someone has convinced the boss that Ab Initio is better at T than SSIS is, so he wants to switch to that -- But we don't do any T!
|
|
|
|
|
I don't mind doing SSIS stuff (especially when my only other dev opportunity is qlikview). The bane of my existence is that even though I was forced to get a MCSA cert for this job, I don't have a lot of the permissions I need to actually do what my job requires. It's a f*ckin clusterf*ck here as far as DB support goes.
I'm working on a SQL Agent project (for an article) for SQL Server Express. I've got the scheduling stuff done, and step execution (as long as it's a just SQL query), and even job history stuff appears to be working. I tried to implement the "run a dtsx package" step type, only to find out it won't work, so I have to roll my own, such as it is. Unfortunately, it requires the programmer to write c# code to do anything like importing an Excel file, and stuff like that. In order to provide a complete solution, I may have to come up with an excel importer library that makes using the office interop crap more digestible.
The fun never stops.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
We had the same issue until we did a performance comparison, we use SSIS to simply load into staging tables and do all the transforms via stored procs. And don't give me any bullshit about users able to maintain their own SSIS, it has never happened.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Sounds a bit like my experiences in the past with SQL Server SMO and backup / restore commands that suddenly would not work anymore after upgrading to a newer SQL Server version.
Luckily we have disposed of SQL Server in favor of PostgreSQL about a year ago, what a relief 
|
|
|
|
|
Well, the fix wasn't that hard. I created a commandline app that dynamically loads the specified DLL and executes the Run method. The class in the DLL must derive from a specific abstract base class (in its own DLL), and implement a single method called Run. What happens in the Run method is completely up to the programmer.
I'll most likely implement an Excel importer class in the DLL that contains the abstract base class, and it will be available to any deriving class that needs it.
The only thing the programmer has to do is create his own DLL (following the requirements necessary to be compatible with the system) that will serve as the "dts package". Creating a visual tool to replace the visual studio BIDS project, while technically feasible, is a "step to far" as far as I'm concerned right now. A sample package dll will be included in the solution.
Another challenge met. Onward and upward.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
SSIS is a pain...<the rest="" of="" my="" comments="" need="" to="" be="" filtered="">
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
|
|
|
|
|
Is this with the latest sql server version? I thought MS removed everything but the scaling for heavy load feature restrictions from the mundane versions of sql server with the latest release because someone finally explained to the PHBs in Redmond that even if a company was willing to buy a $100k database server and run the most expensive version of the database on it; they generally weren't willing to buy additional stupidly expensive licenses for developers and limited feature usage to whatever would also work on the express install on the devs machines.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
