Hi

I am trying to update a DTS package (saved as structured
file) so that data is extracted from a different table to
a CSV file.

However, after changing the source table, it tries to
rebuild transformation definitions. I accept and shows a
blank list of columns in the target text file. When I
click on Define columns, it does nothing but stop
responding and close suddenly after some seconds. I have
the same problem in another server. Both are SQL Server
2000 SP3 on Windows 2000 Server SP3.
I have had to edit these packages in a old SQLServer7
server were there is no problem at all.

Any ideas? Thanks
Percy

You are possibly seeing this

http://support.microsoft.com/default...B;EN-US;814113


When you change the source as well DTS will ask if you want to redo
mappings. If the new source file has the same column names as the last one
(i.e. they are the same in all but name) then at the prompt say "Cancel".




--

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



"Percy" <percy.cabello (AT) pfizer (DOT) com> wrote

Hi

Thanks for replying.

I only change the source table (which has the same
structure as previous source as it was created from
a "select into" ).The target file (CSV) only has a
different name but the same exact structure of previous
target (a copy of previous target).
After changing the source table I have no chance for a
Cancel. A " Verifying transformation" window appears
asking for remove, change or redo transformations.

Whichever I choose it will remove all transformations. In
the target tab, there are no fields listed for the target
file. When I click on Define columns, it hangs up and
closes silently.

I am going to try the security fix suggested in our test
server and let you know.
Once again thank you very much for your interest.
Percy

Just to clarify. The source is a SQL Server table. Only
the target is a text file.

Percy

I created two tables

CREATE TABLE Source1(col1 INT)
CREATE TABLE Source2(col1 INT)

I used a DataPump task and mapped the Source1 to the text file.

I changed the SourceObjectName to Source2 - No Problems
I Changed the text file name to something different and it gave me a box
saying "Task References". Ithen have the option to "Select All", "Deselect
All", "Cancel"

Is this not what you mean?

--

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



"percy" <percy.cabello@pfizer> wrote