Search

SSIS Web Service Task referencing SP2010 lists.asmx crashes BIDS 2008 by David C. Hill

Active

2
0
Sign in
 to vote
Type: Bug
ID: 776616
Opened: 1/15/2013 9:17:55 AM
Access Restriction: Public
0
Workaround(s)
1
User(s) can reproduce this bug
Environment:
SQL Server 2008 R2 10.50.1617.0
SSIS Version 10.50.1600.1
Visual Studio BIDS 2008 9.0.30729.4462 QFE
Windows Server 2008
SharePoint 2010 14.0.6117.5002

Creating and configuring an SSIS project with Web Service Task associated with SP2010 Lists.asmx in VS2008 BIDS will crash BIDS. Tried on 2 different SharePoint farms with different installations of VS2008 BIDS with same results.
Details (expand)

Product Language

English

Version

SQL Server 2008 R2

Category

Integration Services (DTS)

Operating System

Windows Server 2008 R2 Enterprise

Operating System Language

English

Steps to Reproduce

Steps to reproduce:
1. Create blank SSIS project in BIDS
2. Add Web Service Task to Control Flow Panel.
3. Configure Web Service Task General Tab to connect to dev SP2010 server lists.asmx: http://server/_vti_bin/lists.asmx
4. Download WSDL from lists.asmx to utilize in configuration
5. Save the project (because it's about to crash.)
6. Switch to Input tab, click in Service input box to display dropdown. See "Lists" displayed for services available.
7. Click "Lists" to crash BIDS.

Actual Results

VS BIDS will crash with the following error information:

Problem signature:
Problem Event Name:    CLR20r3
Problem Signature 01:    devenv.exe
Problem Signature 02:    9.0.30729.1
Problem Signature 03:    488f2b50
Problem Signature 04:    Microsoft.DataWarehouse.VsIntegration
Problem Signature 05:    10.0.0.0
Problem Signature 06:    4bb67700
Problem Signature 07:    41e
Problem Signature 08:    71
Problem Signature 09:    Exception
OS Version:    6.1.7600.2.0.0.274.10
Locale ID:    1033

Expected Results

Expect to be able to use SSIS to call into lists.asmx web service.

Platform

X64

Virtualization

 
File Attachments
File Name Submitted By Submitted On File Size  
bidscrash1.png David C. Hill 1/15/2013 54 KB
bidscrash2.png David C. Hill 1/15/2013 9 KB
bidscrash3.png David C. Hill 1/15/2013 11 KB
bidscrash4.png David C. Hill 1/15/2013 9 KB
bidscrash5.png David C. Hill 1/15/2013 36 KB
Sign in to post a comment.
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement