Hello, I'm new to SSIS so maybe there is a very simple solution for my problem. I have a table named MyTable. Before loading data into it, I first check if the table exists. If not, then the table is created. After the task is executed and the table is created, I find that the rest of the ETL does no execute, but returns an error saying that the table does no exist. I think that the ETL is executing too fast to realize that the table has been recently created or maybe i am missing a step between the table creation and the data load. Any help to solve this will be really appreciated. Best regards, Carlos

Are you using an Execute T-SQL task to check for/create the table? And are you using a dataflow task to load the data? Does the package fail on validation or when its executed? Are you sure that table gets created (in the right schema etc)?every day is a school day

Why is package checking the Table availability everytime. You could create the table as One-off and load the data as per your requirement on daily basis. If you are executing above task from T-SQL, then good if you can paste it in forum. Please Vote & "Mark As Answer" if this post is helpful to you. Cheers Prakash Nandwana Bangalore , India

Yes, it might be the result of the latency in creating the table. To make the package wait use this: http://consultingblogs.emc.com/jamiethomson/archive/2006/10/23/SSIS_3A00_-Put-a-package-to-sleep.aspx But do not put it to sleep for too long.Arthur My Blog