 | |
SSIS Woes - Jobs
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#31
 
| |||
| |||
|
Re: SSIS Woes - Jobs -
04-21-2008
, 11:55 AM
|
Hi Jeremy, From the error message, it looks as if the SSIS components haven't installed correctly on the server. *I would try re-installing SSIS. Do you have BIDS installed on the server? *You could try running it through BIDS on the server using remote desktop. Good luck! J |
run it via BDIS. But, the package needs to be executed weekly on
Sundays. Though, I believe I found a work-around.
First off, SSIS was NOT installed on that machine. Which really
confused me because how am I able to create and run SSIS packages
using BDIS if it is not installed? Anyway, it turns out that they
didn't want extra components running on this machine. So, I'm using
another machine on the network that does have SSIS installed on it.
I created an SSIS package using the Import/Export wizard from
Management Studio. The package ran fine and subsequently created the
SSIS package. When I tried to scheduled the SSIS package as a job, I
was getting errors.
Next, I tried running DTEXEC and got an error. This was the default 64-
bit DTEXEC. I "cd" to the 32-bit DTEXEC and ran the .dtsx package
using the 32-bit DTEXEC and it worked. So, I set up a .bat file and
set up a scheduled task to run the .bat file on Sundays.
Not how I wanted it to work, but it works nonetheless.
Thanks for everyone's help.
Jeremy
#32
| |||
| |||
|
|
Hi Jeremy, From the error message, it looks as if the SSIS components haven't installed correctly on the server. *I would try re-installing SSIS. Do you have BIDS installed on the server? *You could try running it through BIDS on the server using remote desktop. Good luck! J |
run it via BDIS. But, the package needs to be executed weekly on
Sundays. Though, I believe I found a work-around.
First off, SSIS was NOT installed on that machine. Which really
confused me because how am I able to create and run SSIS packages
using BDIS if it is not installed? Anyway, it turns out that they
didn't want extra components running on this machine. So, I'm using
another machine on the network that does have SSIS installed on it.
I created an SSIS package using the Import/Export wizard from
Management Studio. The package ran fine and subsequently created the
SSIS package. When I tried to scheduled the SSIS package as a job, I
was getting errors.
Next, I tried running DTEXEC and got an error. This was the default 64-
bit DTEXEC. I "cd" to the 32-bit DTEXEC and ran the .dtsx package
using the 32-bit DTEXEC and it worked. So, I set up a .bat file and
set up a scheduled task to run the .bat file on Sundays.
Not how I wanted it to work, but it works nonetheless.
Thanks for everyone's help.
Jeremy
#33
| |||
| |||
|
|
Hi Jeremy, From the error message, it looks as if the SSIS components haven't installed correctly on the server. *I would try re-installing SSIS. Do you have BIDS installed on the server? *You could try running it through BIDS on the server using remote desktop. Good luck! J |
run it via BDIS. But, the package needs to be executed weekly on
Sundays. Though, I believe I found a work-around.
First off, SSIS was NOT installed on that machine. Which really
confused me because how am I able to create and run SSIS packages
using BDIS if it is not installed? Anyway, it turns out that they
didn't want extra components running on this machine. So, I'm using
another machine on the network that does have SSIS installed on it.
I created an SSIS package using the Import/Export wizard from
Management Studio. The package ran fine and subsequently created the
SSIS package. When I tried to scheduled the SSIS package as a job, I
was getting errors.
Next, I tried running DTEXEC and got an error. This was the default 64-
bit DTEXEC. I "cd" to the 32-bit DTEXEC and ran the .dtsx package
using the 32-bit DTEXEC and it worked. So, I set up a .bat file and
set up a scheduled task to run the .bat file on Sundays.
Not how I wanted it to work, but it works nonetheless.
Thanks for everyone's help.
Jeremy
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.