I am working on an ETL package which reads the data from text file, validates the data and puts it in relevant tables of the DB.
It was working fine until recently I had to make some changes in it. When run the package on local environment, everything worked fine.
When I uploaded the package on server and started testing it, it gave me error. I am passing information like ConnectionString, filepath through user variables. The package is executed by a windows service on server which passes these parameters to the package.
I double checked to see if the values in config file of the windows service are correct but unable to find what is wrong.
Can any one please give me a hint on this?
View Complete Post