thanks for the reply.

I've visited the page already and the link on that page to the default brand package doesn't work, the file no longer exists for some reason:

<Message>The specified...

Thanks a lot, that works!

(I just had a minor error on my code - I should have put if >0 and not 1)

also changed to COALESCE instead of ISNULL

I've managed to get thus far:

I've added my employer table and used a left join.

I can count all the users in total (sum of all users for that employer ...

however... what seems to be harder to do is list data which has a count = 0 or <1.

e.g. we would also like to show which employers do not have...

thanks, that's done the trick !

thanks,

its working now.

we already had dbmail set up so managed to just use something like this to send mail:

EXEC msdb.dbo.sp_send_dbmail

@recipients = 'youremailid@xxxx.com',

@body = 'Database Mail Testing...',

@subject = 'Databas Mail from...

anthony.green (1/22/2013)

---

can you zip up and attach your solution.

Ok, all seems good apart from the new import connection manager isn't setup for a dynamic connection string.

1st off give the variable...

In Connection Manager >> Properties >> Expressions >>

I click on the ellipses and then on the next screen on the Property column drop the list down I have chosen ConnectionString.

I...

I've had a look at the stairways section on SSIS, and re-built the package from scratch.

I can now import some of the postcode data into my SQL table successfully without...

thanks for the help with the SSIS package.

I'm a newbie at SSIS and not sure what to enter in the variable mappings box?

Name...

Namespace...

Value Type...

Value...

also,

i'm not sure if its best to...

I have tried just " on its own, and that didn't work - import fails.

example of the content (when the database is set to limit data entries to 9 characters):

"AB123AB"

"AB12...

In my data flow, I have a Flat File Source which connect to a

OLE DB Destination

anthony.green (1/10/2013)

---

You will need to set a...

thanks for the replies anthony.

I think i tried too many things at once and got a bit lost.

it's now importing ok !

for the txt file which shows the warning message....

I...

I have made some recent changes since the first screenshot.

Such as making sure there are no spaces in the excel csv files, that they are all equal length and

making...

here is my full error message:

http://www.sypensions.org.uk/test/myimport.txt

thanks.