April 2, 2015 at 4:20 pm
Hi all,
I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I didn't see any commas but it appear in connection manger as shown in SSIS package. Please I don't want tips like substring and charindex. Any alternative eliminating library functions
Please check the attachment.
April 2, 2015 at 4:30 pm
Please anyone, I am waiting for the reply.
April 3, 2015 at 6:31 am
sqlmaverick (4/2/2015)
Please anyone, I am waiting for the reply.
You don't have 10 minutes patience?
I'll give my reply within 10 minutes...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 3, 2015 at 6:37 am
sqlmaverick (4/2/2015)
Hi all,I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I didn't see any commas but it appear in connection manger as shown in SSIS package. Please I don't want tips like substring and charindex. Any alternative eliminating library functions
Please check the attachment.
As this is a comma delimited input file (CSV), just add one more column (which will be empty) to the import and then discard it.
😎
April 3, 2015 at 6:38 am
sqlmaverick (4/2/2015)
Please anyone, I am waiting for the reply.
Just a quick FYI, on a volunteer site where no one gets paid to help other people, being impatient tends to make the helpful people not want to help. Also, if the matter is that urgent, then posting on the internet is not the way you want to go. I'm sure there's someone local you can hire to help you out. Or remember Google and BOL are your two best friends.
That being said...
sqlmaverick (4/2/2015)
Hi all,I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I didn't see any commas but it appear in connection manger as shown in SSIS package. Please I don't want tips like substring and charindex. Any alternative eliminating library functions
Please check the attachment.
So the commas aren't visible on those lines in a text editor? Sounds like they are hidden ascii characters. You might want to check out getting a hex editor so you can see them.
Also, quarantine them off in their own column, then ignore the column when importing the file to the new table. That would be your best bet.
April 3, 2015 at 6:43 am
Eirikur Eiriksson (4/3/2015)
sqlmaverick (4/2/2015)
Hi all,I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I didn't see any commas but it appear in connection manger as shown in SSIS package. Please I don't want tips like substring and charindex. Any alternative eliminating library functions
Please check the attachment.
As this is a comma delimited input file (CSV), just add one more column (which will be empty) to the import and then discard it.
😎
We're 10 minutes later and that was going to be my reply 😎
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 3, 2015 at 7:21 am
Koen Verbeeck (4/3/2015)
Eirikur Eiriksson (4/3/2015)
sqlmaverick (4/2/2015)
Hi all,I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I didn't see any commas but it appear in connection manger as shown in SSIS package. Please I don't want tips like substring and charindex. Any alternative eliminating library functions
Please check the attachment.
As this is a comma delimited input file (CSV), just add one more column (which will be empty) to the import and then discard it.
😎
We're 10 minutes later and that was going to be my reply 😎
Sometimes waiting is worth it;-)
😎
April 3, 2015 at 8:06 am
Koen Verbeeck (4/3/2015)
Eirikur Eiriksson (4/3/2015)
sqlmaverick (4/2/2015)
Hi all,I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I didn't see any commas but it appear in connection manger as shown in SSIS package. Please I don't want tips like substring and charindex. Any alternative eliminating library functions
Please check the attachment.
As this is a comma delimited input file (CSV), just add one more column (which will be empty) to the import and then discard it.
😎
We're 10 minutes later and that was going to be my reply 😎
Hmph, I expected that answer within 10 minutes like you claimed. This answer is outside the promised 10 minutes.
<duck and run>;-):-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 3, 2015 at 8:14 am
SQLRNNR (4/3/2015)
Koen Verbeeck (4/3/2015)
Eirikur Eiriksson (4/3/2015)
sqlmaverick (4/2/2015)
Hi all,I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I didn't see any commas but it appear in connection manger as shown in SSIS package. Please I don't want tips like substring and charindex. Any alternative eliminating library functions
Please check the attachment.
As this is a comma delimited input file (CSV), just add one more column (which will be empty) to the import and then discard it.
😎
We're 10 minutes later and that was going to be my reply 😎
Hmph, I expected that answer within 10 minutes like you claimed. This answer is outside the promised 10 minutes.
<duck and run>;-):-D
You're right. You get your money back!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 3, 2015 at 8:22 am
Koen Verbeeck (4/3/2015)
SQLRNNR (4/3/2015)
Koen Verbeeck (4/3/2015)
Eirikur Eiriksson (4/3/2015)
sqlmaverick (4/2/2015)
Hi all,I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I didn't see any commas but it appear in connection manger as shown in SSIS package. Please I don't want tips like substring and charindex. Any alternative eliminating library functions
Please check the attachment.
As this is a comma delimited input file (CSV), just add one more column (which will be empty) to the import and then discard it.
😎
We're 10 minutes later and that was going to be my reply 😎
Hmph, I expected that answer within 10 minutes like you claimed. This answer is outside the promised 10 minutes.
<duck and run>;-):-D
You're right. You get your money back!
....in the form of a voucher?
😎
April 3, 2015 at 9:58 am
Eirikur Eiriksson (4/3/2015)
Koen Verbeeck (4/3/2015)
SQLRNNR (4/3/2015)
Koen Verbeeck (4/3/2015)
Eirikur Eiriksson (4/3/2015)
sqlmaverick (4/2/2015)
Hi all,I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I didn't see any commas but it appear in connection manger as shown in SSIS package. Please I don't want tips like substring and charindex. Any alternative eliminating library functions
Please check the attachment.
As this is a comma delimited input file (CSV), just add one more column (which will be empty) to the import and then discard it.
😎
We're 10 minutes later and that was going to be my reply 😎
Hmph, I expected that answer within 10 minutes like you claimed. This answer is outside the promised 10 minutes.
<duck and run>;-):-D
You're right. You get your money back!
....in the form of a voucher?
😎
Actually, you get what you pay for here.
April 3, 2015 at 10:05 am
Lynn Pettis (4/3/2015)
Eirikur Eiriksson (4/3/2015)
Koen Verbeeck (4/3/2015)
SQLRNNR (4/3/2015)
Koen Verbeeck (4/3/2015)
Eirikur Eiriksson (4/3/2015)
sqlmaverick (4/2/2015)
Hi all,I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I didn't see any commas but it appear in connection manger as shown in SSIS package. Please I don't want tips like substring and charindex. Any alternative eliminating library functions
Please check the attachment.
As this is a comma delimited input file (CSV), just add one more column (which will be empty) to the import and then discard it.
😎
We're 10 minutes later and that was going to be my reply 😎
Hmph, I expected that answer within 10 minutes like you claimed. This answer is outside the promised 10 minutes.
<duck and run>;-):-D
You're right. You get your money back!
....in the form of a voucher?
😎
Actually, you get what you pay for here.
Of course, the site being strictly WYPIWYG
😎
April 3, 2015 at 10:10 am
Eirikur Eiriksson (4/3/2015)
Lynn Pettis (4/3/2015)
Eirikur Eiriksson (4/3/2015)
Koen Verbeeck (4/3/2015)
SQLRNNR (4/3/2015)
Koen Verbeeck (4/3/2015)
Eirikur Eiriksson (4/3/2015)
sqlmaverick (4/2/2015)
Hi all,I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I didn't see any commas but it appear in connection manger as shown in SSIS package. Please I don't want tips like substring and charindex. Any alternative eliminating library functions
Please check the attachment.
As this is a comma delimited input file (CSV), just add one more column (which will be empty) to the import and then discard it.
😎
We're 10 minutes later and that was going to be my reply 😎
Hmph, I expected that answer within 10 minutes like you claimed. This answer is outside the promised 10 minutes.
<duck and run>;-):-D
You're right. You get your money back!
....in the form of a voucher?
😎
Actually, you get what you pay for here.
Of course, the site being strictly WYPIWYG
😎
Ouch! I feel gypped.:-D:-D:-D:-D:-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 3, 2015 at 10:13 am
To the OP. Please pardon the joking that has transpired, it is free and can actually relieve the stress of work.
On a serious note, posting the picture though interesting, doesn't really help. A small subset of the file being imported being attached (uploaded) to your post would be more beneficial as it would give us something to test.
Remember, we don't have access to your systems and the files so it is hard to provide good answers with little with which to work.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply