DTS Transform Problem

#1

I am experiencing a very odd DTS problem. Below is my sample DTS code:
1. New DTS
2. Create a SQL connection
3. Create a Text destination
4. Create a Transformation to move a table from SQL to Text - no transforms
5. On the source select an existing table
6. On the text file destination - I define c:\mytest.txt
7. Populate Columns from Source - hit execute (this is when it should show
me what columns will be available) - sometimes won't map columns

Here is the problem - on some of the developers machines - it will show the
destinations columns and allow you to map the source and destination columns
as it should - but on others the destination columns do not appear and
therefore will not allow us to map them. It seems to have different results
on different machines indicating a possible service pack issue - but that's
not the case. We all have SQL2k, SP3 and our machines are same model
Dell's.

Since we can't put pictures here - I put some screen shots together at:
http://northwestservices.biz/dtsproblem/index.htm

#2

I believe you are hitting the problem brought about in SP3

http://support.microsoft.com/default...b;en-us;814113

--

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

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Joe Horton" <horj235 (AT) lni (DOT) wa.gov> wrote

Quote:

I am experiencing a very odd DTS problem. Below is my sample DTS code:
1. New DTS
2. Create a SQL connection
3. Create a Text destination
4. Create a Transformation to move a table from SQL to Text - no
transforms
5. On the source select an existing table
6. On the text file destination - I define c:\mytest.txt
7. Populate Columns from Source - hit execute (this is when it should show
me what columns will be available) - sometimes won't map columns

Here is the problem - on some of the developers machines - it will show
the
destinations columns and allow you to map the source and destination
columns
as it should - but on others the destination columns do not appear and
therefore will not allow us to map them. It seems to have different
results
on different machines indicating a possible service pack issue - but
that's
not the case. We all have SQL2k, SP3 and our machines are same model
Dell's.

Since we can't put pictures here - I put some screen shots together at:
http://northwestservices.biz/dtsproblem/index.htm

#3

THANK YOU - this has fixed our problem!

The Hot fix can be downloaded from:
http://www.microsoft.com/downloads/d...displaylang=en

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

I believe you are hitting the problem brought about in SP3

http://support.microsoft.com/default...b;en-us;814113

--

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

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Joe Horton" <horj235 (AT) lni (DOT) wa.gov> wrote in message
news:108ao351rgcik39 (AT) corp (DOT) supernews.com...
I am experiencing a very odd DTS problem. Below is my sample DTS code:
1. New DTS
2. Create a SQL connection
3. Create a Text destination
4. Create a Transformation to move a table from SQL to Text - no
transforms
5. On the source select an existing table
6. On the text file destination - I define c:\mytest.txt
7. Populate Columns from Source - hit execute (this is when it should
show
me what columns will be available) - sometimes won't map columns

Here is the problem - on some of the developers machines - it will show
the
destinations columns and allow you to map the source and destination
columns
as it should - but on others the destination columns do not appear and
therefore will not allow us to map them. It seems to have different
results
on different machines indicating a possible service pack issue - but
that's
not the case. We all have SQL2k, SP3 and our machines are same model
Dell's.

Since we can't put pictures here - I put some screen shots together at:
http://northwestservices.biz/dtsproblem/index.htm

#4

The hot fix for this problem can be downloaded from:

http://www.microsoft.com/downloads/d...814AE9D-BD44-4
0C5-ADD3-B8C99618E68D&displaylang=en

__________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Transform Problem

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Transform Problem - 04-20-2004 , 12:39 PM

Re: DTS Transform Problem - 04-21-2004 , 01:16 AM

Re: DTS Transform Problem - 04-21-2004 , 09:41 AM

Re: DTS Transform Problem - 04-21-2004 , 11:00 AM