All Questions
22 questions
0
votes
1
answer
182
views
SSIS Variables as expressions to generate Start and end dates of a quarter with input year and month passed as variable
Can someone help me create SSIS expressions for variables to generate QuarterStart(DateTime) and QuarterEnd(DateTime) as a variable with year(int32) and quarter(int32) passed on as user variables.
The ...
- 5
3
votes
1
answer
7k
views
Unable to install msoledbsql despite installing the visual c++ redistributable prerequisite
I am trying to use Visual Studio 2022 to successfully load and build an SSIS package that targets SQL Server 2016. Documentation suggests that this is indeed supported. Per the online docs (https://...
- 143
1
vote
1
answer
704
views
How to create Destination table name with Getdate in SSIS OLEDB destination
How to create Destination table name with Getdate in ssis destination task.
I have one table like Test..but i want to create new table like Test_09Feb2023 in OLEDB destination.
0
votes
2
answers
629
views
SSIS package randomly fails with "WriteToServer requires an open and available Connection" error
Our SSIS package randomly fails with the following error message:
An exception has occurred during data insertion, the message returned
from the provider is: WriteToServer requires an open and ...
- 338
0
votes
1
answer
2k
views
How to make variable update for each instance of for-each loop?
I have a for-each loop that goes through a file directory. These files are transaction information from different clients. When there is an error with a file (i.e. can't be processed), the Event ...
- 101
1
vote
1
answer
650
views
SSIS 2016 conditional split with multiple columns in conditions
I am having an issue in executing a conditional split for upserting records into my production table, using SSIS 2016 and MSSQL 2016 (Standard Ed.)
I am trying to load two separate files (produced ...
- 55
2
votes
1
answer
2k
views
How to automate the changes of parameters in ssis package run by a job?
I have a job that runs a package with specific parameters as you can see on the picture below:
I want to set up those parameters (the 2 dates in yellow) to 1900-01-01 instead of 2019-02-27.
I need ...
- 16.6k
0
votes
1
answer
3k
views
Looking for solution to add double quotes in field which has commas in SSIS
I have a field called something like TYPE & the values are variant in it. I want the SSIS to export the result to CSV & while exporting, if it finds the , in column TYPE only that line/value ...
- 1
1
vote
1
answer
734
views
SSIS Installation on Dedicated Server
We are planning on installing SSIS 2016 on a new dedicated ETL server.
The packages will be called from SQL Server Agent (on a separate server), or from an application (again on a separate server).
...
- 533
3
votes
2
answers
7k
views
SSIS: Passing variable from child package to parent package
I have an SSIS project consisting of many packages, including a Main_Flow package which executes the other packages in the desired order.
The first package to be called from Main_Flow is ...
- 691
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
3
votes
3
answers
1k
views
Should I use SSIS to write programming logic?
I have come across a fairly complex system where the business logic is written in SSIS. Since SSIS is not able to perform a big portion of this logic, it is heavily dependent on C# script tasks to ...
2
votes
0
answers
113
views
SSIS - dynamically merging a group of files
I'm trying to create an import package for our new mssql database and I'm having to merge a group of 20 files together to be fed into a table on the database. However not all of those 20 files will be ...
- 173
0
votes
1
answer
2k
views
Source - ODBC is not compatible with this version of the DataFlow
After deploying an SSIS package from a development server to another environment, execution and validation of the package fail with the following error:
Error: The version of #5) Source - ODBC - ...
- 7,984
1
vote
2
answers
5k
views
Error creating package, Failed to save package file, error 0x80040154 "Class not registered"
A few colleagues & I have installed the latest Visual Studio (SSDT) - BIDS.
We are unable to create packages, in Solution Explorer right clicking on SSIS Packages > New SSIS Package results in ...
- 201
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
1
vote
1
answer
2k
views
SSIS database source imports as BLOB incorrectly
Friends,
I am a beginner user to SSIS (Microsoft SQL Server Integration Services). While I have experience coding in other languages (Python, MATLAB, R, and others), I have never experienced a ...
- 43
2
votes
2
answers
823
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