Viewing 15 posts - 3,016 through 3,030 (of 13,855 total)
Is this a question?
January 11, 2020 at 12:21 pm
OK, then try
CAST(coalesce(completeddate,lastsaveddate,receiveddate) as DATE)
January 10, 2020 at 6:50 pm
Was struggling with how to drop the time stamp, still not able to get there with coalesce
TIMESTAMP columns cannot be converted to times. What is the data type of...
January 10, 2020 at 4:12 pm
Use COALESCE(completedDate ,lastSavedDate ,receivedDate )
January 10, 2020 at 3:05 pm
Do you have any favorite links on the subject of pulling rather than pushing?
Hmmmm ...
January 10, 2020 at 2:01 pm
Yes, I am replacing TRUNCATE with DELETE. There are around 150 tables in total & for around 80 tables I have to reset the identity. Rest, of the tables,...
January 10, 2020 at 1:43 pm
No need for double single quotes. Try this instead.
AND Name IN ('VS DAY Cash', 'VS Non Cash')
January 10, 2020 at 1:37 pm
A) I've been using SSISDB logging for years now, so can't help you with that.
B) Not that I know of. You could add more debugging collection to the package itself...
January 9, 2020 at 10:08 pm
It's difficult to troubleshoot this further without knowing more. I recommend that you do start using SSISDB - the 'free' logging that comes with doing this is enough on its...
January 9, 2020 at 7:18 pm
How is that logging information being created? It looks non-standard.
Have you checked the All Executions logs to see whether there is any additional information there?
January 9, 2020 at 5:47 pm
SELECT OBJECT_NAME(object_id)
,object_id
FROM sys.columns
WHERE name IN ('Column1','Column2','Column3')
GROUP BY OBJECT_NAME(object_id)
,object_id
HAVING COUNT(1) > 2;
January 9, 2020 at 5:32 pm
Phil... where do you hail from? I ask because I'm giving the "Automating "Excel Hell"" presentation at the Cleveland SQL Saturday on the 1st of February 2020 and would...
January 8, 2020 at 9:05 pm
Are you missing a + before ".TXT"?
January 8, 2020 at 5:14 pm
Phil... where do you hail from? I ask because I'm giving the "Automating "Excel Hell"" presentation at the Cleveland SQL Saturday on the 1st of February 2020 and would love...
January 8, 2020 at 5:03 pm
Unzipping files is natively available in .NET, so there should be no need to install additional software.
See here for more info.
January 8, 2020 at 5:01 pm
Viewing 15 posts - 3,016 through 3,030 (of 13,855 total)