Long table names unviewable in "Transform Data Task Properties"

Question

Long table names unviewable in "Transform Data Task Properties"

Jamie Ashton

Mr or Mrs. 500

Points: 587
More actions
November 25, 2008 at 7:05 am

#72304

I am DTS'ing a .csv file into a database. Unfortunately, the table names are all prefixed identically, and when displayed in the drop down list, I am unable to see which table is which!
Does anyone know of a cunning workaround?
I have attached a screenshot so you can see my problem.
Hope you can help...

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184388 More actions · Answer 1

Well the tables are listed alphabetically so you can use that to figure out where it should be. Also as you select a table the column list changes so you can just select tables and see that.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Adrian Nichols-360275 SSCertifiable Points: 7694 More actions · Answer 2

You could also set an arbitrary destination to create the task and then perform a disconnected edit to change the DestinationObjectName of the transform data task manually.

When you go back to your transform data task you should be able to set up the transformations.

Ade

A Freudian Slip is when you say one thing and mean your mother.
For detail-enriched answers, ask detail-enriched questions...[/url]

Jamie Ashton Mr or Mrs. 500 Points: 587 More actions · Answer 3

Thanks very much for that guys.

Maybe Im being blind but I cant find "DestinationObjectProperties" in the "Edit All Package Properties" screen... am I looking in the wrong place?

Thanks again for your help - I've learned some new stuff about DTS today.

Adrian Nichols-360275 SSCertifiable Points: 7694 More actions · Answer 4

To get to the task properties you need to right-click in an empty space on the DTS designer page. On the context menu choose "Disconnected Edit". You can then navigate to the task using the object tree and (off the top of my head) the property you're looking for is about 4/5 down in the right-hand window.

Ade

A Freudian Slip is when you say one thing and mean your mother.
For detail-enriched answers, ask detail-enriched questions...[/url]