Use CSV filecomma separatedin extraction process of SSIS, MSBI

Hey learner’s let us get acquainted with one more error which a candidate of Mumbai in MSBI training. Below explained is the scenario which caused error and resolution given to it.

Error:

Now while doing the ETL process we are using a “CSV” file. We are taking the CSV file and then doing the Extraction Transformation and Loading process on it. The ideal CSV file looks like this,

1

But while doing this a trainee from Mumbai MSBI Training session conducted by SBSS group, faced an error like this

2

3

Solution:

The solution for this error was simple, as CSV file type was used its default format is that all the data in it should be separated comma (,). The trainee had missed to put some comma

4

So always remember the data should be separated with comma (,) in a CSV file, like this:

5

After doing this when the program is executed it gives us the proper output.

6

7

Interested in attending upcoming Mumbai training on MSBI topic visit this link and get to know completely in detail about two days training information.

Comments

comments

This entry was posted in MSBI Training in Mumbai and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published.