No announcements
-
46 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 | 126815 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
SSISDB query for data flow task
Hi, I need query for execution time taken by each task in a SSIS package. Following are the fields required in result Package ...Unanswered | 5 Replies | 85 Views | Created by Mr Vivek Singh - Friday, June 23, 2017 4:55 AM | Last reply by Pirlo Zhang - 2 hours 13 minutes ago -
0 Votes
Fuzzy Transform cancels after execute phase begins "SSIS package finished: Canceled"
Hi All, I have a basic fuzzy transform that pulls data from an oledb source (connected to sql server 2008 r2), the package successfully pulls from the source but after building the ...Unanswered | 6 Replies | 124 Views | Created by essasix23 - Wednesday, June 21, 2017 3:18 PM | Last reply by Pirlo Zhang - 2 hours 26 minutes ago -
0 Votes
How to loop in SSIS 2014 and send a SSRS paramterized report which generates PDF to user's email address using SSIS 2014 package
I have a user table which holds user details Userid name email age ...Proposed | 7 Replies | 428 Views | Created by MLTC - Saturday, June 17, 2017 7:38 PM | Last reply by Pirlo Zhang - 3 hours 15 minutes ago -
0 Votes
SSDT 2015 SSIS Package not executing in sql server Agent 2014
My SSIS package in SSDT 2015 version and its executing successfully through solution. Solution Have 3 script tasks and 3 Data Flow Tasks. When Execute Through Sql Server Agent 2014 ...Proposed | 3 Replies | 68 Views | Created by harikiran2010 - Wednesday, June 21, 2017 8:27 AM | Last reply by Pirlo Zhang - 3 hours 23 minutes ago -
0 Votes
Undiscovered / UnExposed properties of SSIS
Can someone please redirect me to proper demos of the following ...Unanswered | 1 Replies | 66 Views | Created by Sai Bhasker Raju .C - Friday, June 23, 2017 11:28 AM | Last reply by Pirlo Zhang - 3 hours 26 minutes ago -
0 Votes
-
0 Votes
Excel Destination in SSIS throwing error when changing the connection manager destination to dynamic path with date in expression
Need your help, I have seen many suggestion on the net but no luck. I am exporting table data to excel using 'Excel Destination' task and while adding a dynamic destination path in ...Proposed | 2 Replies | 44 Views | Created by SunithaRam - 12 hours 43 minutes ago | Last reply by Pirlo Zhang - 4 hours 8 minutes ago -
0 Votes
Importing Data From AX Tables
Hi guys, Needed some insights on importing data from AX tables as I've never worked on this source before. Any help on setting up a connection to AX, the connector that would be ...Proposed | 3 Replies | 67 Views | Created by Adler03 - 21 hours 40 minutes ago | Last reply by Pirlo Zhang - 4 hours 24 minutes ago -
0 Votes
Is it necessary to have MS excel software installed on the target machine while exporting data from SSIS to excel
In my Development machine I have MS excel is installed. I'm able to export data into excel from DB through SSIS (visual studio). but when i deployed it to QA environment where MS excel is not ...Unanswered | 2 Replies | 90 Views | Created by Vikram Dayananda - Saturday, June 24, 2017 8:02 AM | Last reply by Pirlo Zhang - 5 hours 20 minutes ago -
0 Votes
SSIS Package is not opening
Hi , Good Morning I have one issue when i open SSIS package on visual studio 2015 it gives the following error, I appreciate you if anyone ...Unanswered | 2 Replies | 95 Views | Created by RANJITH ROUTHU - Friday, June 23, 2017 2:46 PM | Last reply by Pirlo Zhang - 5 hours 37 minutes ago -
0 Votes
WinSCP Execute Process Task
So we are using and have successfully tested a WinSCP Execute Process Task to push out a data file to our Secured FTP site. And it works like a charm. Now we have a little bit of a logon problem. So ...Unanswered | 1 Replies | 52 Views | Created by ITBobbyP - Thursday, June 22, 2017 3:57 PM | Last reply by Pirlo Zhang - 6 hours 2 minutes ago -
0 Votes
Infor M3 and Oracle Fusion with SSIS
Do you have any idea on Infor M3 (ERP) and Oracle Fusion (HRMS) with SSIS? Please let me know.... Karthick SUnanswered | 5 Replies | 107 Views | Created by S.Karthick - Thursday, June 22, 2017 12:52 PM | Last reply by S.Karthick - 8 hours 5 minutes ago -
0 Votes
Append TimeStamp to FileName
Hi All I Have a File System Task where i am appending Timestamp to Filename during archive process. It was successful though however my filename has multiple . (dots) before ...Proposed | 1 Replies | 85 Views | Created by Rajm0019 - Friday, June 23, 2017 3:49 PM | Last reply by Ryandell - Sunday, June 25, 2017 11:20 AM -
0 Votes
Can I use SSRS and SSIS 2008 with a SQL 2012 database ?
(Help me MSDN forums, you are my only hope). We currently have a very large SQL Server 2008 database that is used as a data warehouse. It has hundreds of tables and stored ...Answered | 11 Replies | 183 Views | Created by Greg Booth - Friday, June 16, 2017 12:07 PM | Last reply by Greg Booth - Friday, June 23, 2017 12:25 PM -
0 Votes
try to open an ssis project with c#
hello i create a windows forms application inside i add a button et i want it to open my project ssis here the code but it doesn't work any help please ...Answered | 9 Replies | 143 Views | Created by AsmaGh - Thursday, June 22, 2017 12:21 PM | Last reply by AsmaGh - Friday, June 23, 2017 10:55 AM -
1 Votes
Row handle referred to a deleted row or a row marked for deletion.
Hi All, i am transferring the data by using ssis package , that ssis package consist various steps ...Answered | 6 Replies | 162 Views | Created by Ganesh Yerme - Wednesday, June 21, 2017 7:19 AM | Last reply by Ganesh Yerme - Friday, June 23, 2017 10:29 AM -
0 Votes
Problem with multiple commas and quatation in data when exporting to a CSV file
I have a table that I am exporting via a SQL server table to a .csv file, via the flat file connection manager within SSIS. My issue is that one of the fields in my table contains multiple ...Unanswered | 7 Replies | 176 Views | Created by PavanJ9 - Thursday, June 15, 2017 10:00 PM | Last reply by Pirlo Zhang - Friday, June 23, 2017 10:05 AM -
0 Votes
file chk exist and move
hi I need to check if both files are exist in folder, if both are there then only I need to move both the files. I m using for each loop and ...Proposed | 2 Replies | 83 Views | Created by coool_sweet - Tuesday, June 20, 2017 8:25 PM | Last reply by Pirlo Zhang - Friday, June 23, 2017 9:58 AM -
0 Votes
How to show the correct Chinese
Hi Masters, I have an issues, the Toad could show the correct Chinese, but when I use the SSIS component, it shows messy code. Please give me some advice, very ...Unanswered | 7 Replies | 125 Views | Created by arlsen - Tuesday, June 20, 2017 8:52 AM | Last reply by Pirlo Zhang - Friday, June 23, 2017 9:56 AM -
0 Votes
Loading data from multiple servers having multiple tables into a single server having multiple tables
How to Load data from multiple servers having multiple tables into a single server having multiple tables using parameter that will change the database and table name dynamically??Unanswered | 7 Replies | 156 Views | Created by Kumarijulie - Sunday, June 18, 2017 7:24 PM | Last reply by Pirlo Zhang - Friday, June 23, 2017 9:55 AM - Items 1 to 20 of 60619 Next ›
No announcements
