Nice question, thanks.

The regular toolbox is normal, the SSIS toolbox however not.

You are using the SSDT that comes with the SQL Server installation right?

You could use the delimited split function by Jeff Moden:

Tally OH! An Improved SQL 8K “CSV Splitter” Function[/url]

It returns a table with the various parts and their positions, so you...

AndrewSQLDBA (10/7/2013)

---

Hello Everyone

I have had some SSIS packages that I converted to SQL 2012 using the SQL tools, what was once BIDS. I would like to edit one, but none...

You should start with a good book, which will probably answer most of those questions.

Start with the Data Warehouse Toolkit by Ralph Kimball.

How is the data retrieved from the database? I guess with a query? Modify the query so that no duplicate data is retrieved.

Are there more details in Event viewer or in the setup log?

damien.gulluni (10/7/2013)

---

Anyway this is not the concern of my request to say if SSIS is responsible or not ...

What I am looking for, and thank you again for your time,...

damien.gulluni (10/7/2013)

---

I fully agree when you have the control of the file produced .. The file comes from Business Object world and I have only choice between tab, semicolon, and...

It seems to me your text qualifiers are the problem, not the commas.

Anyway, all of these issues can easily be avoided by choosing a decent delimiter.

damien.gulluni (10/7/2013)

---

Hi Raunak,

First of All, thanks for your reply. I already tried with a Flat File Connection; but the error occurred directly on the Flat File Source.

The solution I am...

Very nice question, thanks.

kalaiselvan.rajendran (10/4/2013)

---

Its Fine. But am Sorting Transformation to get the Unique Values for some Columns.

And Aggregation Transformation to SUM the Values for Measure Columns.

Without Using these How Can i...

You still have to map columns. SSIS needs fixed metadata.

If you have no header, the column names should be...

In the connection string you can indicate that there is no header line.

Set HDR=YES to HDR=NO.