going to run a trace for an hour or so

yes. using last exe time. It should only run as a step in a process that run at 7am hour. I see that run in the result set however i...

i've never heard of anyone using the identity as the primary key

i had the same issue. The only way i could resolve it was to add the account that is running the sql agent service as an admin on the box...

to close the loop.

I've been having several issues w/ SSIS. specifically w/ it's file consumption. In this instance u have to access the tab name as opposed to some sort...

I had to create an index that added all the columns in the include of the index. This was because i created a function that has to return all the...

sorry. posted to wrong site. this isn't a sql issue.

it appears the developer is using 32 bit app and its running on 64 bit os. This only allows the 32...

anyone have any helpful input other than that i should stop using ssis for transformations?

yea. that's the thing. i have the text qualifier set to double quote. however it's choking on the two double quotes between should and have below. I was hoping there...

heres more detail.

source sql server:

This is the server i'm makeing the open query call from....

Microsoft SQL Server 2012 - 11.0.2100.60 (X64)

Feb 10 2012 19:39:15

Copyright (c) Microsoft Corporation

Standard Edition...

crickets....i just don't understand why this would be available in all other versions but 2012.

Now i have to code a linked server call directly if my process is trying to...

figured i'd close the loop on this one. The issue started a week ago. the update wouldnt do an index seek which i assume it was doing before because it...

actually. thats the estimated exe plan

attached plan

i found this ssis package is a step in a job calling several othe ssis packages. There is actually an ssis package calling a single stored proc. After documenting the...