How to import .dts file into sql server 2000

Subscribe to SQLTeam. Home Weblogs Forums. Posted - : How about setting up the package with a fixed file name for the Excel file e. Thanks, this is a great lead. The code you have now to set up the transformations looks good. As long as the file format is the same it doesn't matter.

HTH Jasper Smith. How should I resolve this? Deleting the existing packages is not at all an option. Because they have several versions of the package which they would revert back if there are any issues with the new version. However, I would save previous versions of the package to a source control system, rather than relying on SQL Server versioning. There are utilities in the market that do that for you but what if you have to make this import a part of your install?

If you have such a requirement, then you can save your DTS packages as files and then write up a simple VB Script and call it through cscript to load up the packages. You can put this process into your install shield code to give a better end user experience.

And here is the code for the ImportPackages. You must be logged in to reply to this topic. Login to reply. I believe it can actually natively import Excel as well. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 11 years, 8 months ago. Active 11 years, 8 months ago. Viewed 2k times. Say the source data comes in excel format, below is how I import the data.

Could the community advise, please? Improve this question. Stan Stan Add a comment. Active Oldest Votes.