Viewing 15 posts - 1 through 15 (of 76 total)
No, it's not a failover issue. The AG is set to manual failover and has not been failed over between the job fail events. The job/package is running consistently from...
March 20, 2024 at 9:07 am
This script works perfectly for recreating existing environments.
Is there a similar script that can automate or script out the mapping of package parameters to the environment variables?
October 14, 2022 at 8:43 am
We only have one server with one catalogue.
We use it to override settings that may come from deployments. New project -> Configure -> Link to environment. You...
August 17, 2022 at 2:54 pm
We only have one server with one catalogue.
We use it to override settings that may come from deployments. New project -> Configure -> Link to environment. You may not...
August 16, 2022 at 2:45 pm
To handle the scenario where additional charge columns could be added to the table, "charge6, charge7" etc, you could do the below to dynamically unpivot any columns that match your...
August 10, 2022 at 2:18 pm
The reference table makes little sense because as I understand it, each row represents a target table. You can't really feed that into a single Dataflow because each table will...
August 9, 2022 at 1:10 pm
I don't really understand what this reference table is doing.
To load the files, can't you have 2 x ForEach Loops, with their collections set to each set of files (wildcard...
August 8, 2022 at 1:25 pm
It may also make the impact on the log file much greater because anything after the first insert will be more than what "Minimally Logging" would impart.
Hi Jeff,
Can you...
August 8, 2022 at 8:02 am
If it is in a for each loop, you can make it try again on failure.
There are instructions here: https://www.mssqltips.com/sqlservertip/3575/continue-a-foreach-loop-after-an-error-in-a-sql-server-integration-services-package/
The key points are:
July 25, 2022 at 8:24 am
I've just changed my staging folder parameter to point at my local C drive and so far it hasn't failed once even with me removing the wait script command.
Definitely looking...
July 22, 2022 at 3:07 pm
The error always occurs in the Excel Data Source at the start of the data flow. Only ever there, but which file it fails on is random. Often it will...
July 22, 2022 at 1:18 pm
No, the script that puts the file into the folder from which the data flow loads it is simply testing for a folder existence, creating a folder if not present,...
July 22, 2022 at 1:02 pm
Does it with a 10 second delay.
July 22, 2022 at 12:53 pm
Oh wait, I think I only paused for 5ms and not 5secs. Will test again.
July 22, 2022 at 12:50 pm
The file is moved from an input to a staging folder
A Data Flow (the bit that randomly fails) the reads the file into SQL
The file is then moved from staging...
July 22, 2022 at 12:48 pm
Viewing 15 posts - 1 through 15 (of 76 total)