Unspecified error from OLE DB Provider in DTS

• esserm

  Old Hand

  Points: 340

  More actions

  June 27, 2003 at 6:08 am

  #82073

  hi,

  I developed a SQL program with cursor and fetch statements with Query Analyzer. After the result was satisfying I copied the SQL statement into a DTS package. When I execute the step or the entire package I get a "Unspecified error" from the OLE DB Provider for SQL Server, but the statements are executed correctly, all changes to the table are done.

  Does anybody know what causes the error message?

  We have the latest service pack installed.

  Thanks for any help.

• June 30, 2003 at 8:00 am

  This was removed by the editor as SPAM