All Questions
5 questions with no upvoted or accepted answers
3
votes
0
answers
1k
views
Specified initialization vector (IV) does not match the block size for this algorithm
I built an SSIS project on "test" server, and deployed the project across to "live" server. The project has property ProtectionLevel set to EncryptSensitiveWithPassword. Everything deployed ...
- 382
2
votes
2
answers
826
views
SSIS upsert from CSV File Source
I'm trying to determine the most effect way to do an upsert in SSIS with CSV source 100+ columns
1 x CSV Source (loop through multiple CSVs same structure 100 + columns)
1 x Staging Table Destination
...
- 679
1
vote
0
answers
7k
views
SSIS execution timeout expired
Recently I started to get this error from time to time on my nightly SSIS jobs:
Message
Executed as user: "my user name". Microsoft (R) SQL Server Execute Package Utility Version 13.0.1601.5 for ...
1
vote
0
answers
7k
views
Fault Finding SSIS "Unexpected Termination" - SQL Server 2016
I have been getting an "Unexpected Termination" error from time to time on a bunch of SSIS jobs that I am running on a SQL Server 2016 instance (Microsoft SQL Server 2016 (RTM-CU2) (KB3182270) - 13.0....
- 131
0
votes
1
answer
1k
views
Best way to automate the loading of data daily into google big query from SQL Server
Best way to load/copy/insert data from a SQL Server database into a table in Google Big Query on a daily schedule.
I.E data from a table in a SQL Server database to a table in Google Big Query
I ...
- 679