AnsweredAssumed Answered

Catalog name piarchive is invalid

Question asked by tajammul on Mar 30, 2020

Hi Friends,



I have set up a query to read the data from Pi Server into SQL Server and the query works fine. However, when I save this query as a SQL Server Integration Service Package and run the same, it gives an error where the description says Catalog name piarchive is invalid.


I am surprised, why the same query runs fine as a stand-alone query and transfers data to the SQL Server table, but when I save this query as a DTS package it gives an error.


Any help in this regard is appreciated.