August 7, 2015 at 8:23 am
Hey all,
So we have a series of packages that pull data from an Oracle source and bring it over to tables in our BI Warehouse. There are a series of different packages depending on the table and data being pulled.
I have just updated one of the packages to add in an extra column from the source table. I have updated the tables (temp and live tables) with the new column. I have also updated the update stored proc to update the items that are not new.
When previewing the data I can see it, I have mapped the fields correctly, and if I manually run the package it works first time and pulls in and updates the data. However as part of the daily run schedule it nulls all the fields and also doesn't bring in any data. It also doesn't error at all, so can't see why it's not doing what it needs to. It's still doing all it needs to with the rest of the data so I clearly haven't broken anything :-P.
I have had a look and the package has definitely saved however looking in the bin folder it looks like the last update for this package was some time ago.
Any pointers at all or areas to look? It's the lack of errors that is flummoxing me!
August 7, 2015 at 8:40 am
Is the package which you have modified definitely the same as the one which is being executed?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
August 7, 2015 at 8:49 am
Hi Phil,
Yep not changed the name of the package.
Stages were:
Updated tables in MS SQL
Updated sp in MS SQL
Went into SSIS package
Added additional column to OLE DB source in Data flow task.
Updated mappings in OLE DB destinations in Data Flow task (same one as above).
Hit Save. Ran package in isolation. Worked first time.
Daily import and update happened which includes this package. Didn't perform the inserts and updates on this column.
Flummoxed me as I would have thought saving it would be ok.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply