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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2010-04-27 : 09:54:17
|
| Hi Friends,Few questions on DTS and Integration ServicesQ1)Why SSIS service is only one instance ? why can't we have multiple instance's for SSIS as well like Database instance,SSAS & SSRS?Q2)How to call a dts package from stored procedure which is stored in SQL Server Q3)How to call a dts packages from a stored procedure which is stored in File SystemQ4)Can i store my dts package as it is(i.e with .dts extension not .dtsx package) under SQL 2008 instance?I tried this while connecting to SQL 2005 instance Integration Services --> Expand MSDB node and tried to import the dts package with .dts extension only.But i ended up with 2 Errors. I thought that whether am pointing to correct running SQL 2005 instance into which am trying to import the dts package .I went to services.msc and checked whether the SQL 2005 instance is running or not and also SQL Server integration Serveices is running or not. Both the things are running...My doubt is whether storing the ssis package in File system and use "dtsrun.exe" and wrap it up in a stored procedure and call it in SQL 2008 or else do we have other options thru which we can save the dts as it is in SQL 2008 instance and call thru stored procedure or any means????Any suggestions would be greatly appreciated!!!Error 1:TITLE: Import Package------------------------------The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement that was issued has failed.-----------------------------ADDITIONAL INFORMATION:The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement that was issued has failed.------------------------------BUTTONS:OK------------------------------Error :2 TITLE: Microsoft SQL Server Management Studio------------------------------Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476------------------------------ADDITIONAL INFORMATION:The SQL server 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 2005 Books Online.Login timeout expiredAn error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.Named Pipes Provider: Could not open a connection to SQL Server [2]. (MsDtsSrvr)------------------------------Login timeout expiredAn error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.Named Pipes Provider: Could not open a connection to SQL Server [2]. (Microsoft SQL Native Client)-----------------------------BUTTONS:OK------------------------------ |
|
|
|
|
|
DTS and SSIS