Viewing 15 posts - 2,926 through 2,940 (of 13,879 total)
I have a developer who want's to run sql agent jobs as temporarily. Like create the sql agent job dynamically, run (job is very simple) and when the job...
March 3, 2020 at 8:18 pm
Since SQL Server 2016, single package deployment to SSISDB has been possible.
What you choose to push to GitHub is entirely under your control, on a file-by-file basis, as long as...
March 3, 2020 at 5:06 pm
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
Viewing 15 posts - 2,926 through 2,940 (of 13,879 total)