Re: SSIS as part of scheduled job fails

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
no
rights.
======================================================



--------------------
Thread-Topic: SSIS as part of scheduled job fails
thread-index: AcZvr3azlP0jylIXRiCmJuIMm88YAQ==
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>
Subject: Re: SSIS as part of scheduled job fails
Date: Thu, 4 May 2006 12:18:02 -0700
Lines: 166
Message-ID:
<8AC394ED-6711-4D3F-82EB-2C19F4460F0E@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:65685
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.sqlserver.dts

Can't even open the package. Deloyed to SQL store. Get the
following
when
I
click on the MSDB folder:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request.
(Microsoft.SqlServer.SmoEnum)

For help, click:


http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20
47
6

------------------------------
ADDITIONAL INFORMATION:

Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native
Client)

------------------------------

Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native
Client)

------------------------------
BUTTONS:

OK
------------------------------







"Matt Yeager" wrote:

If you use the SQL 2005 Management Studio to connect to
your
2005
server
(connect to Integration Services, not Database Engine), can
you
find
your


.

Loading