Error: DTS_E_PRODUCTLEVELTOLOW when running test.

Jan 26, 2009 at 7:04 PM
Edited Jan 26, 2009 at 7:05 PM
This is strange.  I'm receiving the above error in ssisUnit (which I know is coming from DTS, not ssisUnit itself) on every task within the packge I'm trying to test.

None of the tasks are Enterprise level features either, just simple Lookup and Execute SQL tasks.  Naturally the task runs fine within BIDS, just not in ssisUnit for me.

Anybody have any suggestions?
Jan 26, 2009 at 7:45 PM
Figures, once I type the problem out things become clearer.

I have BIDS installed on the development machine, and SSIS is installed on the SQL server hosting the DB, but I need SSIS installed on the machine running ssisUnit for everything to work.  BIDS will work just fine without SSIS installed locally.