FIXED!! Applied SP3 and registered the dlls for SSIS all is well, thanks.

Yes It is still set this way and...

I did this previous to applying sp2 I think i kept it that way. I'll verify it's still set that way tomorrow.

SQLRNNR (6/7/2011)

---

SSMS - is that when you are trying to open the package from SSMS on the server or on your workstation? If workstation, what version of SSMS are...

OK Reapplied SP2 to Integration Services but I still get the exact same issue.

When connecting to SSIS from Management Studio I get error loading type library dll

Opening or creating...

working on it now too bad it takes FOREVER to upload to the site where this server is, probably going to take 5 hours to upload that 350 meg patch....

This is the error

Could not load package "C:\Folder\MyPackage.dtsx" because of error 0xC0010014.

Description: The package failed to load due to error 0xC0010014 "One...

No did not reapply SP2, I figured it was necessary, but we are not allowed to install anything. We have to get the powers that be to do it....

oops meant to put this in sql 2005 ssis forum sorry

I resolved my first two issues, one with the extra names being appended to my filename. I also solved the issue with the Location Parameter not being set on...

Koen Verbeeck (5/30/2011)

---

Regarding issue #1: your code appends data to the variable for every iteration. So what did you expect?

Store the fixed part in another variable, and create each time...

Ok thanks guys I'll try lee's idea

Thanks that worked great, The workers were not seperated by a carriage return like I had hoped. I thought the + char(10)

like you had it would work but my results...

I got it to work, by changing my last query to select form the under lying table directly and not the view. I think the real issue is that...

I can't index the view because it uses left joins.

Yes the underlying table has indexes, they are not fragmented.

Perhaps I'll try querying the underlying table directly and see what...