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
0
votes
1 answer
Visual Studio 2017 SSDT add reference to script
I am new using SSIS and want to create a script to connect to a Mongo DB, for this purpose I am trying to add a reference to a MongoDB driver as explained here
Unfortunately I don't see a way to do so, in the solution explorer, there is no Reference…
DanielV
- 2,076
- 2
- 40
- 61
0
votes
1 answer
SSIS Download the files using FTP Task inside the For Each loop by passing the Variable Enumerator
Download the files using FTP Task inside the For Each loop by passing the Variable Enumerator to set the Remote Path Variable
I am loading the list of files to download in a variable.( Verified and I can see the list of files)
Using the ForEach…
Iyyappan Amirthalingam
- 194
- 1
- 9
0
votes
1 answer
SSIS Package- Retain Same Connection Property in Excel Connection
I am using SSDT 2017. There are 3 Dataflow tasks (They are connected using precedence constraints) which loads data from Excel into Database tables. When I run each task individually it is showing as success but when I run the entire package it is…
Srikar mogaliraju
- 215
- 1
- 10
0
votes
0 answers
SSIS: "SQLISPackage140 cannot be found"
I'm trying to run SSIS Package that Connect to Oracle via ODP.NET Managed Driver
I use following components:
Visual Studio 2017 (15.9.5)
SSDT 2017 (15.8.0)
ODAC-32 Bit + ODAC-64 Bit (12.2.0.1.1)
While running Locally (on VS) I get the…
Refael
- 6,753
- 9
- 35
- 54
0
votes
2 answers
How to Rollback Transaction SSIS without MSDTC?
1st .)
I have a Sequence container.
It has 4 different execute sql tasks and 4 different DFT where data is inserting into different tables .
I want to implement transaction with or without MSDTC service on the package failure i.e., each and every…
Jaideb Mandal
- 1
- 1
0
votes
0 answers
How can I use SSIS to copy data from 1000 tables in a CRM to access?
I think I can use a for each container for doing this. There are multiple examples for SQL servers but not for other types. Can anyone suggest me how to do this in SSIS? (CRM doesn't have SQL database).
Sahil Tiwari
- 159
- 2
- 12
0
votes
0 answers
How can I move all tables from ODBC source to Access via SSIS?
I have a CRM consisting of 1200 tables and I want to move them into Access Database using SSIS. Please note that I have no tables existing in Access Database. What is the most efficient way for doing this?
I know we can do this by Access Wizard for…
Sahil Tiwari
- 159
- 2
- 12
0
votes
2 answers
How can we combine more than 2 connectors in SSIS?
I am very new to SSIS. I have a task of taking data from ODBC source A, then transport that data to access, thereafter to SQL. I believe SSIS can do this task. However, according to various examples I have seen, they use a single source and…
Sahil Tiwari
- 159
- 2
- 12
0
votes
0 answers
Package deployed in azure sql server fails as it cant access remote excel file
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.
I have deployed my SSIS project & package in Azure sql…
Sharan G
- 55
- 7
-1
votes
1 answer
Date Conversion fails in C# via Parameter adding (SqlDbType.DateTime)
I am new to C#. I have this statement that fails:
dbCmd.Parameters.Add("@createdTime", SqlDbType.DateTime);
The value in the createdTime is: 1/18/2012 11:54:11 AM
After a lot of troubleshooting I was able to narrow down the issue. It will work IF I…
VisualSQL
- 33
- 5
-1
votes
1 answer
SSIS packages behaving differently between environments
We have an SSIS package that imports data from Excel and updates a SQL table.
On the live environment we can run via Visual Studio 2010 (the version bundled with SQL 2012) before deploying to the SSIS catalogue to run automatically
Our development…
Webbo
- 92
- 7