Re: SSIS as part of scheduled job fails

Hi Joe,

Thanks for the mail.

Some thoughts:

1.Modifed the package protection level to EncryptSensitiveWithPassword

2, Try to use Control Panel - Add/Remove Programs and removed the
workstation
components for SQL Server 2005 and then install it again.





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: 107714405
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>
<449023AA-1C85-42DB-A7A8-8924E97D8A99@xxxxxxxxxxxxx>
<5Pf$6A#dGHA.3728@xxxxxxxxxxxxxxxxxxxxx>
<4BF3D198-B5D4-4540-BA63-9ED451DD72D0@xxxxxxxxxxxxx>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
From: v-xuwen@xxxxxxxxxxxxxxxxxxxx (Vincent Xu [MSFT])
Organization: Microsoft
Date: Fri, 26 May 2006 06:57:59 GMT
Subject: Re: SSIS as part of scheduled job fails
X-Tomcat-NG: microsoft.public.sqlserver.dts
Message-ID: <x57EEHJgGHA.1740@xxxxxxxxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.sqlserver.dts
Lines: 372
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:66145
NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122

Hi Joe,

I'm sorry but I didn't receive any files from you. Woud you please send
it
again?

In the subject of the mail, please add "Issue ID:33627409 " which is your
issue ID.

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: AcZ/U6NAs4fLPzO4TlmE4rhA2fVo7A==
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>
<449023AA-1C85-42DB-A7A8-8924E97D8A99@xxxxxxxxxxxxx>
<5Pf$6A#dGHA.3728@xxxxxxxxxxxxxxxxxxxxx>
Subject: Re: SSIS as part of scheduled job fails
Date: Wed, 24 May 2006 10:01:02 -0700
Lines: 304
Message-ID: <4BF3D198-B5D4-4540-BA63-9ED451DD72D0@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:66077
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.sqlserver.dts

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: How do I install & set up RADIUS?
    ... Microsoft Online Partner Support ... Get Secure! ... When responding to posts, please "Reply to Group" via your newsreader so ...
    (microsoft.public.windows.server.general)
  • Re: Event Viewer cannont connect to remote WinXP SP2 event viewer
    ... Microsoft Online Partner Support ... Get Secure! ... When responding to posts, please "Reply to Group" via your newsreader so ...
    (microsoft.public.windowsxp.security_admin)
  • RE: NT to 2003 Upgrade problems
    ... Microsoft Online Partner Support ... Get Secure! ... When responding to posts, please "Reply to Group" via your newsreader so ...
    (microsoft.public.windows.server.migration)
  • Re: Cant install KB913670
    ... Microsoft Online Partner Support ... Get Secure! ... When responding to posts, please "Reply to Group" via your newsreader so ...
    (microsoft.public.win2000.general)
  • RE: How to use ADMT3?
    ... Microsoft Online Partner Support ... Get Secure! ... When responding to posts, please "Reply to Group" via your newsreader so ...
    (microsoft.public.windows.server.migration)