The was great into.!!!!!!!!!

Need a little though. I have doing same thing except I need to add a where clause to SQL in the Excute SQL Task!

How does that work?

I tried:

Select AdjustSQLCode from _ut_PCA_Client_Import_Format_Cycle_Adjust

WHERE FormatID = @FormatID

Mapping Paramter:

Variable Name = User::FormatID Direction = input DataType = Long Parameter Name = 0