CODEWITHSUNDEEP
sql-serversql-server-2008ssis
prav
prav

Reputation: 450

Text Qualifier in flat file connection

I have business scenario as

  1. source files (text files) comes to load into SQL database so I used the flat file connection manager as normal process.

  2. My requirement as, we are getting source files with qualifier (") so we used the text qualifier property in the connection manager.

  3. For the same set of files we are getting without text qualifiers in the files there SSIS packages failing.

Here I need information on SSIS package handle the files

Could we implement the both scenarios in the same package.

thanks

prav

Upvotes: 2

Views: 2119

Answers (1)

Steve Homer
Steve Homer

Reputation: 3922

You could pre-process the files using something like powershell. There's an article here talking about how to implement a file wide replace. Of course if you're comfortable with writing VB.NET you could implement the same thing in a scripting task in the package.

Upvotes: 1

Related Questions