Found the failure property and it works wonderfully thanks.
Yeah we are running enterprise so i'll try having them run in parallel and see what happens.
However as for using one source item, they are all coming from the same database/collection of tables but each feed implements a SQL...
We have some fairly substantial packages running as part of an over night warehouse load.
Two nights ago they failed due to a connectivity issue the package couldn't find the source server.
As a result we had to run the packages the following day during business hours. Now to some extent we...
Ok im reasonably new to SSIS and i was wondering if you could help.
I have a large database from which i need to pull large amounts of data. Row's numbering in the several million easily.
I need to pull the data out, aggrigate and transform it and pump it into a new database. I need this to...
Hi im not really sure at what exactly you want your query to do, if you can explain it i can help.
Looks to me like you need a case statement in your where clause something like.
Where Active_client = 'Y'
And sales = 1
AND 1 = Case
When day(getdate()) = 1...
Hi i need idea's of how to change the following. Im trying to Build a history table Which updates the current history data when a none critical field is changed, but inserts a new row when a critical field changes or a new service is added.
My problem is when a customer changes thier QTY ...
I've simplified the example somewhat but essentially im looking for a way of calculating the cost price of items recently sold based on a FIFO methods.
Here's two basic tables (somewhat simplified)
[Sold] ITemID, SaleDate, QTY, Price
1, '2009-05-01', 2 ,£13...
Hi,
im currently a software engineer and my career is going great having recently graduated university im exactly where i hoped to be at this point in my career.
However...
My significant other half sacrificed his own career to get me here and looking for suggestions to help him get back...
i wasn't sure it was clear, sorry.
heres the join's
{person.personid} = {employee.personid} (inner join)
{employee.folderid} = {manager.folderid} (left join as i want all employee's even ones without a manager record)
-------------
my selection formula is currently...
I have a table containing information on people, called person, this is linked to a second table called Employee, every person in Person has a record in Employee, so under most circumstances an inner join works well here.
However of those employee's "some" are managers, these have another...
In my job i work closely with SQL and Oracle as well as crystal, infact it was my experience with oracle that got me the job. So im pretty competent at pulling data from a database without the nice pretty interface crystal provides, and tbh i enjoy working with databases.
Is specialising in...
Having spent many years working a minimum wage dead end job where my manager contently took advantage of my IT skills and general willingness to go outside my job description.
I finally realised after 7 years of hollow promises that i was never going to progress and it didn't matter how many...
Won't a grandtotal on the detail level add up all of the values? i specifically only want it to add up the "max cost" for each item.
Example.
GH - Tin of Beans - 50 <---- Max of details
Details - Tin of Beans 30
Details - Tin of Beans 30
Details - Tin of Beans 50
Details - Tin of...
Ok what i have is something like this,
GH1 - name, Max(@cost)
Details(suppressed) - name, @cost
I have to use the a formula to pull the "cost" from the database because there are many types of costs in the database and im only interested in one kind.
And each item may have many of this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.