INSERT and INSERT INTO are identical - INTO is there only as a readability aid.

There is no simple way of doing this.

I can think of three possibilities:

1) Output each row as a single column - you'll have to concatenate all the columns and add...

That does not look like a data conversion. After removing the quotes, I think you may need one of these.

simoniainsmith (7/13/2012)

---

Thanks for the reply.

Field is coming in as string, because if I set the column to DT_R8 then blank values which are quoted "" which causes a failure.

Hence why...

Have you defined the column as double precision in your flat file source?

If so, why do you talk about 'converting' to DT_R8?

Yes, but the Foreach loop (or some other technique) will still be required to take care of the varying file name ...

Sounds like a foreach task containing a fairly simple dataflow to me. The Foreach task will enumerate over your import folder, looking for *.xslx (or similar) and passing the name...

Mike Palecek (7/11/2012)

---

I am looking for the same information. I have two servers that are at different companies and I need to move data from one to another. The servers...

Presumably you are...

I don't quite follow you.

Can you provide a couple of extra bits of information please?

1) Sample input data

2) Desired results, based on the input data provided.

If you follow the link...

OK. Your problem is possibly down to the fact that the WHERE clause is acting on the whole row at a time (and not just to date1, date2 etc individually).

You...

Add a Row_Number() column to both (with sorting as you require) and join on that - then the update becomes trivial.

Jeff Moden (7/9/2012)

---

Koen Verbeeck (7/9/2012)

---

SSIS can rename files. I do it all the time.

It just happens to be that with a script task using .NET I have more control over...

Devesh_Srivastava (7/10/2012)

---

I am trying to fetch the rows from the source table which have a timestamp(Column) within the last 20 minutes and then formatting the rows to send the data...

phoeneous (7/9/2012)

---

Can't wrap my head around this one. Not sure which is the best way to handle the logic, in t-sql or ssrs.

12 columns total, six money columns and...