The Calgary-based company decided to relocate the terminal in part because of concern for beluga whales near the site, which was to include storage tanks and a marine port for loading oil onto ships.
"This decision is the result of the recommended change in status of the Beluga whales to endangered and ongoing discussions we have had with communities and key stakeholders," TransCanada's president and chief executive Russ Girling said in a statement.
TransCanada (TSX:TRP) is looking for potential alternatives in the province.
The company also said the proposed $12-billion project — a 4,600-kilometre pipeline from Hardisty, Alta., to the Atlantic — will be in service by 2020, about two years later than the previous target of late 2018.
The pipeline has faced opposition, with activists citing concerns that oil spills could affect water quality in the province and that the project will facilitate expansion of the tar sands.
In January, about a dozen protesters staged a rally in Halifax as the National Energy Board met with groups during closed-door meetings to discuss the project.
Keith Stewart, the head of the energy campaign at Greenpeace Canada, said he applauds the cancellation of the Cacouna terminal, but is still opposed to the project as a whole.
"This project represents all risk no reward for places likes Quebec," Stewart said. "The pipeline's going to go through Quebec, there's not a lot of job (creation) there, it's creating enormous ecological risks, and it's also going to make it impossible for Canada to take serious action on climate change."
TransCanada said its revised proposal responds to community feedback by speeding up development of an emergency response plan, which normally wouldn't be prepared until after a project receives regulatory approval.
It still expects to link the pipeline to two refineries in Quebec and one in New Brunswick.
The company suspended construction of the Cacouna port last fall, after a Quebec Superior Court judge issued an injunction against seismic work in the St. Lawrence estuary to protect threatened beluga calving grounds.
Late last year, Quebec Premier Philippe Couillard suggested TransCanada should consider a new location for its port given that the beluga whale is a candidate to become an endangered species.
Belugas have seen their numbers dwindle to about 1,000, according to a federal wildlife committee's report.
Also on HuffPost: