Thanks for the response, now I just have only 1 package instead of 2 packages. How do I check for the file existence and then exec the package if the...

Ben,

Please let me know any article you may have to do this. Thx much.

Thanks for your response, I imported by right-clicking on...

I did the following to save the SSIS package onto db server:

Imported the SSIS package into MSDB folder and also imported into the

\MSDB\Maintenance plans folder.

I get the following error:

Could not...

Thanks for your response, Is it safe to use File watcher task, as I heard that it can cause memory leaks!

I set the option of timeout value to 2 minutes...

I linked up the File watcher task and the Exec package task(Filesystem - with the desired package that should execute when true).

Do I need to schedule this package1 which...

Since the SSIS packages are not in MSDB, I did the following:

1. Right click on MSDB

2. Import package

Inside Import package window:

Package location: SQL Server

Server: servername

authentication: windows authen

Package path: \\server\C$\folder1\SSIS...

Yes, I did that and it shows...

Any help will be great!!

Here's what I did so far, struggling with this for the past two days to get it work, any help is greatly appreciated:

I have foreach loop container, inside which there's...

This will give you exactly what you need, loading data from multiple excel files was a big pain, it took me a while to figure this out.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2317252&SiteID=1

size of the Tran log backup's is 220MB(average).

How about this one, I want to know if Free: 1756.5MB is it okay for the database??

1. I have the following question on the space allocated for DB's:

From the task...

I need to find out if debug and trace will help us to determine why the connection is being lost as we are losing connection once in a while when...

In what order does the following need to run:

1. Reorganize data and index pages

2. Update stats

3. Check database integrity

Also since Reorganize data and index pages takes care of Update stats...