Viewing 15 posts - 1 through 15 (of 72 total)
I always make sure the AD account for the SQL Server Agent Account has "Full Control" of the Directory where the file is located.
November 28, 2019 at 4:45 pm
Adaptris have a very useful product called Interlok. If you have a situation where you must collect data from numerous clients, Interlok handles this very well. It spins the design...
November 28, 2019 at 4:37 pm
Set up your connection manager with column headers. In your data flow task add a Row Count as the first transform in the data flow and store the count in...
October 14, 2019 at 3:13 pm
A stab in the dark, but this sounds similar to an issue I had using the Project Deployment Model. A new server had been created installed with SQL 16, however...
September 16, 2019 at 3:17 pm
Have you checked your current SQL Server Log to see if SPN (Service Principle Name) was successfully registered the last time the SQL Service was started? This is crucial for...
September 16, 2019 at 2:59 pm
You might want to try running the package in 32bit mode. It depends if the ACE drivers installed on the server are 32bit or 64bit.
September 9, 2019 at 10:07 am
Thanks' for the info Sue, it's been a while since I looked at Service Account permissions.
July 22, 2019 at 9:40 am
I found the problem. About a week ago the SQL Services failed to start. The server in question uses the default SQL service accounts and someone updated a Group Policy...
July 19, 2019 at 3:32 pm
I set the FailParentOnFailure property to True for the Execeute SQL Task, it made no difference.
I also subsequently tried FailPackageOnFailure = True and that also made no difference. In Both...
July 19, 2019 at 2:52 pm
I am using an SQL Agent Job that I am running manually during the testing stages. I have used SSIS for years and never had this problem before. 2 other...
July 19, 2019 at 12:54 pm
No I checked that, the tasks ForceExecutionResult property is set to None. It's not something I ever change.
July 18, 2019 at 11:07 am
Are the connections to the Oracle database set to use a Windows AD Account or a Database User Name and Password?
If using the later what protection level is set for...
April 23, 2019 at 3:36 pm
Yes as Phil said set the Project and each package to Don't save sensitive.
I personally use 2 solutions. A development solution with 1 Visual Studio Configuration and a Release solution...
April 10, 2019 at 1:21 pm
Use a For Each Loop on the E records to control what is returned for the W records and then the B records in separate Data Flow Tasks inside the...
January 23, 2019 at 9:22 am
November 30, 2018 at 4:21 am