SQL Server Integration Services (SSIS)

Options
1,251
Chunhua on 07-22-2020 08:33 AM
11.1K
Chunhua on 05-24-2020 05:08 PM
1,813
Chunhua on 05-11-2020 11:22 PM
2,062
Sandy Winarko on 12-31-2019 06:09 PM
2,511
Sandy Winarko on 12-12-2019 01:58 AM
3,983
Chunhua on 12-05-2019 04:21 PM
2,222
Chunhua on 11-25-2019 12:33 AM
3,290
xichen on 10-29-2019 08:40 PM
2,877
Lingxi on 08-29-2019 10:23 PM
3,556
Jarod_Zhu on 08-08-2019 11:31 PM
2,817
qianwen_shi on 08-06-2019 02:23 AM
15.9K
Tim.Chen on 05-14-2019 01:19 AM
3,251
Sandy Winarko on 03-25-2019 04:11 PM
1,559
SSIS-Team on 03-25-2019 04:10 PM
4,486
Sandy Winarko on 03-25-2019 04:09 PM
2,193
Sandy Winarko on 03-25-2019 04:08 PM
1,935
SSIS-Team on 03-25-2019 04:08 PM
1,054
SSIS-Team on 03-25-2019 04:08 PM
4,125
SSIS-Team on 03-25-2019 04:08 PM
1,005
SSIS-Team on 03-25-2019 04:08 PM

Latest Comments

Hi @lb1l4l1, It's a current limitation that you cannot select view under the "Name of the table or the view:". We have plan to fix it. Currently you can use SQL command or go to Advanced Editor =>Component Properties and set the view name in 'TableName' field directly as the workarounds. For the var...
0 Likes
Issue when trying to use a view as sourceViews are not listed under Oracle source "Name of the table or the view:" but the package works fine if you use the SQL command and do a select * from view or when view name is set to property [Oracle Source].[TableName]
0 Likes
Hi, @simee5 It is a limitation now that the error table can only be created in the user database. It does not recognize the [schema].[tablename] format. We will provide a fix for it.
0 Likes
I have another problem with this.I have to transfere a lot of data from TERADATA to SQL SERVER 2019 to use columnstore index. My TERADATA server is overload. SQL Server 2019 in Windows Cluster. Microsoft SQL Server 2019 (RTM-CU5) (KB4552255) - 15.0.4043.16 (X64) Enterprise Edition: Core-based Licens...
0 Likes
Hi, I have visual studio 2019, TTU 16.20, and Microsoft Connector 1.0. I was able to use the Microsoft connector to pull data out of the Teradata and write to another database successfully. I can find the TD table I want to write to, in the Teradata Destination. However, I'm having issues now attemp...
0 Likes