Re: SSIS as part of scheduled job fails

Did you recieve the output file i sent you?

"Vincent Xu [MSFT]" wrote:

Hi Joe,

Regarding the SSIS logging, you can refer to :

- Managing and Deploying SQL Server Integration Services: Microsoft TechNet
SQL Server TechCenter
http://www.microsoft.com/technet/prodtechnol/sql/2005/mgngssis.mspx

The thing I ask for is the section:

About the exec subsystem command and output information

in KB 918760

Thanks.

Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================



--------------------
Thread-Topic: SSIS as part of scheduled job fails
thread-index: AcZ18K83wWc911vSQqe7ws1UI56MJA==
X-WBNR-Posting-Host: 216.39.152.73
From: =?Utf-8?B?Sm9lIFMu?= <joecrew@xxxxxxxxxxxxxx>
References: <45738B3D-3021-4E7C-A81F-155792D04CC5@xxxxxxxxxxxxx>
<OinSNZrbGHA.1856@xxxxxxxxxxxxxxxxxxxx>
<902401D3-AD5D-488B-9D8F-CB15374B74C5@xxxxxxxxxxxxx>
<OemA8B4bGHA.1272@xxxxxxxxxxxxxxxxxxxx>
<36EBCCC7-B24E-4AF9-AE8A-5AC394795A02@xxxxxxxxxxxxx>
<uLtVXS6bGHA.3956@xxxxxxxxxxxxxxxxxxxx>
<8AC394ED-6711-4D3F-82EB-2C19F4460F0E@xxxxxxxxxxxxx>
<DL2zzKncGHA.4776@xxxxxxxxxxxxxxxxxxxxx>
<67A1013E-D23C-4216-8FFC-70A8B4CF5EC7@xxxxxxxxxxxxx>
<IUjxxWycGHA.220@xxxxxxxxxxxxxxxxxxxxx>
<VF##BuMdGHA.5432@xxxxxxxxxxxxxxxxxxxxx>
<2ifvT9MdGHA.3900@xxxxxxxxxxxxxxxxxxxxx>
Subject: Re: SSIS as part of scheduled job fails
Date: Fri, 12 May 2006 11:20:01 -0700
Lines: 306
Message-ID: <449023AA-1C85-42DB-A7A8-8924E97D8A99@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.sqlserver.dts
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:65853
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.sqlserver.dts

I am having a hard time understanding how to set up the logging. Do you
have
any more detailed instruction on how to configure the logging for the
SSIS
step or do I need to run it outside of a job with a different utility?

"Vincent Xu [MSFT]" wrote:

Hi Joe,

Regarding the last part of the KB 918760, what's the exact error log at
console?

Please let me knwo in detail.

Thanks.


Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader
so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no
rights.
======================================================



--------------------
X-Tomcat-ID: 108074838
References: <45738B3D-3021-4E7C-A81F-155792D04CC5@xxxxxxxxxxxxx>
<OinSNZrbGHA.1856@xxxxxxxxxxxxxxxxxxxx>
<902401D3-AD5D-488B-9D8F-CB15374B74C5@xxxxxxxxxxxxx>
<OemA8B4bGHA.1272@xxxxxxxxxxxxxxxxxxxx>
<36EBCCC7-B24E-4AF9-AE8A-5AC394795A02@xxxxxxxxxxxxx>
<uLtVXS6bGHA.3956@xxxxxxxxxxxxxxxxxxxx>
<8AC394ED-6711-4D3F-82EB-2C19F4460F0E@xxxxxxxxxxxxx>
<DL2zzKncGHA.4776@xxxxxxxxxxxxxxxxxxxxx>
<67A1013E-D23C-4216-8FFC-70A8B4CF5EC7@xxxxxxxxxxxxx>
<IUjxxWycGHA.220@xxxxxxxxxxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
From: v-xuwen@xxxxxxxxxxxxxxxxxxxx (Vincent Xu [MSFT])
Organization: Microsoft
Date: Thu, 11 May 2006 07:21:13 GMT
Subject: Re: SSIS as part of scheduled job fails
X-Tomcat-NG: microsoft.public.sqlserver.dts
Message-ID: <VF##BuMdGHA.5432@xxxxxxxxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.sqlserver.dts
Lines: 360
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:65813
NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122

Hi

Thanks for the mail reply.

I'll try to research on it.

Best regards,

Vincent Xu
Microsoft Online Partner Support
======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader
so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no
rights.
======================================================



