No announcements
Found 66060 threads
-
0 VotesAzure SSIS-IR exporting data to access db file failed - Microsoft.Jet.OLEDB.4.0 is not registered
I have some DTSX packages that exporting data from SQLServer to MDB file. ConnectionString to connect to MDB file Data ...Answered | 5 Replies | 2446 Views | Created by Wright Wang 0925 - Friday, August 7, 2020 8:01 AM | Last reply by Wright Wang 0925 - Thursday, August 13, 2020 3:36 AM
-
0 Votes
SSIS + OAUTH2
Hi All, Rather new to C# and integrations into SSIS. My SSIS work to date has typically been database to database. Now diving into APIs to database.... Trying to ...Proposed | 2 Replies | 5168 Views | Created by BP1985 - Wednesday, August 12, 2020 2:51 PM | Last reply by Mona Lv - Thursday, August 13, 2020 2:09 AM -
0 Votes
text file source column and dt_str
hi I'm running vs 2017 and have a target oledb destination of sql server developer 2017 and a source of text file. 3 of my columns are text and theoretically could ...Answered | 2 Replies | 2217 Views | Created by db042190 - Wednesday, August 12, 2020 12:24 PM | Last reply by Mona Lv - Thursday, August 13, 2020 1:49 AM -
1 Votes
Excel source is reading the first couple rows then everything else is reading it as NULL
Hello, I have an excel sheet that has around 50 rows and the excel source is able to read the first 40 rows correctly but everything below it is NULL in all the columns. not sure why its happening all ...Proposed | 2 Replies | 2060 Views | Created by Sam Mitch - Monday, August 3, 2020 8:23 AM | Last reply by COZYROC - Wednesday, August 12, 2020 5:30 PM -
0 Votes
"Text was truncated or one or more characters had no match in the target code page."
I have a ssis package. When I execute it, I see the following error messages. How can I solve this problems? Error: 0xC02020A1 at Data Flow Task, Flat File ...Answered | 1 Replies | 6049 Views | Created by ZZWJZG - Wednesday, August 12, 2020 5:17 AM | Last reply by Mona Lv - Wednesday, August 12, 2020 5:28 AM -
0 Votes
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.The wait operation timed out
System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out" Below is the code from the scrip task : #region Help: Introduction to ...Answered | 7 Replies | 9080 Views | Created by Harshac - Tuesday, July 28, 2020 10:48 PM | Last reply by Harshac - Tuesday, August 11, 2020 2:21 PM -
0 Votes
SSIS to handle more than 4000 characters
My source flat file has a column with characters greater than 4000 and i need this column to be processed further and output to another flat file. But SSIS has limitation of 4000 characters. How to ...Proposed | 8 Replies | 4504 Views | Created by InduTeja - Tuesday, August 4, 2020 2:38 PM | Last reply by Enric Vives - Tuesday, August 11, 2020 12:36 PM -
0 Votes
SSIS - continue loop on error
Hello, I have a SSIS report moving excel files into a SQL DB. The excel files get moved from a Input folder into an Archive folder as they get moved into the DB. ...Answered | 2 Replies | 2347 Views | Created by malibu2 - Monday, August 10, 2020 2:01 PM | Last reply by malibu2 - Tuesday, August 11, 2020 12:11 PM -
0 Votes
Handling commas ( , ) in values in CSV file in ssis ( Text qualifier )
Hi Everyone, Hope you are safe. I am working on some replication project and need to create a csv file in the same format as existing process ( OOzie) Problem : I ...Proposed | 12 Replies | 16626 Views | Created by Shaky1988 - Tuesday, August 4, 2020 7:44 PM | Last reply by Max-44 - Tuesday, August 11, 2020 10:08 AM -
0 Votes
Phantom files in SSIS loop
I have a simple SSIS job which loops through all Excel files in a folder and loads them to a table. There are always only 12 files in the folder, one for each month of the year. The month ...Proposed | 2 Replies | 1809 Views | Created by Dougie Lockhart - Tuesday, August 11, 2020 7:28 AM | Last reply by Max-44 - Tuesday, August 11, 2020 9:52 AM -
0 Votes
Passing OData Source to Power query within Data Flow
HI, I want to connect to Sharepoint Online Folder using Power Query in SSIS Data Flow. As I can not do that because of data connection problems in Power Query, I'm trying to ...Answered | 3 Replies | 2359 Views | Created by Tomislav1975 - Tuesday, August 4, 2020 11:24 PM | Last reply by Tomislav1975 - Tuesday, August 11, 2020 8:41 AM -
0 Votes
For Each Loop Container Missing "Browser" button under Collection Tab
Trying to use For Each Loop Container to loop through directory. However, I cannot link it to the directory that hold the flat files the "Browser" button is m?issing under ...Proposed | 3 Replies | 2024 Views | Created by Shabako - Monday, August 3, 2020 12:49 PM | Last reply by Mona Lv - Tuesday, August 11, 2020 8:37 AM -
0 Votes
Attach if file exists
Hi everyone, I am using script task to send an email that could have 2 attachments; File A and File B. Currently, it is sending email only when both files exists. ...Proposed | 3 Replies | 2116 Views | Created by lilutchay - Tuesday, August 4, 2020 10:57 PM | Last reply by Mona Lv - Tuesday, August 11, 2020 8:31 AM -
0 Votes
handling phone number data in SSIS
Hello, I'm trying to use conditional split to take out the numbers that are not formatted correctly, here is the expression that I have LEN([Home Phone]) == 10 ? ...Proposed | 3 Replies | 2217 Views | Created by Sam Mitch - Thursday, August 6, 2020 10:21 PM | Last reply by Mona Lv - Tuesday, August 11, 2020 8:26 AM -
0 Votes
Installation of SQL server 2016 and Visual Studio 2015
Hi, In our development server, we have SQL server 2016 installed already and we used Visual Studio 2015 to create SSIS packages. Now, I have been asked to move everything to a new ...Answered | 1 Replies | 1543 Views | Created by Manesar - Monday, August 10, 2020 11:55 AM | Last reply by Mona Lv - Tuesday, August 11, 2020 7:45 AM -
0 Votes
Unable to deploy SSIS package due to A required Prvilage not held by the client
I have an instance of SQL Server 2016 and I'm using SSDT VS 2017. I've created a simple package that loads data from a flat file source and loads it to a database. I have full administrative rights to ...Proposed | 17 Replies | 18177 Views | Created by SQL_Chris_ - Thursday, May 23, 2019 3:46 PM | Last reply by Yitzhak Khabinsky - Monday, August 10, 2020 6:51 PM -
0 Votes
How to stop at a blank row in Excel
Hi: I am importing a .xlsx into at SQL Server 2014 table. I would like to import each row with an ID and stop at the notes that are listed at the bottom. Please see ...Answered | 5 Replies | 4048 Views | Created by CKCOMPUTER - Friday, October 9, 2015 7:44 PM | Last reply by InduTeja - Monday, August 10, 2020 12:25 PM -
0 Votes
Transfer server objects only the if data is updated in the source table SSIS-package implementation
Hi, I have around 40 source table on server A. I will be using 4- TSO (Transfer Server Object) tasks,split for 10 tables each to transfer the data to server B as ...Proposed | 3 Replies | 1846 Views | Created by Jennifer Zen - Wednesday, August 5, 2020 4:22 PM | Last reply by Mona Lv - Monday, August 10, 2020 2:14 AM -
0 Votes
SSIS 2019, MSOLEDBSQL, Thread safe? Connection issue
Hi, I have a "ETL framework" built in SSIS. It has been running fine for several year, but when trying to run it on SQL Server 2019 I´m ...Proposed | 16 Replies | 5141 Views | Created by BizNisse - Tuesday, May 12, 2020 3:26 PM | Last reply by Josh Ashwood - Monday, August 10, 2020 1:11 AM -
0 Votes
SSIS Expression to handle NULLs in multiple columns
I have an OLEdb source that has some nulls, it has 50 columns and im trying to extract the rows that have NULLs to Bad data destination, the expression that I had for the conditional split ...Proposed | 3 Replies | 1857 Views | Created by Sam Mitch - Thursday, August 6, 2020 5:30 PM | Last reply by Mona Lv - Friday, August 7, 2020 9:58 AM
No announcements
