Sql server import dts file

To my suprise, there wasn't much official documentation on the subject, and didn't seem to be any wizard to help accomplish the goal, so its time to get creative If that's not ideal to you There are special considerations and details to read about here. So in the short term if you are not prepared to upgrade all your DTS packages to SSIS, the question is how to move your DTS package and leave them in the old legacy format and continue to run them, in case that you may not have time to immediately upgrade your packages and test them out.

You can save each package one by one from to Save to structured storage files, and copy those files to SQL , and import into Legacy Packages one at a time. I didn't have time to investigate, but its worth mentioning there could be some complications with this method. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback?

Important To learn more, see limitations and known issues for loading data to or from Excel files. Note The ACE provider formerly the Jet provider that connects to Excel data sources is intended for interactive client-side use. Tip For best results with data importing tools, save sheets that contain only the column headers and the rows of data.

Submit and view feedback for This product This page. View all page feedback. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Later you can reuse the package and extend it by using SSIS Designer to add tasks, transformations, and event-driven logic.

Start the wizard. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful?

Please rate your experience Yes No. Any additional feedback?