Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2014-02-11 : 06:17:04
|
| Hi all,I have used the SQL Import and Export Wizard to create an SSIS package and saved it SQL Server.The name of the server is MyServerThe name of my SQL server instance is MyServer\Instance1When I connect to Integration services on MyServer I cannot see the SSIS package under any of the folders. It is not under the Stored Packages, File System, MSDB, Data Collector or Maintenance Plans folders.However I can see the package in the sysssispackages table in the MSDB database. I can also create a job that calls this SSIS packages to be run.But why can't I see the package in Management Studio?Am I looking in the wrong place? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-02-11 : 23:58:29
|
| It depends on what options you used. If its SQLServer it should be under MSDB while connecting to Integration Services instance in SSMS------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
ranvir_2k
Posting Yak Master
180 Posts |
Posted - 2014-02-12 : 10:12:46
|
| It's fine now, it was because I had two instances of SQL Server installed on the same server. Integration services can only be used for one Instance at a time.I had to change the MsDtsSrvr.ini file to point to the correct instance. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-02-13 : 08:05:15
|
quote:
Originally posted by ranvir_2k
It's fine now, it was because I had two instances of SQL Server installed on the same server. Integration services can only be used for one Instance at a time.I had to change the MsDtsSrvr.ini file to point to the correct instance.
yep..thats true------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Cannot see SSIS packages in Management Studio.