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 |
|
dmaxj
Posting Yak Master
174 Posts |
 Posted - 2010-04-19 : 09:25:56
|
I have converted SQL 2000 DTS packages to SSIS packages for SQL 2008 and saved them to my SQL Server 2008. Next, I use Management Studio to connect to Integration Services. I see File System and MSDB under Stored Packages when expanded. What is the difference between File System and MSDB? I am able to import my new packages to File System, but I get this error when I attempt to import under MSDB:TITLE: Import Package------------------------------The SQL Server instance specified in SSIS service configuration is not present or is not available.This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic "Configuring the Integration Services Service" in Server 2008 Books Online.Login timeout expiredA network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.Named Pipes Provider: Could not open a connection to SQL Server [2]. (MsDtsSrvr)------------------------------ADDITIONAL INFORMATION:Login timeout expiredA network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.Named Pipes Provider: Could not open a connection to SQL Server [2]. (Microsoft SQL Server Native Client 10.0) I will eventually need to set the SSIS packages up to be executed with SQL Agent. Which is the best/proper place to import.Regards |
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2010-04-19 : 11:09:48
|
| I should also add that this is a clustered environment - thanks. |
 |
|
|
dmaxj
Posting Yak Master
174 Posts |
|
|
|
|
|
Importing Packages