I find the logging in SSISDB to be incredibly verbose;  at times I feel like it's logging too much much it's one of those things where you are really grateful...

It does seem odd that there';s no rows; I hate to ask but you are looking at the correct table, database and instance right? The Data Flow arrow shows over...

Why were you using the COPY command at all? Why not use a File System Task for copy a file?

Pretty much. 🙂

Based on the OP's prior question here, looks like it is BRITISH, which means that the date string the OP has...

Thought I'd share a conversation I had with a user at the office today, as I do enjoy it when they lie to me but fail to keep their "story"...

What version of SQL Server? Perhaps STRING_AGG or FOR XML PATH and STUFF will help you here?

I also reiterate Pietlinden's comment; the users are unlikely to download a word document...

I think it's just a misleading error from SQL dump, can it be ?.

More info - Package works fine when running from Visual studio. Only on the server when ...

The reason that you're getting the incorrect result is because you're expected a varchar value to have the same ordering a date type value; that isn't true. Take today's date,...

• This reply was modified 6 years, 9 months ago by Thom A.

If I open either of those urls (obviously for my own instance), I'm asked to authenticate in a browser that doesn't support kerboros (i.e. Firefox). If I try with an...

Perhaps you have the "everyone" group added as a user that can browse the reports rather than a "users" group (which excludes accounts like those used by penetration testers? If,...

I'm really struggling to read what your asking here, as there is code not inside code markup in the middle of statements; making a somewhat unreadable mess I'm afraid.

You say...

it doesn't sound like the join is incorrect, it seems like the problem is the data, and that you have a many-to-many relationship. Seems like you need to fix the...

You were really close. Our little Renata was born on August 19 at 2:12pm EST. There were some complications and she's spending some time at NICU, but getting healthier...

Today has certainly had a segment of "I'm higher in the company, I...