No announcements
-
48 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 | 135811 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
Overlapping columns in flat file destination
Hi, I am having issues when using flat files destination , the first one is data in the columns are overlapping. Second one is when i run the dft for the second time , the job ...Unanswered | 3 Replies | 46 Views | Created by saivenkat77 - Friday, September 21, 2018 8:33 PM | Last reply by saivenkat77 - 22 minutes ago -
0 Votes
Reg:How to create package to run the stored procedure in multiple databases in the same server..
Hi Experts, i need to create the SSIS package such that the required stored procedure(with alter statement) should run on the multiple databases in the same sql server ... -
0 Votes
how to place variable instead of manual date in the source query from oracle
Hi all, i am using source as oracle query and i wanted to put date variable instead of manual date in the below query. select * from sample ...Unanswered | 1 Replies | 43 Views | Created by ds_999 - 6 hours 44 minutes ago | Last reply by ds_999 - 5 hours 41 minutes ago -
0 Votes
SSIS/SSDT 2016 - How to save connection credentials when project is deployed to SSISDB Catalog
Using SQL Server 2016, Microsoft SQL Server Data Tools 16.5, Visual Studio 2015 Shell My DBA gave me access to /Integration Services ... -
0 Votes
Facing Issues while running the package outside of SQL Server Tools
Hello SSIS Guru, I installed SQL Server Management Studio v17.4 (Version 14.0.17213.0) followed by SQL Server Data Tools for visual studio 2017 (Data Tools) (Version ... -
0 Votes
Failed to deploy project Build errors wer encontered
System.Runtime.InteropServices.COMException: The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this ... -
0 Votes
Microsoft.DataTransformationServices.VsIntegration
hi when i want to change my PKG i couldn't save and run i get follow error Exception deserializing the package "Access to the path ...Unanswered | 1 Replies | 32 Views | Created by Y_mrs - 16 hours 30 minutes ago | Last reply by Visakh16 - 15 hours 49 minutes ago -
0 Votes
Sending file from Local to SFTP server using Execute Process Task
I've read a whole bunch of different forums on this but cant seem to get mine to work. I need to transfer a file from my local machine to an SFTP server using SSIS. Here is what i've already ...Unanswered | 1 Replies | 42 Views | Created by LZee - Friday, September 21, 2018 8:53 PM | Last reply by Visakh16 - 16 hours 10 minutes ago -
0 Votes
send file to sftp
Hi All, I was sending file via stored procedure to FTP server every night, till yesterday company has moved to the SFTP. I installed WinSCP and Visual Studio for SSIS. Can anyone ...Answered | 34 Replies | 4171 Views | Created by Jibran83 - Friday, March 18, 2016 2:42 PM | Last reply by LZee - Friday, September 21, 2018 9:07 PM -
0 Votes
String Variable is not populating with the value generated in a C# script.
Hi All, I have a fairly simple requirement to read the filename from a location and populate a variable with the filename. I am using a script task for this task. No matter what I ...Discussion | 4 Replies | 62 Views | Created by Navneet Thakur - Thursday, September 20, 2018 10:56 PM | Last reply by Navneet Thakur - Friday, September 21, 2018 7:24 PM -
0 Votes
SSIS Agent job Issue
Hello All, Recently our server were upgraded from SQL SERVER 2012 to 2014. our local machines have only 2012. After upgrading the servers when i was running the ssis existing agent ...Unanswered | 2 Replies | 52 Views | Created by cmk1 - Friday, September 21, 2018 4:40 PM | Last reply by Visakh16 - Friday, September 21, 2018 6:22 PM -
1 Votes
SQL server agent job step is not passing the parameter to SSIS package | Unable to over-ride a config value using job step| SSIS 2014
Config in the config file for the variable is set to 0 and I m trying to over-ride the value via SQL agent job step to 1 Config in the config ...Unanswered | 1 Replies | 38 Views | Created by MLTC - Friday, September 21, 2018 4:50 PM | Last reply by Visakh16 - Friday, September 21, 2018 6:21 PM -
0 Votes
SSIS Debugger - Unable to start 'DTS'
When trying to execute SSIS packages in VS 2017, I am receiving the error shown below. I have read other threads and one solution listed is to run the Visual Studio Installer to add the ... -
4 Votes
Max Import Rows with Excel Source Tool?
Hello, all - I'm importing an Excel file that has a number of extraneous rows before getting to the actual data that needs to be imported. To do this, I have the OpenRowset set ...Answered | 10 Replies | 132 Views | Created by Adam Quark - Wednesday, September 19, 2018 4:46 PM | Last reply by Adam Quark - Friday, September 21, 2018 4:30 PM -
0 Votes
Data Flow Task Source - AccessMode not being set in Script task
I have created a package with a Script Task in VB.Net. It saves the package after it runs so I can check if everything was created correctly. In the source of the data flow task I set the ...Answered | 1 Replies | 57 Views | Created by Joshua Howie - Thursday, September 20, 2018 6:59 PM | Last reply by Joshua Howie - Friday, September 21, 2018 1:58 PM -
0 Votes
Import and Export Wizard
I'm getting the following error when I tried to execute a SSIS Package I just created using Import and Export Wizard to drop/create new tables from one database server to another for about 122 ...Unanswered | 1 Replies | 34 Views | Created by MKL0815 - Friday, September 21, 2018 1:33 PM | Last reply by Visakh16 - Friday, September 21, 2018 1:39 PM -
0 Votes
Is it possible to load a dynamic output?
Hi, Ok, I assume that the answear is no, but anyway here it goes. Is it possible to in anyway load data to a dynamic ...Answered | 3 Replies | 46 Views | Created by Nilfons - Friday, September 21, 2018 11:10 AM | Last reply by Visakh16 - Friday, September 21, 2018 12:36 PM -
0 Votes
huge data loading using bulk insert in Script task
Hi all, I am facing an issue while working on the SSIS data load using script task. I am fetching data from linked server using OPEN_QUERY syntax and inserting ...Proposed | 5 Replies | 79 Views | Created by Avhilash - Thursday, September 20, 2018 11:27 AM | Last reply by Tom Phillips - Friday, September 21, 2018 11:53 AM -
3 Votes
How to insert alphanumeric column in SQL server using SSIS pacakge?
i have column like also have some values like 45,510,340. i am trying to insert it using SSIS pacakge into sql server table? file is in.xls format. even though i ...Unanswered | 7 Replies | 104 Views | Created by Vishal Sanap - Thursday, September 20, 2018 9:05 AM | Last reply by Vishal Sanap - Friday, September 21, 2018 8:32 AM -
0 Votes
SSIS: data conversion from flat source (csv)
Hello, i am trying to put data on my datawarhouse through SSIS, My data source is a flat file (.CSV) and im trying to convert a column to the string type ...Unanswered | 5 Replies | 119 Views | Created by malek85 - Monday, September 17, 2018 9:03 PM | Last reply by Yang.Z - Friday, September 21, 2018 7:49 AM - Items 1 to 20 of 63281 Next ›
No announcements
