SSIS Column Export

Question

SSIS Column Export

Andy Warren

SSC Guru

Points: 119902
More actions
July 9, 2014 at 12:07 am

#148493

Comments posted to this topic are about the item SSIS Column Export
Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
July 9, 2014 at 6:22 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 27 total)

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

karthik babu Hall of Fame Points: 3335 More actions · Answer 1

Jus got lucky!! Nice question though!! 🙂

______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂

robertjtjones SSC-Addicted Points: 484 More actions · Answer 2

robertjtjones

SSC-Addicted

Points: 484

July 9, 2014 at 1:21 am

#1727956

Never come across this before - thanks

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 3

I did not had luck 🙂 and did not knew the answer. But thanks for sharing this exercise and the experience.

Iulian

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 4

Hardy21

SSCrazy Eights

Points: 9708

July 9, 2014 at 5:22 am

#1727988

Thanks for sharing.

Thanks

ssimmons 2102 SSCommitted Points: 1634 More actions · Answer 5

thought for sure the path was missing from the query was the answer

Sergei Yakovlev Hall of Fame Points: 3141 More actions · Answer 6

The FileID column does not look like FilePath column.

Sean of the Lynchmob Ten Centuries Points: 1038 More actions · Answer 7

Thanks Andy, something else learnt. And my Wrox 'Professional Integration Services' book was no help at all!!! 😉

Sean

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 8

Sergei Yakovlev (7/9/2014)
The FileID column does not look like FilePath column.

I agree... I see we're back to trying to read Andy's mind to determine what he really wanted to ask instead of what he actually asked. :unsure:

mickyT SSChampion Points: 10360 More actions · Answer 9

mickyT

SSChampion

Points: 10360

July 9, 2014 at 1:45 pm

#1728205

Thanks Andy

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 10

I was thinking about the unicode column requirement, because it is required in some components such as the term extraction component, but then I went for the more logical answer.

Thanks for the question.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Neil Burton SSC-Insane Points: 23009 More actions · Answer 11

What's your best guess on what's going wrong?

This does require you to make the assumption that FileID is probably a numeric of some type, in real life you'd probably get it quickly if you saw the query results, it's harder when you're just hearing/visualing the problem.

And there's the problem. I am that junior developer, and when questions explicitly ask you to guess and the explanation requires you to make an assumption then I've next to no chance. I enjoy the QOTD, I like the fact the I've usually got to do some research to answer the question and I accept that I'm going to get some of them wrong. What I don't like is when a question requires a level of experience to answer it because the answer is essentially system specific. Obviously some questions are going to be harder than others and the whole point of them is to learn but it seems a little unfair to base the answer to a question on the things that aren't cold hard verifiable facts. Don't get me wrong, I like learning about the in depth workings of SQL Server and that's my point; with the QOTD I like to learn something to get the answer right but it sometimes seems that we're expected to just know something else first.

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

Ed Wagner SSC Guru Points: 287026 More actions · Answer 12

I thought it was a decent question on something I know nothing about. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Aleksl-294755 Hall of Fame Points: 3514 More actions · Answer 13

Chris Harshman (7/9/2014)
Sergei Yakovlev (7/9/2014)
The FileID column does not look like FilePath column.
I agree... I see we're back to trying to read Andy's mind to determine what he really wanted to ask instead of what he actually asked. :unsure:

Agree