question

SahaSaha-5270 avatar image
0 Votes"
SahaSaha-5270 asked ZoeHui-MSFT commented

Upgrade wizard error when converting dtsx packages from 2008r2 to 2016

Error 0xc0047062: Import x data to Database: CS0234 - The type or namespace name 'Dts' does not exist in the namespace 'Microsoft.SqlServer' (are you missing an assembly reference?), BufferWrapper.cs, 10, 27

Please advice how I can correct this error


sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @SahaSaha-5270,

  1. In Solution Explorer, right-click on References and select "Add Reference".

  2. Make sure the .NET tab is the current tab.

  3. Search for DTS

  4. Select it and click OK.

101566-screenshot-2021-06-02-143733.jpg

More details you may refer: error-dts-does-not-exist-in-the-namespace-microsoftsqlserver

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October



· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

If you have any updates, don't forget to tell us.

0 Votes 0 ·

@Zoehui-MSFT
Where do I add the reference?
102205-referenceinsoln.jpg


0 Votes 0 ·
referenceinsoln.jpg (52.3 KiB)

You may open SSIS Script Task Editor---edit script and then you will see the reference.

0 Votes 0 ·