Is a numbers//tally//sequence table the same as a PIVOT table?

Thank you for the responses.

Animal Magic (7/29/2009)

---

what is the job doing?? does it move any files anywhere possibly to a drive that may be full?? i dont think it will be a problem...

An error occurred with the following error message: "Insufficient system storage. The server response was:...

Remember, my Blob is coming from 3rd party ODBC database, not from SQL Server Database.

Does this impact the data type as it comes into SSIS pipeline?

So if I create a data flow task and map the input blob column to an output text column, it will automatically convert it for me?

Error. Explicit conversion not allowed. Any other ideas?

The column of the blob is IMAGE, but the data is text data. These are account notes stored as a blob in the db.