No announcements
-
52 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 | 166377 Views | Created by Phil Brammer - Monday, November 26, 2007 5:55 PM | Last reply by Zoran Ivić - Friday, November 20, 2015 12:14 PM
Found 66060 threads
-
7 Votes
Microsoft.SqlServer.Management.IntegrationServices namespace
After several tries, I am unable to find the Microsoft.SqlServer.Management.IntegrationServices.dll or the namespace stated in the title. I am trying to write a C# application that ...Answered | 43 Replies | 23108 Views | Created by Bryan Shaw - Tuesday, May 15, 2012 3:31 PM | Last reply by Davide Piras - Thursday, August 27, 2020 9:25 AM -
0 Votes
Unable to connect to Integration services
Recently rebuilt my Windows 10 machine and I am no longer able to connect to Integration Services from SSMS when I was able to before. The error message I'm getting is the specified service does not ...Proposed | 34 Replies | 8642 Views | Created by JamesTJC - Friday, July 24, 2020 7:06 PM | Last reply by - Wednesday, August 26, 2020 7:31 PM -
9 Votes
SSIS package Just fails...not compatible with this version of the DataFlow?
Executed as user: x ...0.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:27:08 AM Error: 2013-01-09 ...Answered | 19 Replies | 20663 Views | Created by justin1681 - Wednesday, January 9, 2013 5:39 PM | Last reply by Ashwin Y - Tuesday, August 25, 2020 6:19 PM -
0 Votes
Keeping Dynamic DateTime Variable "Static"
In one step of an SSIS package, i create an outgoing XLS filename based on the current datetime setting, a la: "myFileName_" + (DT_WSTR,4)YEAR( ...Unanswered | 5 Replies | 9674 Views | Created by SethHersh - Saturday, April 28, 2007 2:20 PM | Last reply by Laxmidhar sahoo - Tuesday, August 25, 2020 9:19 AM -
0 Votes
Value cannot be null. Parameter name: value (mscorlib)
Hello, I'll try to start PowerShell for Integration services Catalog and i'll get this error ...Answered | 2 Replies | 6466 Views | Created by Adghar - Monday, March 30, 2020 12:35 PM | Last reply by Koen Verbeeck - Tuesday, August 25, 2020 7:01 AM -
0 Votes
[SharePoint List Source [296]] Error: Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException: The value is too large to fit in the column data area of the buffer.
I have a running package which reads data from SharePoint List and dumps into SQL tables. I have 3 new list columns which I want to update into SQL table. 1) I opened ...Proposed | 8 Replies | 5627 Views | Created by ShahidAliK - Monday, August 10, 2020 12:02 PM | Last reply by ShahidAliK - Monday, August 24, 2020 9:46 AM -
0 Votes
how to find out that SSIS Installed in SQLServer Using C#?
i'm writing a windows form application using C# . i use ssisServer = new IntegrationServices(ssisConnection); To run and working with SSIS ...Answered | 5 Replies | 5919 Views | Created by Shahram_Soft - Sunday, August 9, 2020 7:34 AM | Last reply by Shahram_Soft - Monday, August 24, 2020 8:22 AM -
0 Votes
Changing a datatype for a column in an odata datasource
Hi, I'm trying to import an odata datastream via an OData Source component. The datastream contains a column with decimals in it (like 0.42). The OData Source component defines this ...Proposed | 11 Replies | 5803 Views | Created by Peter de Hoog - Wednesday, September 4, 2019 1:53 PM | Last reply by MSBIASRA - Friday, August 21, 2020 11:42 AM -
0 Votes
Error: Microsoft.jet.oledb.4.0 not registered on local machine when running the package from SQL Job
Hi. I am using Windows Server 2016. I have created a SSIS package in Visual studio which loads data from Excel and moves to SQL table ( script task functionality using c# ...Answered | 6 Replies | 5355 Views | Created by Venkatzeus - Monday, August 10, 2020 3:39 PM | Last reply by Venkatzeus - Thursday, August 20, 2020 6:59 AM -
0 Votes
Weird error - while SSIS package execution.
Hi , We are running packages using sql agent and using service account. Few packages failed daily with these error messages. But we have logic in again job ...Proposed | 5 Replies | 4320 Views | Created by SR_MCTS - Saturday, August 15, 2020 12:04 PM | Last reply by Mona Lv - Thursday, August 20, 2020 6:34 AM -
0 Votes
Identify and move the files to different folder using file owner name.
Hi , I have on FTP folder where we received CSV files every day. Now there are few files with some different different owners name. For example we have 3 files ...Proposed | 4 Replies | 4451 Views | Created by SR_MCTS - Saturday, August 15, 2020 8:07 AM | Last reply by Yitzhak Khabinsky - Monday, August 17, 2020 2:46 PM -
0 Votes
Recommended best practice for indexes during loading of data
Hello, I have an SSIS package that reads incremental data from salesforce and loads into the database tables. No major transformation is being done. The incremental load has an ...Proposed | 5 Replies | 4585 Views | Created by doineedanid - Friday, August 14, 2020 4:47 PM | Last reply by Mona Lv - Monday, August 17, 2020 6:39 AM -
0 Votes
Version Exception on C# Script Task
We are getting the following error when attempting to schedule and run a SSIS Package on our Production Job Server. Source: Script Task - C# To Determine File Size for Control File ...Proposed | 2 Replies | 4611 Views | Created by ITBobbyP - Saturday, August 15, 2020 9:49 AM | Last reply by Mona Lv - Monday, August 17, 2020 2:18 AM -
0 Votes
Connect SharePoint List view to SSMS
Hi , I need your help to install SSIS/SSRS in SSMS I have connected the SharePoint list view to excel for reporting purpose but due to data size ...Answered | 5 Replies | 10318 Views | Created by 5Ant - Monday, August 31, 2015 2:53 PM | Last reply by Mirch - Friday, August 14, 2020 2:19 PM -
0 Votes
How to remove Footer content in Excel file and load the file
Hi All, I have a requirement to remove header and the footer content in the excel and load the excel to a flat file. I was able to remove header by adding the ...Proposed | 3 Replies | 5229 Views | Created by InduTeja - Monday, August 10, 2020 12:03 PM | Last reply by Mona Lv - Friday, August 14, 2020 8:21 AM -
0 Votes
Issue is getting leading 0 in values
I am importing data from excel to SQL Server 2016 using SSIS. Field is Latitude & Longitude I am using formula (DT_STR,255,1252)((DT_NUMERIC,9,6)(Latitude)) to import the values ...Proposed | 6 Replies | 5601 Views | Created by Nitin Kumar Goyal - Monday, August 10, 2020 7:30 AM | Last reply by Mona Lv - Friday, August 14, 2020 8:19 AM -
0 Votes
Does anyone have experience of using securetrading.net as a data source within SSIS
Hi, Does anyone have experience of using securetrading.net as a data source within SSIS ? If so I would greatly appreciate your help. Kind ...Proposed | 4 Replies | 4515 Views | Created by Kieran Patrick Wood - Friday, August 7, 2020 11:35 AM | Last reply by Mona Lv - Friday, August 14, 2020 8:15 AM -
0 Votes
Large CSV file load into SQL Columnstore table Random Error , After restart same SSIS works fine
Sequence Container > DFL Transactions. SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft ...Proposed | 3 Replies | 4814 Views | Created by Bmk7 - Thursday, August 13, 2020 8:20 AM | Last reply by Mona Lv - Friday, August 14, 2020 6:03 AM -
0 Votes
SQL Agent job throws error Microsoft.ScriptTask. The parameter is incorrect
Hi, I get error while running the SQL Agent job which executes SSIS package. The SSIS package job runs well when we run in VS manually, but throws error from SQL agent. ...Answered | 12 Replies | 7678 Views | Created by Prasant Nanda - Monday, August 3, 2020 10:51 AM | Last reply by Prasant Nanda - Thursday, August 13, 2020 5:04 PM -
3 Votes
Installing SSIS with Visual Studio 2019/SQL Server 2019
Hello! I used to install/use SSIS as part of SQL Server Data Tools but according to MS "With Visual Studio 2019, the required functionality to enable Analysis ...Answered | 8 Replies | 60018 Views | Created by MF47 - Friday, July 12, 2019 7:39 AM | Last reply by Naomi N - Thursday, August 13, 2020 2:06 PM - Items 1 to 20 of 66060 Next ›
No announcements
