Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 701
  • Last Modified:

DTS from table to text delimited file

I am trying to DTS from a sql server 2000 table to a | delimited text file.

I can get it to work fine with all the columns, but if I try and exclude some of the columns it comes up with the following error:

A DTSTransformCopy must specify no columns (signifying a 1-to-1 mapping of all columns) or the same number of source and desgination columns

However - the destination columns section is empty.

anyone got any ideas?

thanks...
0
jon100
Asked:
jon100
  • 5
  • 3
1 Solution
 
Frostbyte_ZeroCommented:
Double Click the DataPump Task. In the Transformation tab: Delete all the transformations. Then recreate the transformations. You can just click New/ActiveX Transaformation. Then you have a dialog with 3 tabs. Click Source, select the fields you want to include. Click Destination, ensure that there are the same number of fields. Click Properties, then you should have a default ActiveX script for you. You can edit it if you want. Test it. And Save.

0
 
jon100Author Commented:
Thanks

The Destination Columns tab doesn't contain any fields.
0
 
Frostbyte_ZeroCommented:
Double Click the Destination Connection in your DTS Package and make sure that it is still valid.
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
jon100Author Commented:
its still fine - my destination is a text file remember...
0
 
jon100Author Commented:
Its strange - I can go in and select the source table fine

It then lets me 'define columns' - which I do (removing 4 from the end of the table) and go onto transformations - but none of the fields I created are in destination - whats going on?

Also if i go back in and try and edit the destination tab / Define Columns - SQL Server fully crashes.

Im on sp3 sql2k developer edition...
0
 
Frostbyte_ZeroCommented:
Try rebuidling the DTS using the Impor/Export Wizard. Use a SQL statement instead of a Table as your Source.
0
 
jon100Author Commented:
Great thanks - good work around idea.

I wonder if Microsoft are aware of this problem (seems2b a prob2me)
0
 
geoffbtbcCommented:
I have the same problem with SQl2k/sp3, on one of our servers. I want to do this as part of a DTS package, and I can use the wizard to create this part and then add to it; if I try to edit that transformation within the GUI, it forces me to redo all the mappings and then claims it has no destination column names to use.

Did you ever get it to work?
0
 
jon100Author Commented:
hi geoffbtbc - no never found a solution. What I had to do is use the wizard work around, which got round the issue for me.

Hopefully it's something they'll fix in the next sp / version.

Good luck
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now