Thanks to the help on this board, I was able to get my report working on my local IIS server. Now, I'm struggling trying to incorporate parameters into my...

Gift Peddie (11/20/2009)

---

I think you can use the local mode because if your reports are not SSRS features dependent then you can use the Visual Studio ReportViewer control. Check...

Okay, I'll play around with a sample report in local mode and see if the route you suggested is appropriate. I'll likely have more questions along the way.

Thanks so...

Gift Peddie (11/20/2009)

---

Steve Irwin (11/20/2009)

---

I'm currently developing reports locally with the Report Builder application as well as in Visual Studio 2005. Unfortunately, our current server hosting plan with GoDaddy...

Erik Kutzler (10/22/2009)

---

I kind of remember hearing about this before. I believe the resolution was to uninstall/reinstall SSIS and/or Excel.

An alternative solution would be to use a Data...

Thanks Tim! I didn't realize I still had the expression coded for the Archive filename. Once I removed that and just specified the folder, the package completed successfully.

Tim,

Do you have any further thoughts and/or suggestions after looking at the .dtsx package I sent? Even if I can't get a resolution to why I'm getting the error,...

Yeah, I tried to attach a .zip file and it said "the application encountered an unexpected error."

I did just send you an e-mail though with the .dtsx file...

I'm getting an error message when trying to attach the .zip file containing my .dtsx file. Can I e-mail you the .dtsx file instead?

For testing purposes, since I know my source file had valid records, I removed the File System Task that would delete the output file if RowCount = 0. I...

I've attached a screen shot of the Control Flow.

Tim Mitchell (10/12/2009)

---

Are you using a precedence constraint between the data flow and the filesystem task? This should insure that the data is extracted from the file before the...

That worked. Thanks!

I just assumed it would involve some special syntax.

See the two tables below.  The user enters a code that gets populated in the BILLING_DETAIL table.  That code will correspond to a code in the CODES table.  So every time...

I appreciate the response but my example was more for help creating this type of trigger.  If you were to create a trigger based on my example, how would you set it...