Would it be possible for you to take a picture of your package's data flow and posted here, it will be a lot easier to help you, because your replies...

It seems you overlook step number 4; the variable @[User::FileName] is the one defined by the ForEach loop in the control flow, just make sure your that the Excel Source...

Hi Raghavender

How is your package handling its data sources? e.g. Does it have a single data source for all the instances it reads? (this option requires a loop over...

I can't answer your question, it resolved the problem you described on the original post; now you got a working application, feed it with your data, try to break it,...

Welsh

I don't have Oracle installed on my environment, so I am Googling tracing possible reasons, I agree, it is an Oracle's configuration.

I am not sure if you found this article...

Welsh,

You got two Oracle's clients installed, you should verify that all your tnsnames.ora files contains the entry for the server you are trying to reach, you mention that tnsping worked,...

It seems there is not script code in your script component double click on it and:

1. make sure you selected C# code, if you did not, or if you...

Hi clucasi

I do not know if you resolved your issue; your scenario can be handled by a flat file data source and one script component; It is written with BIDS...

Hi hemanth T

It could be possible that your Excel data source has the Excel file name hard coded; are you dynamically updating it from the loop variable?

You may take a...

Koen Verbeeck (7/2/2012)

That is for reports, not SSIS packages.

@SQL_Surfer: when you schedule your packages with SQL Server Agent, you can use it's history to get the information. If...

sohailaziz1

Cubes are awesome tools, you may look at them as a 1000 reports in one single object, end-users will be able to manipulate their data in different ways beyond their...

Absolutely not; sometimes postal services are slow :w00t: it was spot-on comment

You may take a look at these topics: Could not deploy the reports on the report server and Can't deploy reports from BIDS to reporting services

Cheers,

... and 20 months later, there was a follow up reply :hehe:

Please take a look at the ExecutionLog view; there are 3 views depending on the version of MS SQL you are using; this is the MSDN article, it may help...