SSIS - How do you eliminate quotes from being uploaded from a flat file to SQL Server?

Nice?Vote!

asked 1 year ago in SSIS Interview Questions and Answers by R (19,530 points)

1 Answer

Nice?Vote!

In the SSIS package on the Flat File Connection Manager Editor, enter quotes into the Text qualifier field then preview the data to ensure the quotes are not included.
Additional information: How to strip out double quotes from an import file in SQL Server Integration Services

answered 1 year ago by R (19,530 points)

Related questions

Nice?Vote!

1 answer

SSIS - How to pass property value at Run time? How do you implement Package Configuration?

asked 1 year ago in SSIS Interview Questions and Answers by R (19,530 points)

Nice?Vote!

1 answer

Can you explain how to setup a checkpoint file in SSIS?

asked 1 year ago in SSIS Interview Questions and Answers by R (19,530 points)

Nice?Vote!

1 answer

How to unzip a File in SSIS?

asked 1 year ago in SSIS Interview Questions and Answers by R (19,530 points)

Nice?Vote!

1 answer

What is a breakpoint in SSIS? How is it setup? How do you disable it?

asked 1 year ago in SSIS Interview Questions and Answers by R (19,530 points)

Nice?Vote!

1 answer

How do you schedule ssis packages to run on the fly?

asked 1 year ago in SSIS Interview Questions and Answers by R (19,530 points)