how would I setup the C# code as a data flow source though?

Thanks Howard

I am doing single record inserts for it, will combine it with a SSIS and see how it goes.

Great advice, thanks!

Hi there

I also fixed the problem with a Row Number, but I want to know why it reacts like this?

Why do the results get sorted randomly when and not stay...

Hi David

Sorry about that, it works, didn't look at the results properly.

Thanks, works a treat.

Thanks David

Your one works nicely, the ,SUM(1-SIGN(Pos-1)) section returns 0 always, but I have tweaked it to fit my needs.

@bartedgerton-2: Sorry, my post was a bit mis-leading, I dont actually have the position at that level.

Here are some sample scripts:

Table

CREATE TABLE [dbo].[SalesData](

[SaleYear] [int] NULL,

[SaleWeek] [tinyint] NULL,

[ProductId] [int]...

Thanks, found a another two week old copy on a dev server, going to detach/attach the MDF files.

Thanks Kevin

Will read through it tomorrow.

Interested to read how to get info back in a query that requires more than a plain join.

I went through the functions and realized they are not needed as advanced as they are in this query.

"Fixed" it by using this:

SELECT

.

.

.

, ISNULL(CAST(NULLIF(PR.RetailPrice,0.00) AS VARCHAR(20)), 'N/A') RetailPrice

,

(

SELECT TOP...

We have a recovery plan in place, I will run a comparison when the Backup is set to Bulk Logged and see what difference it makes.

We also have a lot...

Thanks for the input.

Our DB's and Logs are already split onto different drives and the Import and Production DB are also on separate drives.

I think I will have a look...

Hi Igor

The updates get run from an "Import" Database, so I will have to set the Production DB and Import DB to Single User.

All DB's are already set to Simple...

Hi, it doesn't allow me to log into the server with the Account the Agent runs off.

I have another FTP application that works a bit differently, will try and implement...

I am running both on the Server

@Koen: I can't use a normal FTP task as there are multiple files that I need to download from the folder and then delete each one as I download it.