I think if this is your code you may have a clue with isolating where the problem may be rather than providing a entire code dump. But I did find...

Visit Books Online and go down the SSIS tree. There are descriptions for every control flow item in there. Once you have a feel for that item start tinkering with...

You wont need to create a config file for the master...

Try

dbcc opentran

to look for any open transaction. If nothing, you can try issuing a 'checkpoint' command on the database to commit data in the systems memory.

mmartin1 (7/21/2013)This issue may have more than meets the eye. Depending on the exact work that you do and the money you make, the company may be able to say...

This issue may have more than meets the eye. Depending on the exact work that you do and the money you make, the company may be able to say you...

You can create a data driven subscription for the user. Here you can define the report parameters and the report generates based on those and emails itself to the user,...

Right. It seems intuitive. I've found that has not always been the case with my queries.

I hope I dont confuse you here :

Select T1.C1, T2.C2

From T1 Left join T2

on T1.C1 =. T2.C2

is equivalent to

Select T1.C1, T2.C2

From T2 Right join T1

on T1.C1 =. T2.C2

The...

Create a date variable , assign the value of CONVERT(DATE, DateAdd(yy, - 5, GetDate())) to the variable and use the variable instead in your query. This may be more...

Just to be sure, is the config file with the user credentials stored in the same directory as...

I concur with opc.three comment above. Are the package, job on different machines? What about the target server of the ole db connection ?

Have you considered using the SSIS execute sql task? You can map parameters to it. If you need to do many somewhat independent things as a batch, add them as...

Will do Gail, appreciate your help. Thanks

A stored procedure and a view will both return you a result set. A stored procedure can accept parameters, such as start date and end date... whereas a view cannot....