No announcements
-
47 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 | 129067 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
SSIS Custom Component: VS2017, SQL Server 2014, SSDT 15.3.0 Preview, and Windows Server 2012 R2.
WHAT IS THE REQUIREMENT TO TARGET SSIS PACKAGES TO SPECIFIC WINDOWS VERSIONS? I have created a simple Custom Component of the PipelineComponent variety. This component ... -
1 Votes
Update Min & Max dates in Process
Hi Team, I have a requirement to compile and report on data that is from a process flow where the Order progresses through the process over time. I need to find the count of orders ...Proposed | 4 Replies | 99 Views | Created by Binway - Thursday, October 05, 2017 10:20 PM | Last reply by Pirlo Zhang - 1 hour 59 minutes ago -
0 Votes
execute task fails
Hello, There are two packages. pkg_1, pkg_2 Both packages use the same connection. each package has multiple ...Unanswered | 14 Replies | 128 Views | Created by arkiboys - Saturday, October 07, 2017 6:37 AM | Last reply by HarSan Online - 2 hours 25 minutes ago -
0 Votes
SSIS Package in SQL Server Agent Job Fails Error: Argument "xyz" for option "connection" is not valid. The command line parameters are invalid. The step failed.
My sql server scheduled job is failing with the following error SSIS Package in SQL Server Agent Job Fails Error: Argument "xyz" for option ...Unanswered | 5 Replies | 85 Views | Created by AmyBI - Friday, October 06, 2017 6:40 PM | Last reply by HarSan Online - 2 hours 53 minutes ago -
0 Votes
"Exception has been thrown by the target of an invocation" while reading 700MB flat text file
I'm trying to read a 700 MB flat text file. I'm using a script task for it. The data is getting stored in a DataTable. When I'm running the package in my local machine, its running ...Unanswered | 4 Replies | 39 Views | Created by Prashant Skywalker - 5 hours 42 minutes ago | Last reply by HarSan Online - 3 hours 1 minutes ago -
0 Votes
Processing multiple files from different directories - SSIS
I have 4 file directories, each with files to be processed into one Staging table. the files have same number of columns and data types, however the files has different ...Unanswered | 4 Replies | 98 Views | Created by Sta Horse - Friday, October 06, 2017 8:55 AM | Last reply by HarSan Online - 3 hours 12 minutes ago -
0 Votes
How to save Object to temporary table as set
Hi! I have an Object variable as result set of Execute SQL Task from ODBC connected database. This object contains set of rows. How can I pass this object ...Unanswered | 2 Replies | 43 Views | Created by Dmitry Shmakov - 10 hours 57 minutes ago | Last reply by HarSan Online - 3 hours 19 minutes ago -
2 Votes
SSIS Integration services
I have a problem that, For incremental data load , without staging table how to update the destination table.Proposed | 3 Replies | 109 Views | Created by chakilam koushal - Saturday, October 07, 2017 7:25 AM | Last reply by Pirlo Zhang - 4 hours 1 minutes ago -
0 Votes
How not to Sync modified Data From SharePoint List Using Odata Source
Hi All, I am Ashish, I am using Odata Source to Sync Data to my custom data base and every 15 mins it is running from Jobs and i have seen every day only 100 to 150 rows only modify ...Proposed | 6 Replies | 127 Views | Created by AshishTiwari SQL Server Devloper - Monday, September 25, 2017 11:05 AM | Last reply by AshishTiwari SQL Server Devloper - 7 hours 26 minutes ago -
1 Votes
Unable to login to SSIS on fresh install
Hi I installed SSIS and SQL Server . I can see service is started . but Unable to login in. I cant see any SSIS through SSMS. can any one assist why its not showing through ...Proposed | 5 Replies | 138 Views | Created by ashwan - Monday, September 25, 2017 10:47 PM | Last reply by Pirlo Zhang - 7 hours 51 minutes ago -
0 Votes
Handling NULLs in a derived column
Hi, I'm using SSIS 2012 to import a SharePoint 2010 list into a SQL 2012 database. One of the SharePoint list columns is a ...Proposed | 8 Replies | 202 Views | Created by ScarePoint - Thursday, September 21, 2017 2:52 PM | Last reply by Pirlo Zhang - 7 hours 56 minutes ago -
0 Votes
Using $expand query option with OData, SSIS and SharePoint 2013
I recently had an issue with trying to expand the lookup & user columns in a SharePoint 2013 OnPrem list which I`m importing into a SQL Server 2012 ...Unanswered | 2 Replies | 86 Views | Created by tombooth01 - Saturday, October 07, 2017 9:32 AM | Last reply by tombooth01 - 9 hours 11 minutes ago -
0 Votes
Can I import from the last site to my owed site my friend all 4,450.. and 2,350.00 members. Using office 365? or any other way?
Can I import web friends from a site I was at to my web site? 4,440 friends 2,340.00 members? How do you import?Unanswered | 2 Replies | 70 Views | Created by Larry Arnold aka Pops - Friday, October 06, 2017 7:09 PM | Last reply by Pirlo Zhang - 10 hours 25 minutes ago -
0 Votes
failure precedence
Hello, Package has several tasks connected to each other... I am introducing a failure precedence so I set the task1 to fail so on failure task2 gets ...Unanswered | 6 Replies | 86 Views | Created by arkiboys - Saturday, October 07, 2017 2:13 PM | Last reply by arkiboys - 10 hours 29 minutes ago -
0 Votes
SSIS for each loop .xlsb files
How to load .xlsb files to the data base by using for each loop . Can any one suggest to achive this.Proposed | 2 Replies | 100 Views | Created by Kothamachu - Friday, October 06, 2017 11:50 PM | Last reply by Pirlo Zhang - 10 hours 32 minutes ago -
0 Votes
SFTP Task SSISSFTTask
Hi, I setup the SFTP SSIS task from CodePlex within SSIS. I set all the variables within SSIS and can run the package successfully manually. When I setup ...Unanswered | 11 Replies | 150 Views | Created by warren_c_tyler_hotmail.com - Wednesday, October 04, 2017 8:49 PM | Last reply by Pirlo Zhang - 10 hours 50 minutes ago -
0 Votes
how to ssis append to one flat file from multiple schema tables
table 1 has 2 columns table 2 has 3 columns table 3 has 4 columns I have to append data to a single csv file one after the other. table 1, table 2 and table3 so ...Answered | 4 Replies | 111 Views | Created by bhadshah-khan - Tuesday, October 03, 2017 7:46 PM | Last reply by bhadshah-khan - Sunday, October 08, 2017 2:39 PM -
0 Votes
how to debug DB2 as source in SSIS
Hi, I am running a SSIS package that connects to DB2 as a source. I am performing a certain select statement: Select ...Proposed | 13 Replies | 128 Views | Created by danisroyi2 - Tuesday, October 03, 2017 1:26 PM | Last reply by Uri Dimant - Sunday, October 08, 2017 8:18 AM -
0 Votes
ISNULL query in derived column i
Have a query regarding usage of ISNULL in derived column transformation Have a sequel code CASE WHEN ...Proposed | 1 Replies | 79 Views | Created by Praveen1404 - Saturday, October 07, 2017 3:20 PM | Last reply by RajivKBala - Sunday, October 08, 2017 12:27 AM -
0 Votes
SSIS Sharepoint List Adapter - Passing <queryoptions> to expand user fields
Hello, Has anyone had any experience expanding SharePoint Person fields pulled into SSIS via the Codeplex SSIS SharePoint List ...Proposed | 2 Replies | 139 Views | Created by tombooth01 - Friday, September 29, 2017 6:32 PM | Last reply by tombooth01 - Saturday, October 07, 2017 9:35 AM - Items 1 to 20 of 61264 Next ›
No announcements
