Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SSIS
- Thread starter dvimm
- Start date
I'm not clear on what you are asking - but I think the answer is no. SSIS is used to create and modify SSIS packages, not for running them. You create the package and load it somewhere, then create a job in SSMS (Management Studio) to run the package.
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
- Thread starter
- #3
Thanks SQLBill,
Hereis the issue I have . I created an Ssis package and it runs fine on my machine. It fails when I try to run on our qa server.The error I get is
System.IO.FileNotFoundException: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 8007007e.
Any ideas,
Thanks
Hereis the issue I have . I created an Ssis package and it runs fine on my machine. It fails when I try to run on our qa server.The error I get is
System.IO.FileNotFoundException: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 8007007e.
Any ideas,
Thanks
mrdenny
Programmer
- May 27, 2002
- 11,595
Uh, Bill... You do have to have SSIS installed to run SSIS packages on the server.
When you run them on your workstation you run them within the deveng enviroment. To run them on the server you have to have the SSIS service installed.
Not to mention that you can't use the maintenance plans if you don't have SSIS installed.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
When you run them on your workstation you run them within the deveng enviroment. To run them on the server you have to have the SSIS service installed.
Not to mention that you can't use the maintenance plans if you don't have SSIS installed.
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
Uhm, maybe the service is installed. We don't install any of the SQL 2005 client tools on our SQL Servers only on our desktops and all of our 2005 SQL Servers have SSIS packages that run just fine from jobs.
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
-SQLBill
The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
- Thread starter
- #6
you can install The Intergration Services component on the server only.
To check if it is installed try to connect to the Integration Service Server on the Server you are deploying your ackages to.
Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
To check if it is installed try to connect to the Integration Service Server on the Server you are deploying your ackages to.
Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
- Thread starter
- #8
- Status
Similar threads
- Locked
- Question
- Locked
- Question