Not in BIDS. In SQL Server Management Studio, click on connect and change from database service to integration services. If u just want to check if the package exists in...

If u want to log to a table and save the history then, u will need to have the infrastructure in place.

1. The logging table(s)

2. The stored procedure that logs...

FMTONLY option will do the trick.

You could also add a script task with an execute stored proc in it that records the counts and inserts to your log table.

Connect to SSIS (Integration Services) and not MSDB in your database server.

You could put the script in an appropriate event handler (but watch for excessive\unnecessary firing). If u put it in the event handler, the event handler will let the script...

Nevermind the email. See attachment.

I think i know why u r getting that error. In the ForEachLoop task, in the Variable Mappings... r u mapping the variable 0 to AppName? I have a demo...

If u have not already done this...Can u isolate the problem by disabling the task inside the foreach task and maybe add a script task to display the AppName that...

Are you running this in SSIS? Any locking issues?

Try running profiler with deadlock events: Deadlock, DeadLock Graph and DeadLock chain. Also include the SQL Stmt completed and sp events....

Does your stored procedure that you use in the EXEC SQL Task have any input parameters? If it does are they mapped to the correct types. If you have an...

I have used the SFTP from nSoftware ... real simple to use, cool customizations, the price is also reasonable. There was a small prob though (not sure, coz i used...

Have you tried using expressions for the filename?

Addition to prev post:

What would be the impact of taking snapshots on evry step? i.e. if you data warehouse\db is very large? I guess i would have to include...

What would be the impact of taking snapshots on evry step? i.e. if you data warehouse\db is very large? I guess i would have to include a some logic to...