No announcements
-
51 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 | 146734 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
Certification Track for SSIS/SSAS?
Hello Is there a unique certification track for SSIS and/or ...Unanswered | 1 Replies | 45 Views | Created by thbrowne - 5 hours 16 minutes ago | Last reply by Vaibhav-Chaudhari - 2 hours 49 minutes ago -
0 Votes
Is that possible to execute SSIS in ASP.NET at 64bit environment (SQL 2008R2, Windows Server 2008 R2)
I got issue that try to execute SSIS in APS.NET and did not found much answer on it. Does anyone solve this problem already? thank youAnswered | 4 Replies | 4166 Views | Created by tonychi2005 - Thursday, December 30, 2010 6:18 PM | Last reply by COZYROC - 6 hours 42 minutes ago -
0 Votes
Getting error message and other data back from SSIS to managed code
Hi, From a SharePoint workflow we are trying to synchronously execute an SSIS package - which seems to work - and display error messages and ...Unanswered | 4 Replies | 4885 Views | Created by timvdh - Wednesday, September 29, 2010 9:42 PM | Last reply by COZYROC - 7 hours 12 minutes ago -
0 Votes
Calling SSIS Package from ASP.NET Code
HI, i have created a web page in asp.net in which i have called a SSIS package....... when i execute the .net page, it runs fine and package executed ...Discussion | 5 Replies | 8131 Views | Created by Amit Srivastava - Thursday, March 17, 2011 3:56 PM | Last reply by COZYROC - 7 hours 21 minutes ago -
0 Votes
SSIS Installation
I have tried to download SSDT to get the SSIS tools about three to four times now and it goes through the download cycle and when I try create a new project the SSIS is not there.Unanswered | 2 Replies | 70 Views | Created by DhruvSki - 22 hours 41 minutes ago | Last reply by Vaibhav-Chaudhari - 16 hours 26 minutes ago -
0 Votes
Do I need Visual Studio 2017 to create SSIS 2017 packages?
Hi, We are being told by our Cloud Services Group we need to get our SSIS packages to SSIS 2017 and all of our packages are SSIS 2016 and lower now. We use VS 2015 Enterprise Edition to ...Unanswered | 1 Replies | 59 Views | Created by flash7gordon - 22 hours 2 minutes ago | Last reply by Vaibhav-Chaudhari - 16 hours 32 minutes ago -
0 Votes
Executing pythin from SSIS execute task
Hi everyone, This is how I am executing my python from Execute process in ...Unanswered | 6 Replies | 97 Views | Created by YoBroRo - Thursday, November 14, 2019 9:46 PM | Last reply by YoBroRo - 22 hours 4 minutes ago -
1 Votes
Could not load file or assembly 'Microsoft.Datawarehouse.AS' or one of its dependencies
Hi, I am getting this error while I use drop down list of any db components to fetch the table name. please suggest me how to resolve this, as this is the 2nd time I am getting the ...Answered | 2 Replies | 680 Views | Created by sks92 - Wednesday, October 9, 2019 10:39 AM | Last reply by Charles Bevitt - 23 hours 1 minutes ago -
0 Votes
Best approach to design the parent - child package and to pass the lastrundatetime value to all child packages
Hi, It's been a while for me that I've worked with SSIS packages, last time I've worked with was on 2008R2. I know with 2012 SSISDB came into the picture, so I'm ... -
0 Votes
Can't connect to SSIS error message
Hello we have SQL Server 2016 installed on one of our Windows Server 2016 and also installed/enabled SSIS on same server. User is trying to connect via Management Studio as ...Proposed | 12 Replies | 300 Views | Created by techresearch7777777 - Thursday, November 7, 2019 1:57 AM | Last reply by Yitzhak Khabinsky - 23 hours 50 minutes ago -
1 Votes
Storing and retrieving email addresses SQL 2016 SSISDB
Greetings I am converting a number of file based 2008 packages from BIDS to SQL 2016 being stored in SSISDB using SSISDT. I am new to using SSISDB and have started using package and environment ...Unanswered | 2 Replies | 58 Views | Created by Abeljdang - Friday, November 15, 2019 9:03 PM | Last reply by Abeljdang - Friday, November 15, 2019 9:11 PM -
0 Votes
SSIS running long time after moving from physical server to VM
Hi Experts, Kindly please help with issue i am having with SSIS running for ever. Prod ...Unanswered | 2 Replies | 51 Views | Created by coolguy123SQL - Friday, November 15, 2019 5:56 PM | Last reply by coolguy123SQL - Friday, November 15, 2019 6:32 PM -
0 Votes
can i read a git repository file in an ssis pkg
Hi we run 2017 std. We may have a need to read the latest version of a file from a remote git repo. The best I can tell, a file task cant open such a repo as a source in a ...Unanswered | 12 Replies | 222 Views | Created by db042190 - Monday, November 11, 2019 1:42 PM | Last reply by db042190 - Friday, November 15, 2019 4:03 PM -
0 Votes
Converting a string Italian date into a datetime column - SSIS 2014-2016
Hi, I'm reading a string Italian date from a flat file. I can read "Maggio 2019", "Giugno 2019" and so on and I need to convert these string values in ...Proposed | 6 Replies | 207 Views | Created by pscorca - Wednesday, November 13, 2019 4:51 PM | Last reply by Yitzhak Khabinsky - Friday, November 15, 2019 3:08 PM -
0 Votes
SSIS Package Execution in SQL Agent Jobs
Microsoft (R) SQL Server Execute Package Utility Version 14.0.3049.1 for 32-bit Copyright (C) 2017 Microsoft. All rights reserved. Started: 11:05:01 PM ... -
0 Votes
Reading from an Excel source in a custom manner - SSIS 2014-2016
Hi, I need to read data from an Excel file automatically produced by a system. The data begin to the 10th row and I cannot how many rows I need to read starting ...Proposed | 5 Replies | 125 Views | Created by pscorca - Wednesday, November 13, 2019 3:42 PM | Last reply by pscorca - Friday, November 15, 2019 10:29 AM -
0 Votes
Data Load from AX to Snowflake using SSIS using Blob storage.
Hi All, I must do a POC on Snowflake where I have to load data from AX Source to Snowflake. It is recommended that It is better to have Data loaded 1st to CSV file and then bulk ...Proposed | 7 Replies | 140 Views | Created by Shivendoo Kumar Dubey - Thursday, November 14, 2019 4:29 AM | Last reply by Mona Lv - Friday, November 15, 2019 7:54 AM -
0 Votes
Visual Studio Crashing when running SSIS Package
I was able to run the SSIS Package before but it suddenly crashes Visual Studio now. Restarting VS/Computer didn't help. Coworker checked out the same code and ...Proposed | 11 Replies | 391 Views | Created by Tam Nguyen EHSAnalytics - Monday, November 4, 2019 10:31 PM | Last reply by Mona Lv - Friday, November 15, 2019 7:46 AM -
0 Votes
SSIS Job Failing when database is failed over to Secondary Replica.
Hi, 2 weeks ago we deployed and configured some SSIS packages to run via SQL Agent Job. Everything was running smoothly until when the Database (Part of Basic Availability Group) ...Proposed | 3 Replies | 138 Views | Created by Shaddy_1 - Tuesday, November 12, 2019 6:27 PM | Last reply by Mona Lv - Friday, November 15, 2019 7:34 AM -
0 Votes
How to use a script transformation component to divide buffer data into multiple tabs of the same excel file and download it
I am trying to get the buffer data into an excel file which will multiple tabs. So for example, if the buffer day has employee data with one of the field/column being the city, I would want ...Proposed | 9 Replies | 262 Views | Created by Subham Dangol - Saturday, November 9, 2019 12:40 AM | Last reply by Mona Lv - Friday, November 15, 2019 7:23 AM - Items 1 to 20 of 65208 Next ›
No announcements
