Interesting, thanks for posting this: I'm sure that it will help others.

Steve Jones - SSC Editor (7/14/2015)

---

Seems to be working now, but sometimes the Search does unload all the results and flakes for some reason.

Send a note to the webmaster@ if...

Only if you need it.

Are you thinking that SQL Server...

Phil Parkin (7/14/2015)

---

Sounds good. I did it in a proc to avoid having to cut and paste C# code all over the place. I suppose you could have a child...

mberman (7/14/2015)

---

We are importing data from CSV files into SQL tables, where every column matches.

To do this we are using flat file connection managers. This requires manually inputting each field...

Sounds good. I did it in a proc to avoid having to cut and paste C# code all over the place. I suppose you could have a child package which...

Is this sync or async?

I call a 'helper' proc, which uses DBMail, via an ExecuteSQL task.

Could this issue have recurred? I clicked on the 'Search Forum' link, typed SQL and submitted. The response:

Sum (isnull (cola,0)) + ...

Should do it.

Lowell (7/13/2015)

---

i've done this with a script task, but i assume the file always has a header row for the column names, and that i know the delimiters, ie, comma/CrLf,...

Abhijit More (7/13/2015)

---

Describe what you mean by 'flat structure'.

Flat Table with all headers from files, if no header it should come with Column0, Column1, Column2...& so on.

Are the files all...

Ross.M (7/13/2015)

---

Thanks for the interesting post.

Genuine question to someone who uses this method frequently (without trying to sound argumentative):

Do you find this more useful than just highlighting the block and...

Abhijit More (7/13/2015)

---

I have challenge where I received data from multiple sources in different formats such as excel, csv, flat file.

Now the challenge is I have to load any received...

trboyden (7/10/2015)

---

Phil Parkin (7/10/2015)

I agree with you for production code. The general thrust of the thread, however, is around the creation of utility or setup scripts which are run and...