Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2017 is a part of SQL Server 2017 Data Tools
Questions tagged [ssis-2017]
116 questions
7
votes
2 answers
migrating ssdt project from visual studio 2012 to 2017 cdc source not opening
We migrated packages from Visual Studio 2012 to 2017
There is no cdc source component in the ssis toolbox:
and the cdc source component looks like:
And cannot be opened as well.
If I create a new Visual Studio 2017 Project it has the cdc source…
dangalg
- 6,398
- 4
- 27
- 37
6
votes
2 answers
How to make SSIS package dynamically choose the desired connection manager?
I have an SSIS package with a OLE DB connection manager to 'SQL Server 1', as well as flat file managers that come from the D disk of the local machine.
The package basically retrieves data from the D disk of the machine I am using, and through a…
BI_noob
- 71
- 1
- 1
- 4
4
votes
1 answer
Display foreach loop iteration number in SSIS
I need to keep a check on the iteration number for a foreach loop container task that I am running in Visual Studio 2017. How could I achieve this ?
stark
- 2,246
- 2
- 23
- 35
4
votes
1 answer
SSIS OnPostExecute event: How to see the execution result?
I log SQL task activity to my own table using OnPreExecute and OnPostExecute which works fine. Here is the OnPreExecute code:
declare @audit_key int = ?
declare @package_name varchar(100) = ?
declare @task_name varchar(100) = ?
insert into…
DingoCC
- 159
- 1
- 2
- 12
3
votes
2 answers
Read file in SSIS Project into a variable
My SSIS projects tend to run queries that require changes as they move between environments, like the table schema might change or a value in the Where clause. I've always either put my SQL into a Project Parameter, which is hard to edit since…
Sam Alex
- 79
- 2
- 11
3
votes
2 answers
Replace Script Task In Multiple SSIS Packages
Custom Script Task Needs Replacing In Many SSIS Packages.
We can do it manually, but there is 170 packages, need to automate.
Code works so no issues.
When manually replaced, script task shows no errors.
Hello, I have about 170 packages in SSIS. I…
DrDuran
- 101
- 1
- 3
- 12
3
votes
1 answer
Error creating a New SSIS Project with Visual Studio 2017 Community
I need to create a SSIS project on VS2017 to build some ETL's. I just installed the SQL Server Data Tools from this link:
Download and install SQL Server Data Tools (SSDT) for Visual Studio
It explains everything, but I'm still getting this…
Fex09
- 73
- 9
3
votes
1 answer
SSIS 2017 OData source - Sharepoint 2016 $expand
Unable to select expanded properties of an expanded type, when using a query with $expand operator.
Sharepoint 2016 list contains a 'Person or Group' field (column=Client), when querying the list:
SSIS 2017 Odata…
Strig
- 43
- 5
3
votes
1 answer
Struggling with visual studio 2017 and ssis
I am using Visual Studio 2017 professional latest update and latest update of ssdt. Now I struggle very much with the Developer environment.
In my vs solution I have 2 SQL projects,1 SSIS project and 1 SSAS tabular. When I open the solution I can’t…
Geir Forsmo
- 149
- 2
- 11
3
votes
1 answer
How to manage SSIS script component output columns and its properties programmatically
I am developing a source in SSIS VS 2017 which calls REST API using script Component and serialises JSON and provides records which I am storing in SQL Table.
While designing I need add output columns which are 200+ manually and set properties like…
user11060917
- 37
- 1
- 8
3
votes
1 answer
Detect new column in source not mapped to destination and fail in SSIS
How can I cause an SSIS 2017 package to fail if a column in the source table does not have a corresponding column in the destination table, or at least a deliberate decision to not include it?
I made a table in both called test with one column,…
ADataGMan
- 449
- 1
- 7
- 23
3
votes
1 answer
Parsing XML file with Inline schema using XML Source in SSIS
I have a XML file that contain inline schema. I try to use SSIS XML Source. But it does not show the column names.
Selecting XML file
there are no Columns listed here.
I want to transfer XML data to SQL Server.
This is the sample data from the XML…
user10987050
- 75
- 10
3
votes
1 answer
Unable to connect to Odata source v4 and v2 in SSIS
Objective:
Connect Odata Source in SSIS to Medicare data
When tried Odata v4 endpoint:
Get "Test connection Failed" when creating Connection Manager.
Confirmed endpoint works in Tableau desktop connection
When tried Odata v2 endpoint:
Get…
Vinh Ton
- 107
- 3
- 10
3
votes
1 answer
SSIS Upgrade Wizard gone in Visual Studio 2017
My company has started a project of upgrading from SQL Server 2008 R2 to 2017. My team is responsible for migrating about 70 SSIS project, some SSRS and SSAS.
I know that SSIS development in Visual Studio 2017 is quite new, since the SQL Server…
Ruben Ravnå
- 659
- 7
- 17
2
votes
1 answer
SSIS OLE DB Destination Editor - Create New Table not an option?
I am trying to have upload a CSV file to my SQL Server via SSIS. Previously- like a few months ago- I was able to click 'New' on the destination editor to create a generic table based on the imported data. Is that option no longer available for some…
mlf
- 41
- 4