Reported the post above as Spam. Don't use brain dumps you will be caught out in the real world. Post now deleted

Get a copy of SQL Development edition onto your...

Jeff - thank you for taking the time to do a detailed analysis of my solution. Much appreciated! It is always good when something started out as a bit of...

Thought I would have a go at your challenge Jeff, just for fun as it is quiet in work.

Looking forward to any critiques - not sure if I went...

You will be better asking this question on an Excel / VBA forum but based on the limited section of code it is missing TableDestination and TableName.

Have you changed the account the service uses? The log on as a service permission should be granted to the service account during the setup of the instance. Double check...

In order to get the best answer you should post the table structure, sample data and what data you expect to get in return, but see below - does this...

You might be better asking this question on a PHP forum.

Are you using MS SQL Server or MySQL?

If you are using MS SQL Server then the following will convert a...

If you are querying it from other databases with a different collation or vise versa you may need to specify a collation in the join or predicates to resolve any...

The % sign returns the remainder of a division. So 10 % 3 = 1

It will be to do with MSDTC.

Check that the MSDTC service is running on all machines involved in the transaction i.e. if you are running the package from your...

Do you get any output from the below while the ssis package is hanging?

SELECT * FROM sys.dm_exec_requests where blocking_session_id <>0

If the transactions are implemented manually does it work? (Add...

Do you have any data flow tasks in the package?

Here is a way to send data via an html table in the body of an email

declare@Body nvarchar(max)

,@Query nvarchar(max);

declare@tabtable (

Column1 intnot null

,Column2 nvarchar(20)not null);

insert into

So you aren't seeing any locks when using sp_who2 when the package is hanging?

If you change the transaction option for the package to be not Supported does the package run...

Check to see that the MSDTC service is started on the servers that the SSIS package is running on/against.

Does it fail after a period of time? If so...