Viewing 15 posts - 1,111 through 1,125 (of 5,109 total)
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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;...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 13, 2019 at 10:20 am
DB<>Fiddle showing "working as intended".
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 12, 2019 at 9:43 pm
The new forums don't allow this by default. There are a few plugins. I'll file a note to look at them
Sounds goods. Thanks for all the efforts from you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 12, 2019 at 9:38 pm
Viewing 15 posts - 1,111 through 1,125 (of 5,109 total)