Ok, I just wanted to wrap up this post.

So I went around and around trying to move files with the FileSystem task or the Script Task. It worked fine...

Graham,

I am using a sequence container, with precedents.

I do a foreach loop and then the filesystem task. So I believe this is the only operation going on...

grahamc (2/3/2011)

---

That sounds like the file copy is being blocked/slowed by something on the server...anti virus or something like that.

Do you have access to the server that the backup...

Lynn,

From one of the blogs that I looked at it, it suggested rename. I copied it from there. I can try to see if move makes a difference.

Here...

Michael,

A discussion of why our admins won't let us use Robocopy would be a digression from the topic for using SSIS to move files.

Plus please don't get me started on...

Our system admins won't let us use robocopy.

Have anyone else noticed a difference in performance when using the FileSystemTask component on large files?

Tony

Thanks for the response.

I will see how to translate that into SSIS coding.

The example that I found on the net that I used initially for this project was here:

http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html

This method...

Koen,

From my experience, ETL can mean Extract Transform Load, but it can also be Extract Transfer Load.

So, I know SSIS is a ETL tool, but from the many posts I...

Elliot,

Thanks for responding.

I have two backup servers. The admins didn't want to give us DBAs full access. So they created backup shares. We have full admin to...

Wow!! Thanks. And it says after I register, it is still free....

Now that is a help! If I can convert one, then I can use it as a template...

I found the answer by

1) Running the wizard

2) Found a blog on how to create a stepped layout

3) Showing advanced editor and setting the parameter to print...

Well, I ran the wizard. It produced the exact report that I was trying to create.

I then found some blogs on how to create a stepped layout rather than...

Jamey,

I finally got it to work. In running the wizard, it produced a report that had the group row. I put the formula in that you suggested and...

jamey8420 (1/21/2011)

---

This is what you are trying to duplicate:

group 3 footer ="Total Products sold by " & {employeename} & "is: " & count(products_sold),employeename")

you could do something like this:

="Total Products...

Hi,

If I need to create another table I can. But that, to me, defeats the purpose of having a report building product.

It is not easier, I don't believe, to...