SSIS package

Question

SSIS package

HBK_4700

SSCrazy Eights

Points: 8932
More actions
September 23, 2010 at 12:53 pm

#142849

Hi,
I have a weird issue.
I am exporting SQL Server 2005(10 tables) data to csv files. I am running the package successfully.
But in one table, 2 column name were almost same.
UserQuestionsID
UserQuestionID
SOme how UserQuestionID is taking the value's of UserQuestionsID in csv file. Both column data is not identical.
Not sure what is issue. any thoughts?
Client is asking for issue cause asap. Appreciate your quick response.

Viewing 2 posts - 1 through 1 (of 1 total)

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

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 1

laddu4700 (9/23/2010)
Hi,
I have a weird issue.
I am exporting SQL Server 2005(10 tables) data to csv files. I am running the package successfully.
But in one table, 2 column name were almost same.
UserQuestionsID
UserQuestionID
SOme how UserQuestionID is taking the value's of UserQuestionsID in csv file. Both column data is not identical.
Not sure what is issue. any thoughts?
Client is asking for issue cause asap. Appreciate your quick response.

First guess, there's a comma in one of the columns that comes before UserQuestionID. This comma is causing Excel to think there's a delimiter where there isn't really one.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]