sql server dts: I am trying to transfer some AS/400 data into SQL 2005 using ODBC connection
and "DataReader Source". In "DataReader Source", a SQL command has to be
specified, for example, "select a,b from tbl". I understand I have to use
"Data Conversion" to convert the default "unicode"(AS/400) to
"non-unicode"(SQL server, I prefer non-unicode in SQL server).

Everything is fine until I add a column in my source sql command, say
"select a,b,c from tbl". If I don't hit refreh button, newly add column "c"
won't show up in the output columns. If I hit refresh button, all downstream
conversion/mappings are messed up. It is so frustrating when you have lots of
columns to re-do. I noticed that when the "Refresh" button is clicked, the
"Column ID" property is automatically changed, which causes invalided mapping
for downstream component.

Is there a esay way for this or am I missing something?

Any help is very much appreciated.

---- Original message ----
[quoted text, click to view]

Hello,

Thank you for your post!

This is a quick note to let you know that I am performing research on this
issue and will get back to you as soon as possible. I appreciate your
patience.

+++++++++++++++++++++++++++
Charles Wang
Microsoft Online Partner Support
+++++++++++++++++++++++++++

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:

BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/

If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

Hello Jason,

So SSIS is metadata mad. it loves it and hates it when you change things.
This is one of the issues with Unicode v Non unicode. What will be happeing
is that when you refresh the metadat in the Source adpater to bring in the
new column the adapter will rebuild the output. It will therefore assign
new LineageIDs and this is what is used all over the place.

You will then get components downstream telling you that they have not seen
a column with this lineageID before. You simply need to go to each component
and choose to map the columns now by name and they should rebuild.

A pain I know but.


Allan

[quoted text, click to view]

Hi, Jason,
I've performed a test and reproduced your issue.
This should be an issue by design.

You may submit an online feedback to Microsoft for the improvement in
future.
http://connect.microsoft.com/site/sitehome.aspx?SiteID=68

If you have any other questions or concerns, please feel free to let me
know.

Enjoy your day!

++++++++++++++++++++++++++++++++
Charles Wang
Microsoft Online Partner Support
++++++++++++++++++++++++++++++++

PLEASE NOTE: The partner managed newsgroups are provided
to assist with break/fix issues and simple how to questions.
We also love to hear your product feedback!

Let us know what you think by posting
- from the web interface: Partner Feedback
- from your newsreader:
microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================
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, a
nd confers no rights.
======================================================

Hi,

I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.

Have a great day!

Charles Wang
Microsoft Online Developer Support