I managed to fix it within the NPOI code that creates the Excel cells. Thanks for all your help.

This is an ASP.NET MVC C# app that uses NPOI to generate reports from the SQL Server database. The proc gets the column headers and values for an Excel report....

OK, I finally got it to work. I had add the variable to the Variables list as well.

Thanks for the help!

It doesn't seem to work. I get this error:

Error: Failed to lock variable "FilePath" for read/write access with error 0xC0010001 "The variable cannot be found. This occurs when an...

An empty text file.

It appears I can't create a file using the File System task. Seems odd that you can create a directory, but not a file. Does anyone know which task I...

OK, I figured it out.

One of the type codes is 2 characters long so I had to make the new Type table's type code a char(2). Even though none...

[Lookup 1 [730]] Error: Row yielded no match during lookup.

[Lookup 1 [730]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Lookup 1" (730)" failed because error code 0xC020901E occurred,...

I checked all the type code values and they exist. I checked for nulls and empty spaces and there aren't any of those, either. I tried configuring the error output...

Yeah, I haven't been able to find a good SQL book myself. I usually just try different queries until I get what I want, but this time I was on...

Thanks for your help, Antares686. Your suggestions worked well.

BTW, do you know any good books on SQL? I think I need to read up some more on this.