Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
netic
Starting Member
7 Posts |
 Posted - 2008-03-29 : 21:47:39
|
| Thanks in advance in reading this thread.I have developed a big SSIS package to extract data from flat-files ( + 200 Dataflows ).The situation is the following, inside de SSIS package, there are a lot of validations before extracting & loading the flat-files, i'm running this validations in paralell, so that when a file arrives, it enters the "validation process" and start extracting the file.When i run the SSIS package from BIDS it works the way i have concepted it... but when i run the ssis in the server, the tables that are loaded through the process are only "available" when the SSIS PACKAGE ends, it is imperative that trough the process, when a table receives new data, it becomes ready, and don't just be available when the SSIS package finishes...I have attached the an lousing .jpeg.It is importart for the tables to be available, so the stored procedures(OUTSIDE SSIS PACKAGE) that are dependent of some tables, start working before the SSIS package Ends.Thanks in Advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-30 : 03:13:11
|
| Which tables are you using to store the values/ Where are you trying to access them? outside of SSIS package? |
 |
|
|
netic
Starting Member
7 Posts |
Posted - 2008-03-30 : 07:34:31
|
quote:
Originally posted by visakh16
Which tables are you using to store the values/ Where are you trying to access them? outside of SSIS package?
Yes, i'm trying to access the tables outside the SSIS PACKAGE.Thanks in advance. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-30 : 12:59:57
|
| Are you using any containers inside the SSIS package? ALso what setting have you given for Transaction property of the package? |
|
|
|
netic
Starting Member
7 Posts |
Posted - 2008-03-30 : 15:44:12
|
| The package ends successfully, in BIDS or SQLSERVERJOB, but in BIDS, when tables become "available" before the package ends, and in SQLSERVERJOB, only when the package finishes, the tables become "available".I want to run parallel procedures, so for example:I have a table univerve ( TableA,B,C,D,E... TableZ).I have a stored procedure Universe ( OUTSIDE SSIS PACKAGE ) (ProcA,ProcB... ProcY).ProcA depends on TableA, TableC, Table P.To run ProcA I only need the Table A,B,P and not all table universe that is loaded in SSIS PACKAGE.Thanks for your effort. |
|
|
|
|
|
|
|
|
BIG SSIS PACKAGE (200 DATAFLOW TASKS)