Image

Imagexterminal wrote in Imagesqlserver

Creating a temporary staging table in SSIS

I'm trying to create a temporary staging table in SSIS, and I assume I'm going about it the wrong way. I'm importing from a flat file into what I want to be a temp table I can then access from the next step in the package, but none of the destinations seem to have that functionality; the only temporary destinations I can find are DataReader and Recordset, and I can't figure out, once I set them as a destination in step A, how to then access them in step B. Not finding any relevant info on the web, maybe I'm using the wrong search terms.

Anyone know how to do this? Thanks.