I have always used procs, maybe because I started with SSRS 2000 and it was terrible, so I did everything I possibly could in the database and just used SSRS...

I think there are two key things you need. Firstly the container needs to have a setting of MaximumErrorCount > 1 so that the it doesn't fail when the dataflow...

I just noticed that you are using MySQL so I really don't know, but GO...

It's almost a week later, what did you end up doing?

I am curious as to whether it is possible to stop the service and copy the data file(s)  with or...

This might work for creating a table of local date times when Eastern Daylight Savings and Central European Summertime start and end for the next 10 years (based on current...

It may be the permissions of the SQL Server Service account.

I just created a share and granted just myself permission to access it and I confirmed that I could in...

Have you set up the aaa directory as a share?

That path "\\ServerA\aaa\" presumably refers to a specific drive on the server.

I have an audit that I reference using a mounted...

I would recommend...

Are you sure it's not EDT?

Now I see why AWS defaults to Zulu time.

Does this work? I don't know if the extra level of nesting is required, or whether you can just replace the select * with a column list.

SELECT...

I would not use a row_number. Row_number is useful for returning a specific row. The requirement is to identify pat_ids that have multiple dx ,but do not have multiple excluded...

The null date is ordered after the valid dates (in descending order)  so will...

• This reply was modified 3 years, 3 months ago by Ed B.
• This reply was modified 3 years, 3 months ago by Ed B. Reason: typo

Are you trying to execute multiple packages sequentially from a single execute package task?

If so then I think your execute package task needs to be in a for each loop...

Edit: What they said.

It may be that the drive is mapped for your user, but not the SQL Service account, or whatever account the GUI uses.

Have you tried writing a...

• This reply was modified 3 years, 4 months ago by Ed B.

When we have a new server (aws so we create and delete them fairly often) and I am a local...