No announcements
-
50 VotesFAQ - SSIS Information, Webcasts, Tools, Add-ons, etc...
To add to the list, simply contact one of the moderators around here, or post a reply to this thread. Microsoft Reference Material SQL ...Sticky | 39 Replies | 144798 Views | Created by Phil Brammer - Monday, November 26, 2007 5:55 PM | Last reply by Zoran Ivić - Friday, November 20, 2015 12:14 PM
-
0 Votes
Yet another problem doing the Deployment Tutorial!
I am tring to do the SSIS Tutorial on Deployment. I have the following problem: On the Data Flow diagram the OLEDB Destination has an ... -
0 Votes
Visual Studio 2017 SSIS Package - Excel Source Generating Error at Data Flow Task 1 - No column information returned by SQL command
I'm using an SSIS package (MS Visual Studio 2017) to import an Excel spreadsheet (97-2003 Workbook) into a table (SQL Server Management Studio 2017). The import needs to skip over the first four rows ...Proposed | 11 Replies | 323 Views | Created by SutterKaine - Friday, August 9, 2019 3:40 AM | Last reply by Yitzhak Khabinsky - 1 hour 1 minutes ago -
0 Votes
SSIS connecting ole db driver Oracle 11g but not Oracle 12c
On my system, Oracle 11g and Oracle 12c are installed. When i try to create a connection using "Oracle provider for ole db" it is picking up 11g thru SSIS. How do I change to Oracle 12c? My ...Unanswered | 3 Replies | 97 Views | Created by kdinuk - 10 hours 17 minutes ago | Last reply by ArthurZ - 2 hours 0 minutes ago -
0 Votes
SSIS Azure Flexible file destination - Java OutOfMemory
I have a pretty big file to off load in a parquet format How to overcame that error Microsoft.DataTransfer.Common.Shared.HybridDeliveryException: An error occurred when invoking ...Unanswered | 2 Replies | 55 Views | Created by DMIM - 4 hours 15 minutes ago | Last reply by ArthurZ - 2 hours 4 minutes ago -
1 Votes
Using SSIS :What is better between using REST API or querying a database directly?
I am working on creating a data warehouse for a client. To extract data, I can use : Direct T-SQL queries to the production ...Unanswered | 1 Replies | 32 Views | Created by Test test tes - 2 hours 45 minutes ago | Last reply by ArthurZ - 2 hours 6 minutes ago -
0 Votes
api rest
Hallo everyone , i need to get infromation from a website (i have a Url from the Rest API) and to enrigester there in a file (txt or exel ) can someone Help ...Unanswered | 1 Replies | 38 Views | Created by Hedibn - 2 hours 44 minutes ago | Last reply by ArthurZ - 2 hours 25 minutes ago -
0 Votes
Import geography and geometry data from a csv file to a table
Hi, I have a csv file with fields( Id,stnumber,stname,latitude,longitude,se_east,se_north,street_area,street_lenght) I need to import the data into a table, ...Unanswered | 4 Replies | 113 Views | Created by Jennifer Zen - 17 hours 19 minutes ago | Last reply by Jennifer Zen - 3 hours 56 minutes ago -
0 Votes
Stored Procedure Extract from SSIS job not completing
Hi, We recently upgraded from SQL server instance from 2008 to 2016 and also upgraded the SSIS jobs accordingly. One of the SSIS job is executing a stored procedure to create an ...Unanswered | 3 Replies | 94 Views | Created by pnbalaji - 19 hours 36 minutes ago | Last reply by Mona Lv - 9 hours 36 minutes ago -
0 Votes
how to add variables in package
Hi, I want to add some variables to the package. I know how to add it in the SSIS menu. Is there any other way, such as using code? Any helpful information ...Answered | 1 Replies | 339 Views | Created by joy_SSISNEW - 12 hours 43 minutes ago | Last reply by Zoe Ku - 12 hours 10 minutes ago -
0 Votes
Another question about the Deploy Packages with SSIS
This is the Properties to export on my copy of SSDT, has it changed since this was written? When you click on Data Transfer, all the boxes are checked? Do ...Answered | 6 Replies | 131 Views | Created by Rocky48 - Wednesday, August 21, 2019 4:50 PM | Last reply by Mona Lv - 12 hours 48 minutes ago -
0 Votes
Access Dynamics CRM via SSIS OData: estimatedclosedate null
Hi all, I'm developing a SSIS solution to import Opportunities data to a OLAP Cube via SQL 2016 SSIS new Odata for Dynamics CRM ...Unanswered | 6 Replies | 786 Views | Created by Ivan Arribas - Wednesday, October 18, 2017 8:54 AM | Last reply by MarcenfaaMym - 14 hours 22 minutes ago -
0 Votes
SSIS export to Excel 2016 fails
I have two SSIS packages that are exactly the same except for the data being exported. Both run manually in Visual Studio 2017\SSDT 15.1.61901.24070. One of them runs just fine in a SQL 2014 Agent ...Proposed | 15 Replies | 251 Views | Created by Lori Halsey - Monday, August 19, 2019 9:58 PM | Last reply by Yitzhak Khabinsky - 17 hours 30 minutes ago -
3 Votes
SSIS Failed When reading XLSB File and works fine with XLSX File.
Hi, I have a SSIS package that executes from C# Code. the objective is to upload the data from xlsx or xlsb file to DB tables. When I use xlsx file, The ssis runs ...Answered | 6 Replies | 2278 Views | Created by VIJAYAMANIKANDAN - Monday, November 17, 2014 4:21 PM | Last reply by TylerExact - Thursday, August 22, 2019 2:40 PM -
0 Votes
ORACLE TO SQL SERVER DATA ISSUE USING SSIS
hI aLL, i am using oracle as source and the column name is arabic_name datatype in oraclae is varchar2(50),here in oracle basically the data is some rows in arabic and some rows in ...Proposed | 32 Replies | 1036 Views | Created by ds_999 - Monday, July 23, 2018 6:48 AM | Last reply by Azhar Iqbal Gondal - Thursday, August 22, 2019 9:20 AM -
7 Votes
Exception deserializing the package "Value does not fall within the expected range.
Visual Studio 2015 Integration Services Whenever I try to Execute a package I get the error below. The connection managers all look good and I can preview any dataset that I am ...Proposed | 17 Replies | 11280 Views | Created by Mike JY Wood - Thursday, February 22, 2018 11:37 PM | Last reply by DarrenQuadros - Thursday, August 22, 2019 8:21 AM -
0 Votes
Problems using SSIS to transfer data to Excel Template
Hi, I’m currently trying to use SSIS to export data into an Excel Template. Once the data is there, I need to format it and add formulas to certain rows using a ...Proposed | 5 Replies | 161 Views | Created by Cash Depot - Tuesday, August 20, 2019 2:56 PM | Last reply by Mona Lv - Thursday, August 22, 2019 8:15 AM -
0 Votes
Error testing Lesson 2 SSIS Tutorial
I am working through the SSIS Tutorial and have got an error when trying to test Lesson ...Proposed | 9 Replies | 261 Views | Created by Rocky48 - Monday, August 19, 2019 3:19 PM | Last reply by Mona Lv - Thursday, August 22, 2019 8:02 AM -
1 Votes
Creating a reference to Microsoft.Office.Interop.Excel for SSIS 2008 Script Task C#
I have to uses SSIS 2008 and working with excel docs. I have tried to add a reference to Microsoft.Office.Interop.Excel (inside my script task) that is on my Windows 10 ...Answered | 1 Replies | 60 Views | Created by LlewellynE - Thursday, August 22, 2019 3:11 AM | Last reply by Mona Lv - Thursday, August 22, 2019 7:03 AM -
0 Votes
WEB SERVICE IN SSIS
I have a web service that I need to get data from. This web service returns a json format data. I have tried using the web service task but I discovered it works only with web service that returns an ...Proposed | 4 Replies | 109 Views | Created by Hemkay - Wednesday, August 21, 2019 11:50 AM | Last reply by Zoe Ku - Thursday, August 22, 2019 2:16 AM -
0 Votes
Searching error in Script Component SSIS
Hi, I'm using a script Component to generate a new column in my table. I want to check if the "contactID" is in the "contact" table and generate a ...Proposed | 2 Replies | 109 Views | Created by NyNava - Wednesday, August 21, 2019 7:28 AM | Last reply by ArthurZ - Wednesday, August 21, 2019 2:54 PM - Items 1 to 20 of 64806 Next ›
No announcements
