If you created the SSIS package under a Windows account then you can create a Proxy object to run the job under. The way I understand it a proxy treats...

You can then create a view as a UNION ALL of the those two tables and use that for simplicity.

SELECT * , 1 as 'party' FROM myproducts

union all

SELECT...

Hi and thanks for your replies --

Accounts is a table, thus there are no calculations occurring.

I will post any news I have for I am working away on isolating the...

I did something like the following

set rowcount 0

Select id,

case when datecolumn1 is null then 2 else isdate(datecolumn1) end as c1, /*isdate returns 1 when true and 0 when false*/

case...

Hi Kal -- I'm not the original author of this thread. I am just issuing my own grievances with the same message the author gets. All of our date columns...

I should be a bit more clear:

I can query all the date fields in the record mentioned (id 509416). They show up as a date or as NULL. But the...

I run select * from accounts where id = 509416 and the SSMS just hangs there executing the query - even stopping doesn't help, I have...

We get this error when we select * on one of our records in one table (using like where id = 12345). I can see all the dates and nulls...

I agree with Paul. Just look up the SUBSTRING function.

I experienced this problem after I installed a service pack. I opened the "configure report service" application on the server machine. In report manager virtual directory settings I checked the...

I know there are many possibilities but one thing I would consider is if the SSIS package runs while many client apps are connected to the server. Thus there would...

A good bet is to create the package as the very user whose credentials are used to run the package. The user should be a member of the role(s) needed...

Okay I guess I am not clear on your objective. Can I ask how you are inserting records? Without bulk load they are commited one at a time. Do you...

Bulk loads I am quite sure bypass triggers. To use the sp_send_dbmail procedure you have be an admin or the login should be given the securable DatabaseMailUserRole (a schema) pertaining...

In the Raw file properties dialogue set WriteOption to 'append' and ValidateExternalMetaData to false. This should still create the file on the first iteration. I found it to be inconsistent...