Viewing 15 posts - 2,896 through 2,910 (of 13,855 total)
Your package needs to be part of a VS project & solution before the Run button will appear. Try creating these and adding the package to them.
March 3, 2020 at 4:44 pm
Hello,
the new environment I am working at now wants to use GitHub for version control, and SSIS for ETL, and wondering if SSIS integration catalog will work well with...
March 3, 2020 at 4:42 pm
Ah yes, I've been in that situation before. It may be that you could run on a higher version, in 2016 compatibility mode.
But most app vendors I've come across are...
March 3, 2020 at 3:22 pm
What is the DataType of RowId?
March 3, 2020 at 3:11 pm
I'm sure you have your reasons, but why not upgrade to 2017 or 2019?
March 3, 2020 at 3:10 pm
+1. Another big benefit is the 'free' logging that comes with putting packages into SSISDB.
And that is correct about the IS service. It does not need to be running in...
March 2, 2020 at 11:47 pm
I have never found a reasonable answer to why this is necessary.
Me neither. I never need to do this, yet use SSIS a lot.
March 2, 2020 at 7:09 pm
It seems impossible to me too. However, when I track back with TaskUID in both TaskTable and SharePoint list ,I get exactly the same record.
Are you saying that this...
March 2, 2020 at 4:09 pm
Yes, I totally agree unfortunately that is not possible to have the format changed ...
Sometimes we have to work with what we are given ....
🙂
Actually, you can cheat...
March 2, 2020 at 3:03 pm
If you are throwing away your only unique key every load, this sounds like an impossible task.
March 2, 2020 at 2:22 pm
For personal knowledge, if the string doesn't always start by XX, but also with AA or BB or CC - how can I extract the string?
Use this as your...
March 2, 2020 at 2:19 pm
You may want to consider refining the PATINDEX argument to search for the 4 digits too:
'%XX[0-9][0-9][0-9][0-9]%'
March 2, 2020 at 1:33 pm
Do you actually have a database table called dbo.PackageName?
February 28, 2020 at 6:52 pm
Please provide sample data & DDL, so that we can see more clearly what you are trying to achieve.
February 27, 2020 at 2:08 pm
Go ahead and run it. You are selecting from system tables, not data tables. This should cause no issues.
February 25, 2020 at 8:54 pm
Viewing 15 posts - 2,896 through 2,910 (of 13,855 total)