Duyuru yok
-
52 OylarFAQ - 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 ...Yapışkan | 39 Yanıtlar | 164986 Görünümler | Created by Phil Brammer - 26 Kasım 2007 Pazartesi 17:55 | Son Yanıt ile Zoran Ivić - 20 Kasım 2015 Cuma 12:14
Found 66062 threads
-
7 Oylar
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 ...Yanıt | 43 Yanıtlar | 22267 Görünümler | Created by Bryan Shaw - 15 Mayıs 2012 Salı 15:31 | Son Yanıt ile Davide Piras - 27 Ağustos 2020 Perşembe 09:25 -
0 Oylar
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 ...Önerilen Yanıt | 34 Yanıtlar | 7990 Görünümler | Created by JamesTJC - 24 Temmuz 2020 Cuma 19:06 | Son Yanıt ile - 26 Ağustos 2020 Çarşamba 19:31 -
9 Oylar
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 ...Yanıt | 19 Yanıtlar | 19990 Görünümler | Created by justin1681 - 9 Ocak 2013 Çarşamba 17:39 | Son Yanıt ile Ashwin Y - 25 Ağustos 2020 Salı 18:19 -
0 Oylar
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( ...Soru | 5 Yanıtlar | 9117 Görünümler | Created by SethHersh - 28 Nisan 2007 Cumartesi 14:20 | Son Yanıt ile Laxmidhar sahoo - 25 Ağustos 2020 Salı 09:19 -
0 Oylar
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 ...Yanıt | 2 Yanıtlar | 5589 Görünümler | Created by Adghar - 30 Mart 2020 Pazartesi 12:35 | Son Yanıt ile Koen Verbeeck - 25 Ağustos 2020 Salı 07:01 -
0 Oylar
[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 ...Önerilen Yanıt | 8 Yanıtlar | 4986 Görünümler | Created by ShahidAliK - 10 Ağustos 2020 Pazartesi 12:02 | Son Yanıt ile ShahidAliK - 24 Ağustos 2020 Pazartesi 09:46 -
0 Oylar
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 ...Yanıt | 5 Yanıtlar | 5226 Görünümler | Created by Shahram_Soft - 9 Ağustos 2020 Pazar 07:34 | Son Yanıt ile Shahram_Soft - 24 Ağustos 2020 Pazartesi 08:22 -
0 Oylar
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 ...Önerilen Yanıt | 11 Yanıtlar | 5233 Görünümler | Created by Peter de Hoog - 4 Eylül 2019 Çarşamba 13:53 | Son Yanıt ile MSBIASRA - 21 Ağustos 2020 Cuma 11:42 -
0 Oylar
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# ...Yanıt | 6 Yanıtlar | 4824 Görünümler | Created by Venkatzeus - 10 Ağustos 2020 Pazartesi 15:39 | Son Yanıt ile Venkatzeus - 20 Ağustos 2020 Perşembe 06:59 -
0 Oylar
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 ...Önerilen Yanıt | 5 Yanıtlar | 3734 Görünümler | Created by SR_MCTS - 15 Ağustos 2020 Cumartesi 12:04 | Son Yanıt ile Mona Lv - 20 Ağustos 2020 Perşembe 06:34 -
0 Oylar
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 ...Önerilen Yanıt | 4 Yanıtlar | 3987 Görünümler | Created by SR_MCTS - 15 Ağustos 2020 Cumartesi 08:07 | Son Yanıt ile Yitzhak Khabinsky - 17 Ağustos 2020 Pazartesi 14:46 -
0 Oylar
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 ...Önerilen Yanıt | 5 Yanıtlar | 4042 Görünümler | Created by doineedanid - 14 Ağustos 2020 Cuma 16:47 | Son Yanıt ile Mona Lv - 17 Ağustos 2020 Pazartesi 06:39 -
0 Oylar
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 ...Önerilen Yanıt | 2 Yanıtlar | 3785 Görünümler | Created by ITBobbyP - 15 Ağustos 2020 Cumartesi 09:49 | Son Yanıt ile Mona Lv - 17 Ağustos 2020 Pazartesi 02:18 -
0 Oylar
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 ... -
0 Oylar
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 ...Önerilen Yanıt | 3 Yanıtlar | 4691 Görünümler | Created by InduTeja - 10 Ağustos 2020 Pazartesi 12:03 | Son Yanıt ile Mona Lv - 14 Ağustos 2020 Cuma 08:21 -
0 Oylar
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 ...Önerilen Yanıt | 6 Yanıtlar | 5100 Görünümler | Created by Nitin Kumar Goyal - 10 Ağustos 2020 Pazartesi 07:30 | Son Yanıt ile Mona Lv - 14 Ağustos 2020 Cuma 08:19 -
0 Oylar
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 ...Önerilen Yanıt | 4 Yanıtlar | 4003 Görünümler | Created by Kieran Patrick Wood - 7 Ağustos 2020 Cuma 11:35 | Son Yanıt ile Mona Lv - 14 Ağustos 2020 Cuma 08:15 -
0 Oylar
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 ...Önerilen Yanıt | 3 Yanıtlar | 4314 Görünümler | Created by Bmk7 - 13 Ağustos 2020 Perşembe 08:20 | Son Yanıt ile Mona Lv - 14 Ağustos 2020 Cuma 06:03 -
0 Oylar
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. ...Yanıt | 12 Yanıtlar | 6813 Görünümler | Created by Prasant Nanda - 3 Ağustos 2020 Pazartesi 10:51 | Son Yanıt ile Prasant Nanda - 13 Ağustos 2020 Perşembe 17:04 -
3 Oylar
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 ... - Items 1 to 20 of 66062 sonraki ›
Duyuru yok