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 |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2008-02-20 : 06:12:00
|
| Hi, I am new to SQL 2005 and to SSIS Packages so please forgive the silly question.I just right-clicked on my database and chose ALLTASKS\Import Data.I selected my flat file and went through the rest of the wizard.I saved the package when prompted so I can run it later with SQL server Agent.But now I can't find where the Package is so that I can run it.In SQL2k I could just look under the DTS folder and find my package.thanksICW |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-20 : 06:22:57
|
| Which option did you choose SQL Server /Filesystem. By default it will be SQL Server in which case you can find the package by connecting to Integration Services engine from SSMS and looking inside StredPackages->MSDB folder |
 |
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2008-02-20 : 07:10:47
|
| Thanks for your quick reply.Yes i Have figured out that its in the MSDB database.I have launched the SSIS integration tool and am getting an error everytime I try to open the MSDB folder under the store packages folder.Complaining that it can't find the server.I have found and edited the config file (see below)because I have a named instance. But it still gives me the same error.Config file<?xml version="1.0" encoding="utf-8"?><DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown> <TopLevelFolders> <Folder xsi:type="SqlServerFolder"> <Name>MSDB</Name> <ServerName>ICW1\icwsql2005</ServerName> </Folder> <Folder xsi:type="FileSystemFolder"> <Name>File System</Name> <StorePath>..\Packages</StorePath> </Folder> </TopLevelFolders> </DtsServiceConfiguration>The error says "The SQL server specified in SSIS service configuration is not present or is not available"However I know my instance name is correct as I use this to connect to my database engine through the management studio. |
|
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2008-02-20 : 07:38:20
|
| It worked after I stopped and restarted the SSIS service and the sql server agent |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2009-02-19 : 23:45:12
|
| Thanks for this. |
|
|
|
|
|
|
Where is my SSIS package stored