|
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
|
|
|
|
|
I'm using SQL Express 2012. I don't know if this applies to 2014, 2016, or the upcoming 2018...
".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
|
|
|
|
|
|
Don't you think that that photo is photoshopped ?
|
|
|
|
|
The video as well? 
Anything that is unrelated to elephants is irrelephant
Anonymous
-
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-
I'd just like a chance to prove that money can't make me happy.
Me, all the time
|
|
|
|
|
No that would be VideoShopped. 
|
|
|
|
|
Industrial Light and Magic?
|
|
|
|
|
Deffinitely.
There is no way Indian industry is causing pollution. Bohpal was also photoshopped. Those corpses came from images of the first world war and were touched up to look like indian women and children.
|
|
|
|
|
The problem with not trading with these countries is where else can we get our blue jeans, other garments and dogs from?
I'm happy paying £30-40 for a pair of jeans, make them in a country were the rules on pollution are stricter and wages are higher and the price becomes £100+ Then I'm going naked from the waist down and believe me you don't want to see that. 
|
|
|
|
|
Dont you find the blue dogs stain everything the come into contact with, just like those cheaply dyed jeans?
I can't tell you the number of sofa covers we have got through with our two!
KennethKennedy wrote: you don't want to see that
Just dye yourself blue, no one will notice the difference!
|
|
|
|
|
I know nightmare isn't it and never wash your light coloured dogs and your dark coloured dogs in the machine together, don't ask me how I know that.
|
|
|
|
|
Take them out back and have a go at them with a jet wash. I find it works pretty well, even though it tends to remove the hair aswell.
Still, makes for an interesting new breed of hairless pooch!
|
|
|
|
|
I cry bullshit, the colour is too consistent to have come from a dog swimming in a river. Most dogs will not happily put their muzzle under was, especially if the water is not clear.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: Most dogs will not happily put their muzzle under
Ever seen a labrador and water?
It is possible the dog fell into a leather tanning vat, or some effluent that happened to dye it blue.
Either that or it got caught up in Divali!
|
|
|
|
|
Mycroft Holmes wrote: I cry bullshit
Tourette's is it?
|
|
|
|
|
|
What about them? (They are grey anyway)
|
|
|
|
|
Deconstructing body, degree and Rex. (8)
Have fun!
Peter
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