--------------------
X-Tomcat-ID: 76633940
References: <45738B3D-3021-4E7C-A81F-155792D04CC5@xxxxxxxxxxxxx>
<OinSNZrbGHA.1856@xxxxxxxxxxxxxxxxxxxx>
<902401D3-AD5D-488B-9D8F-CB15374B74C5@xxxxxxxxxxxxx>
<OemA8B4bGHA.1272@xxxxxxxxxxxxxxxxxxxx>
<36EBCCC7-B24E-4AF9-AE8A-5AC394795A02@xxxxxxxxxxxxx>
<uLtVXS6bGHA.3956@xxxxxxxxxxxxxxxxxxxx>
<8AC394ED-6711-4D3F-82EB-2C19F4460F0E@xxxxxxxxxxxxx>
<DL2zzKncGHA.4776@xxxxxxxxxxxxxxxxxxxxx>
<67A1013E-D23C-4216-8FFC-70A8B4CF5EC7@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
From: v-xuwen@xxxxxxxxxxxxxxxxxxxx (Vincent Xu [MSFT])
Organization: Microsoft
Date: Tue, 09 May 2006 05:01:47 GMT
Subject: Re: SSIS as part of scheduled job fails
X-Tomcat-NG: microsoft.public.sqlserver.dts
Message-ID: <IUjxxWycGHA.220@xxxxxxxxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.sqlserver.dts
Lines: 298
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:65752
NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182

Hi Joe,

Sorry to hear that.

So far, you can check following article:

An SSIS package does not run when you call the SSIS package from a
SQL
Server Agent job step
http://support.microsoft.com/kb/918760

Let me know the results.

Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your
newsreader
so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no
rights.
======================================================



--------------------
Thread-Topic: SSIS as part of scheduled job fails
thread-index: AcZy50Ndi+AUTpU+QSqDNIi08rtLIQ==
X-WBNR-Posting-Host: 216.39.152.73
From: =?Utf-8?B?Sm9lIFMu?= <joecrew@xxxxxxxxxxxxxx>
References: <45738B3D-3021-4E7C-A81F-155792D04CC5@xxxxxxxxxxxxx>
<OinSNZrbGHA.1856@xxxxxxxxxxxxxxxxxxxx>
<902401D3-AD5D-488B-9D8F-CB15374B74C5@xxxxxxxxxxxxx>
<OemA8B4bGHA.1272@xxxxxxxxxxxxxxxxxxxx>
<36EBCCC7-B24E-4AF9-AE8A-5AC394795A02@xxxxxxxxxxxxx>
<uLtVXS6bGHA.3956@xxxxxxxxxxxxxxxxxxxx>
<8AC394ED-6711-4D3F-82EB-2C19F4460F0E@xxxxxxxxxxxxx>
<DL2zzKncGHA.4776@xxxxxxxxxxxxxxxxxxxxx>
Subject: Re: SSIS as part of scheduled job fails
Date: Mon, 8 May 2006 14:35:02 -0700
Lines: 270
Message-ID: <67A1013E-D23C-4216-8FFC-70A8B4CF5EC7@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.sqlserver.dts
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:65746
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.sqlserver.dts

No solution as of yet. Tried using Proxy, tried changing the job
to a
cmd
step, but everything still fails.

To recap enviroment and desired solution:

WIn 2003 x64 server with SQL 2000 sp4 as default instance and SQL
2005
std
x64 as named instance. All options installed with SQL 2005
(Reporting,
Integration, Analysis, etc). I want to import three tables from a
Access
2003
database on a network share into a database on the SQL 2005
instance.
Everything works when done maually, but not if added as part of a
scheduled
job.

"Vincent Xu [MSFT]" wrote:

Hi Joe,

I posted your issue in our internal forum and now is waiting
for
the
response.

I noticed that you are currently working with Matt and I'd like
to
know
how
is everything going now?


Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your
newsreader
so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers
.

Relevant Pages

  • Re: Why do so many posts go unanswered after many weeks?
    ... You may want Integration Services group. ... If your posts continue to go unanswered then I still think you may have an identity problem with your MSDN posting alias. ... This is, after all, the SSIS forum, it is an SSIS issue, and not a ...
    (microsoft.public.sqlserver.dts)
  • RE: Filter data in OLE DB Source
    ... I do understand that SSIS has a good many of new features and it is hard to ... know them if we do not have experiences of using them before. ... free to have new posts here if you encounter any other issues in future. ...
    (microsoft.public.sqlserver.dts)
  • Re: Lookup Transformation in SSIS
    ... Sorry about the incomplete reference to the IsSorted and ... SortKeyPosition properties - I didn't have SSIS with me at the time of ... posting to double check! ...
    (microsoft.public.sqlserver.dts)
Loading