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 |
|
Oliviaf2012
Starting Member
16 Posts |
 Posted - 2012-10-10 : 08:01:16
|
| I am trying to run an SSIS package as part of a scheduled job but - it runs for 1 second and returns no data. The SSIS package run in Debug mode generates the results I need. |
|
|
Brittney10
Posting Yak Master
154 Posts |
Posted - 2012-10-10 : 11:38:59
|
| Need more information. Is there an error being thrown?... Are you trying to process a file?...Are you using a Config file to run the pkg in the SQL Job?... |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-11 : 00:27:32
|
| maybe the connection manager values are different while executing from job. have you set configurations for them?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Oliviaf2012
Starting Member
16 Posts |
Posted - 2012-10-11 : 04:07:17
|
| I am just using an SSIS package (no extra security) and two connection manager data sources. There is no error being thrown it says the job ran sucessfully in 1 second (it shouldake a few minutes) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-11 : 15:39:09
|
quote:
Originally posted by Oliviaf2012
I am just using an SSIS package (no extra security) and two connection manager data sources. There is no error being thrown it says the job ran sucessfully in 1 second (it shouldake a few minutes)
is datasources same when running from job also? or do you want it to pint to different source while executing from job?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Oliviaf2012
Starting Member
16 Posts |
Posted - 2012-10-12 : 05:53:04
|
| No everything is the same whether I run it from within SSIS or from the job |
|
|
|
|
|
|
Running a package ina SQL Job