All Questions
7 questions
7
votes
1
answer
17k
views
Problems Exporting Long Columns to Flat File Using SSIS
We have an SSIS package that is going to generate files to be consumed by Google Big Query. The files will be gzipped .tsv files.
One of the requirements is that the file be UTF-8. We have set this ...
- 971
1
vote
1
answer
149
views
SSIS - sp logs counters in debug mode but not from agent job
Within an SSIS project I have a number of usp's that I execute to store row counters, like extracted row count, inserted row count, etc., during an ETL process.
My SSIS project is setup to run via an ...
- 382
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
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
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
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