Viewing 15 posts - 1,111 through 1,125 (of 5,111 total)
If you really want to use COUNT instead of SUM you could do:
COuNT(CASE WHEN DateColumn >= '20190101' AND DateColumn < '20190201' THEN 1 END) AS Jan19
As there...
April 14, 2019 at 4:55 pm
That symbol is a warning. Most likely the data types of your source and destination are identical and you aren't explicitly converting the value. In this case it's warning you...
April 14, 2019 at 12:40 pm
What is the goal your trying to achieve here? Normally using a script task to display a message box isn't actually a good idea. When running a deployed package you...
April 14, 2019 at 11:55 am
I don't mean to be rude, but please do take the time to read the replies
That won't be the whole script (if it is, that's your problem). Post the...
April 14, 2019 at 11:27 am
The script is included above,also see screenshot attached. When i close the script box it says "Script contain error"
That won't be the whole script (if it is, that's your...
April 14, 2019 at 10:52 am
You forgot to include the script and the error, so this is impossible for us to help you on this right now.
April 14, 2019 at 10:31 am
The source data is totally separate to SSIS. How you keep an Excel file secure has nothing to do with SQL Server. My suggestion would be store it in a...
April 13, 2019 at 8:37 pm
Not sure what you mean by only those authenticated. Only those who have permission to execute packages in SSISDB will be able to execute the packages; but you can't decode...
April 13, 2019 at 7:43 pm
That totally depends on how you set up the data sources. If they are using Windows Authentication, then they will be using the authentication of the account running the package;...
April 13, 2019 at 10:52 am
Can you post the DDL of your tables please? Please also make sure to use the "Insert/edit code sample" button to make it readable too. I can't replicate the problem...
April 13, 2019 at 10:20 am
DB<>Fiddle showing "working as intended".
April 13, 2019 at 9:22 am
It does look good, it worked almost 98%, but issue is here with order, the few columns are added to table later - I mean not with original table...
April 13, 2019 at 9:18 am
The way that the categories are label can be a "bit" unintuitive. You're looking for a schedule that runs "daily" apart from on specific days so you're looking at the...
April 13, 2019 at 8:29 am
I also don't see the emojis in the toolbar. I inserted one above by typing, but I admit I'm not up on all the emjoi characters, especially my favorite...
April 12, 2019 at 9:52 pm
If you want every row other than the first 10 have you had a look at the OFFSET clause?
April 12, 2019 at 9:43 pm
Viewing 15 posts - 1,111 through 1,125 (of 5,111 total)