Koen Verbeeck (3/10/2011)

---

Well, I don't really see a difference between running a SQL Server Agent job or...

I suppose it would be an option, but why would I want to? I just want to run a single command line utility, not much different than using the...

Alvin Ramard (3/3/2011)

---

Actually, if there is no file, the container itself executes, but the tasks inside the container will not, since the container did not find any files.

Good luck. ...

Alvin Ramard (3/2/2011)

---

If I understood correctly, try a ForEach container for each file type and set the file criteria of each container to only pick up that file type.. Inside...

Alvin, that is what I did in my choice number two above. I just didn't go into the details of it. I imported the data as a single...

P Jones (10/11/2010)

---

I'd try putting an SSIS "for loop" sequence container with a variable set to true and never changed and an evaluation expression testing that variable for false. Inside...

The second output method worked great. Now I have a corollary question for anyone willing to jump in here.

I also want to *update* a table with status.

i.e. based on original...

Russel Loski (9/7/2010)

---

Another way to handle this is to add an output to your script component. You would add a row to the second output with the information that...

Fortunately in my case it doesn't matter as my primary key index is nonclustered.

Any comments to share on the second half of my post?

Jeffrey Williams-493691 (8/11/2010)

---

I would create a stored procedure that loops continuously - and put in a WAITFOR DELAY.

Then, create a SQL Agent job that checks to see if the process...

Thanks for the reply, Andrew. I have something very similar to that in place. Once I realized I was trying to do too much in one step; I...

I did. I checked both sysfiles and from my local SSMS and the results were the same.

I don't what happened but I deleted the extra files that showed...

Steve Jones - Editor (4/12/2010)

---

If the issue is finding space, then separate filegroups will definitely help. Just didn't want you to think that you could easily piecemeal restore. You can...

Stefan_G (4/12/2010)

---

It sure sounds like you could benefit from partitioning.

It sounds like you have a very large table with data that covers a long time period and the table only...

The issue we most recently had was finding enough space to restore the file to. We were still on SQL Server 2000 at the time. Our backup/restore is...