Hi,
I've already converted one existing DTS process to SSIS. Where is the SSIS process locat
Technology Tips and News
Hi,
I've already converted one existing DTS process to SSIS. Where is the SSIS process locat
Hi HuaMin,
If I understand correctly, you want to convert DTS packages to SSIS packages. But you couldnt see Integration Services in the Installed Templates of BIDS.
Whats the version of your SQL? Have you installed SSIS? Please note that if we want to create a SSIS project in BIDS, we should install Integration Services at the same server. For more details about Considerations for Installing Integration Services, please
see:
https://msdn.microsoft.com/en-us/library/ms143731(v=sql.105).aspx
Besides, if your SSIS version is SQL 2012 or later, the best approach is to re-design the packages in SSIS 2012 directly if it is feasible. Because
most of the DTS features are discontinued and also you will have to clean up all errors that you are going to get after migration. Otherwise you need to migrate it first to 2008R2 and then 2012 version. If your SSIS version is SQL 2008R2 or previous, we
can refer to the following documents to achieve the goal:
Migrate DTS packages to SSIS
(SSIS2008R2)
Support of DTS packages in 2008 R2
Known DTS Package Migration Issues
Thanks,
Katherine Xiong
If you have any feedback on our support, please click here.
did you save that as filesystem file or as ssis package..
did you query msdb tables..
msdb has bunch of tables that store ssiss packages
select * from msdb.dbo.sysssispackages
https://msdn.microsoft.com/en-us/library/ms181582(v=sql.105).aspx
if not that, there should some other dts\ssis related tables, did you look into them?
Thanks.
Yes, I can select from that table. How to open the relevant SSIS process, as I've already converted it?
Hi HuaMin,
Please connect to Integration Services via SQL Server Management Studio, find the package under Stored Packages--MSDB folder. Then right-click the package to select 'Export Packgae' option, export the packge to File System. And then use BIDS to open and edit the package via 'Add Existing Package' option.
The following screenshot is for your reference:
Thanks,
Katherine Xiong
If you have any feedback on our support, please click here.
I'm using Sql 200