May I ask why you don't just fetch everything you need in one go, rather than the inefficient looping technique you have coded?

Thom A (12/19/2016)

---

Hi All,

I know this is an age old problem, however, does anyone know how to get around the ACE driver and overide the field type it thinks a...

Not that I know of.

allenjoey24 (12/18/2016)

---

I'm new to SQL so I'm not really sure what to do.

Also not sure if I'm on the right forum for this, If not I'm sorry.

I'm trying to modify...

Lowell (12/16/2016)

---

Phil Parkin (12/16/2016)

---

Glad you solved it. Not sure whether you know this, but if you add

using System.IO;

into your Using block (towards the top of your code module)

it allows you...

Glad you solved it. Not sure whether you know this, but if you add

using System.IO;

into your Using block (towards the top of your code module)

it allows you to use the...

mandavli (12/16/2016)

---

I have created the Integration Services package , one of the task I use is script task.

This Task checks if the file exists on the network drive.

package works...

I think you got hit by the infamous 'quote bug'. But don't let that prevent the additional coffee intake.

Grumpy DBA (12/16/2016)

---

Wow, today's spam includes a warning about BOOTY POP... dang, just as I was about to order cases of BOOTY POP for my family and friends for Christmas....

I must admit to wondering whether this was some dodgy French film I needed to...

sarwar.ali490 (12/15/2016)

---

Hi

I have a following scenario.

File has 4000 records.4(1,2,3,4) sets of records make one final record.I am moving whole set of 4 records if any of the (1,2,3,4)record has some...

Robert Frasca (12/15/2016)

---

That's actually the way it is in my code except for the insert and select statements which are one line. Of course, I chose the wrong tag...

Sorry...

Here is the code again, this time with IFCode formatting (please do this in future, to aid your readers)

DECLARE @rowGUID [uniqueidentifier]

,@InfoXML [varbinary] (max)

,@InfoXMLPerf [varbinary] (max)

,@AppGuid [uniqueidentifier]

DECLARE @LogTable AS TABLE (

LogDatetime...

Lowell (12/15/2016)

---

I've got a situation where csv files are superseded by another in a given month; they gather on an FTP site for collection at my convenience.

they do follow...

It would be interesting to know how performance varies between the two options (CAST in source and data conversion in package).

For those with separate servers running SSIS, doing the data...