Click “Edit Script” to open the project in VS.Alternatively, you could take following steps to work around the issue: Now the issue has been fixed in 16.10, please upgrade to 16.10 to solve the issue. This is actually a regression caused by VS 16.9. Here are the download links: Power Query Source for SQL Server 20, Microsoft Oracle Connector for SQL Server 2019 Common IssuesĬurrently you may still hit the 'Could not find a part of the path' error when compiling script task/component. To continue using these two components, please manually download and install them by yourselves. IMPORTANT: since version 3.3, Power Query Source for SQL Server 2017 and Microsoft Oracle Connector for SQL Server 2019 have been excluded from the installation of this product. Visit for the latest information, tips, news, and announcements about SSIS directly from the product team.
Currently the supported target server version starts from SQL Server 2012 up to 2019. This project may be used for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing.
