No announcements
-
2 VotesWho will be announced as the next SQL Server Integration Services Guru? Read more about January 2019 competition!!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. ...
-
49 Votes
FAQ - 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 | 137992 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 Package Upgrade from 2008 to 2016 - not showing Upgrade Message
Fellow SSISers, I have a new box with VS Data tool vs 2015. On it is Integartion services sql 2016. No other integration services is installed. I have ...Unanswered | 1 Replies | 36 Views | Created by mg101 - 11 hours 37 minutes ago | Last reply by Yang.Z - 25 minutes ago -
5 Votes
How to reset toolbox for SSIS visual studio Projects
When opening an package (.dtsx) the toolbox no longer shows the Toolbox groups and items as before... how do I reset the groups and ...Answered | 21 Replies | 30926 Views | Created by a.LP - Wednesday, May 23, 2007 8:42 AM | Last reply by ChipsyP - 3 hours 39 minutes ago -
0 Votes
How to use results from one SQL script to run a different SQL script?
My office is in the process of adding SQL scripts into SSIS for the first time to data flows, and so far so good. However, we have two sets of SQL scripts that we'd like to essentially combine that we ...Unanswered | 2 Replies | 53 Views | Created by C.Lyon1 - 6 hours 34 minutes ago | Last reply by Yitzhak Khabinsky - 6 hours 12 minutes ago -
0 Votes
Username and password security
Hello, I've created an SSIS package that connects to Netezza in order to upload data daily. I'm assuming that everytime I run the SSIS package, the connection string from within the ...Unanswered | 2 Replies | 61 Views | Created by Jim1212 - 9 hours 30 minutes ago | Last reply by Jim1212 - 7 hours 42 minutes ago -
0 Votes
Run SSRS report with SSIS using list of parameters
I have created a report and need to run it for each client number (about 1200), then save each report to an excel file. Can this be done? Thanks.Answered | 4 Replies | 210 Views | Created by FLSojourner - Wednesday, January 9, 2019 3:41 PM | Last reply by FLSojourner - 7 hours 49 minutes ago -
0 Votes
SQL Server Data Tools you must install Match Data of Integration Services or higher - When exporting data
Fellow SSISers, We have an application that runs a couple of ssis packages. The app and ssis are on the same box. These packages are in SSIS 2008 - they work flawlessly ...Answered | 7 Replies | 70 Views | Created by mg101 - 9 hours 50 minutes ago | Last reply by mg101 - 7 hours 58 minutes ago -
0 Votes
How to return BCP dir command output into multiple columns?
I have a list of files in multiple folders in F:\ClientData\DocumentsTEST\guidsTest This query gives me a full filepath for each file in a single ...Unanswered | 1 Replies | 59 Views | Created by DataCow - 8 hours 39 minutes ago | Last reply by Yitzhak Khabinsky - 8 hours 7 minutes ago -
0 Votes
How to call SAP RFC from SSIS
Hi!! I´m new with SAP, can you tell me pelase how to call a SAP RFC from SSIS package? Thanks,Answered | 5 Replies | 192 Views | Created by JohaNery - Wednesday, January 16, 2019 9:31 PM | Last reply by JohaNery - 8 hours 29 minutes ago -
0 Votes
XML configuration file on Mail
I need to add an XML configuration file that contains variables for next strings in smtp mail: FROM, TO? How to do it?Unanswered | 1 Replies | 63 Views | Created by MoXieMaister - 9 hours 25 minutes ago | Last reply by Yitzhak Khabinsky - 9 hours 8 minutes ago -
0 Votes
Generate Code Map: Unable to Connect to the Specified Database
Options -> Database Tools -> Data Connections) does not work: Installing SQL server components. Most of the SQL Server components one might find ...Unanswered | 5 Replies | 181 Views | Created by user905 - Friday, January 18, 2019 3:16 AM | Last reply by user905 - 10 hours 52 minutes ago -
0 Votes
how to load multiple files into multiple destination table in ssis
source FIles Structure: for hyd.txt file Id,name,loc 1,abc,hyd 2,hari,hyd for hyd1.txt ...Answered | 7 Replies | 1007 Views | Created by prasad456 - Thursday, March 1, 2018 11:22 AM | Last reply by Yitzhak Khabinsky - 11 hours 2 minutes ago -
0 Votes
Automated deployment tool
Hello fellow members. First, forgive me if this isn’t the correct forum to be asking this. I’ve been asked by management to come up with a process to ... -
0 Votes
SSIS Extract to a .csv file shows as .00
So I am just trying to be proactive here if the client comes back and says they want the data as 0.00 rather than .00. How can I get the quantity out to a .csv file as 0.00 as ...Proposed | 4 Replies | 184 Views | Created by ITBobbyP - Thursday, January 17, 2019 10:33 PM | Last reply by ITBobbyP - 12 hours 13 minutes ago -
0 Votes
How to get data from Podio to SQL Server using SSIS
Hello there, I am trying to import data from Podio to SQL server using SSIS. Do we have any provider for Podio like any other source to connect to Podio in ...Unanswered | 1 Replies | 54 Views | Created by Palash Aich - 14 hours 28 minutes ago | Last reply by Visakh16 - 13 hours 50 minutes ago -
0 Votes
Extract Columns From Different layout from single flat file
Hi Team, I have Flat File like mentioned below. I want to dump data on "Column: Type" basis. If Type = 0 then dump in 1 table, Type =1 then dump in 2nd ...Unanswered | 1 Replies | 51 Views | Created by Ravik4934 - 14 hours 30 minutes ago | Last reply by Visakh16 - 13 hours 59 minutes ago -
0 Votes
OleDB Destination for Oracle
Hello Gurus, Without using Attunity adapters (which involves upgrading SQL to Enterprise) and not using customer connectors (like CozyRoc) is there anyway we can achieve decent ...Unanswered | 2 Replies | 133 Views | Created by btsbee - Friday, January 18, 2019 4:36 PM | Last reply by btsbee - 14 hours 38 minutes ago -
0 Votes
Fuzzy Logic can used in same column
Hi Experts, I am using fuzzy logic to identify a similar company name but it is not working as expected. I want to apply Fuzzy logic in a similar column which is ...Unanswered | 3 Replies | 124 Views | Created by Vinay Raghuwanshi - Friday, January 18, 2019 4:01 PM | Last reply by Yang.Z - 16 hours 11 minutes ago -
0 Votes
SSIS 2016 : "ForceExecutionResult = Success" doesn't work
Hi all, I managed the task failure with OnError event handler. After OnError my database situation is consistent but the ssis execution is result in ...Proposed | 15 Replies | 283 Views | Created by alucard_ - Tuesday, January 15, 2019 5:25 PM | Last reply by .saitama - 16 hours 58 minutes ago -
0 Votes
Syntax to call HANA Calculation view with the Input Parameter
Hi, We've a HANA Calculation view that we want to call from SSIS to load it's output. This calculation view has input parameters and we've to call this calc view. What syntax we ...Unanswered | 1 Replies | 128 Views | Created by AlokV - Friday, January 18, 2019 8:54 PM | Last reply by Yang.Z - 18 hours 10 minutes ago -
0 Votes
Can SSIS Package Be Created in SQL Server 2017 Management Studio
I am migrating a very old .Net Web application from SQL Server 2005/Visual Studio 2005 to SQL Server 2017/Visual Studio 2010. I need to create a new SSIS Package to be able to ...Proposed | 3 Replies | 142 Views | Created by M Thomas - Sunday, January 20, 2019 9:10 PM | Last reply by Visakh16 - 19 hours 12 minutes ago - Items 1 to 20 of 63770 Next ›
No announcements
