VPR.exe - Data source name not found

More
5 years 3 months ago #18031 by mspencer
Running into the following issue when running the Visual Importer command line tool (see attached).
OS: Server 2003 and Server 2012
Visual Importer Version: 9.2.2.3 (Server 2003 is x86 and Server 2012 is x64 of Visual Importer)

I can run the same package from the Visual Importer GUI and the job completes successfully. We've also just upgraded from version 8.4.4.5... any info would be greatly appreciated. Thanks!

Attachments:

Please Log in or Create an account to join the conversation.

More
5 years 3 months ago #18033 by admin
We are looking at it now

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
5 years 3 months ago #18035 by mspencer
Also seeing the same DS name not found message when running vpr.exe from a Windows 7 machine (Visual Importer x64, 9.2.2.3).

Please Log in or Create an account to join the conversation.

More
5 years 3 months ago #18036 by mspencer
Bit more info on the repository... repository for Visual Importer 8.4.4.5 (SQL Server 2008 R2) upgraded to 9.2.2.3 (SQL Server 2016). Account used to connect to the new repository is db_owner on the repository database. We also have a few users that are able to connect and run packages from the GUI but are unsuccessful from the command line tool. Let me know if you need anything additional. Thanks!

Please Log in or Create an account to join the conversation.

More
5 years 3 months ago #18041 by Peter.Jonson
Can you try latest version and let us know if it works

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
5 years 3 months ago #18066 by mspencer
That did the trick... version 9.2.2.4 resolved the VPR.exe errors we were seeing. Thank you again for the quick turnaround!

Please Log in or Create an account to join the conversation.