The last step of copying the files between the 'old' folder and the 'new' folder is what made the DTS Editor come alive and work for me. The funny thing is, this was actually working a few days ago in sql server , until I had the misfortune to install VB6 on my x64 machine. Now its not working in either or R2. Excellent information.
Thank you. However, I followed the instructions to the letter. I think it has something to do with the fact that SQL Server is not supported on Windows 7 of any flavor. What a shame. So I must resort to DTS The files are consistently formatted as noted by another poster in SqlServerCentral. That said, onward It seems to me that those other products are Microsoft's also. Their export facilities even produce the type of CSV I am trying to process. An example SSIS will choke on the 3rd column ", Any human can see that the data as presented is valid and consistent.
Oh well, I guess it's not important to process a data format that is used commonly around the globe by millions of people. The SQL Server gurus will will say Thank you so much for the article. It helps a lot. For sql server the backward compatibility for works fine. Salute you for this article sir. Thanks for the Post.. We come across this issue fairly frequently in our environment.. See below:. As per the instructions in the link we found we had to copy the various.
Note: Double clicking the package will not actually open it. The package needs to be right clicked and then if there are multiple revisions select the appropriate version. Should you still need to continue to use the DTS packages I have discussed how this can be done in both bit and bit SQL environments. Log in or register to rate. To ease the transition, Microsoft did ensure some backwards compatibility with the release of some packages that basically ensured full DTS support — including the Designer component — in SQL Server Management Studio That said, if you have SSMS installed, all you need to do to make DTS work is to download and install the following packages from these components:.
Installation of this product failed because it is not supported on this operating system. For information on supported configurations, see the product documentation. If everything is true, you should be good to go: reboot your machine, launch SSMS and check out if the DTS Designer is working properly as it should.
November 30, November 30,
0コメント