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 | 128169 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
Execute Package Task - External Reference. Packages are displaying
I have a few "Execute Package Tasks" where I want to be able to set an external reference and set it to the SSIS package on SQL Server. The problem is that the SSIS packages are not showing ... -
0 Votes
Cache File Column Name Changes
I have cache file that I am using as a source file. Prior to getting to this step, validations are performed and if they do not pass, the package does not make it to the cache file ...Unanswered | 2 Replies | 66 Views | Created by DanHaf - Thursday, August 17, 2017 12:49 PM | Last reply by DanHaf - 16 minutes ago -
0 Votes
OData connection failure - Cannot acquire a managed connection from the run-time connection manager
I am trying to do a basic operation of retreiving odata feed from Project online and store it in SQL server table. I can successfully establish connection to Project Online ...Unanswered | 3 Replies | 94 Views | Created by Hammad Arif - Thursday, August 17, 2017 2:27 AM | Last reply by Pirlo Zhang - 1 hour 58 minutes ago -
0 Votes
Getting duplicates from source table but actually they are no duplicates on the source table
Hi , I was reading a table from source, and dft was failing because they were duplicates in source. But there were no duplicates in source. Can someone help me in this ...Proposed | 13 Replies | 136 Views | Created by ganesh_439 - Thursday, August 17, 2017 6:22 AM | Last reply by Pirlo Zhang - 2 hours 5 minutes ago -
0 Votes
Error running Excel file load as a server job
Hi, I'm running a package to loop over and load some excel files and it runs perfectly in Visual Studio, however on running as a job, I get the error "Microsoft Office Access ...Unanswered | 7 Replies | 149 Views | Created by scott murdoch12 - Wednesday, August 09, 2017 2:51 PM | Last reply by Pirlo Zhang - 2 hours 7 minutes ago -
0 Votes
SSIS to Execute SQL Query on Teradata, Return Results to SQL Server Database Table
Hello, I have a single Teradata statement query, in a SSIS package, with a single Execute SQL Task. In that task, I've tried to use in the General Tab, the ODBC, but have lots of connection ...Unanswered | 4 Replies | 82 Views | Created by JP_Quinn - Tuesday, August 15, 2017 3:07 PM | Last reply by Pirlo Zhang - 2 hours 59 minutes ago -
0 Votes
Help with SSIS integration service project conversion wizard
Hello forum, I'm kind of new to SSIS and I converted my project to package deployment model so I can do a package configuration. I've been trying to convert the project to ...Unanswered | 3 Replies | 91 Views | Created by Julius Adeyemi - Monday, August 14, 2017 4:19 AM | Last reply by Pirlo Zhang - 3 hours 29 minutes ago -
0 Votes
SSIS C# Script Task runs fine from Visual Studio 2015 but does nothing when run from SSMS
I have a very simple C# Script Task inside of a Foreach loop. For every file processed it parses the filename and sets a Dts variable to the date contained in the file name. This date is used in the ...Proposed | 5 Replies | 143 Views | Created by Marco Herrera - Sunday, August 13, 2017 11:18 AM | Last reply by Pirlo Zhang - 3 hours 31 minutes ago -
0 Votes
SSIS 2012 package on Integration Service of v2016
Hi, I have an SSIS package developed in Visual Studio 2012 which uses BDD (Version 2012 had this as an add-on) I have upgraded my integration ...Unanswered | 3 Replies | 83 Views | Created by Abhishek S Sarda - Wednesday, August 16, 2017 3:54 PM | Last reply by Abhishek S Sarda - 3 hours 57 minutes ago -
0 Votes
SSIS package unexpected Termination Issue
Hi , We are facing the issue called - unexpected Termination . We are using the below mentioned SQL Server : Microsoft SQL Server ...Unanswered | 3 Replies | 100 Views | Created by Abhisek Mondal - Friday, August 11, 2017 8:13 AM | Last reply by Pirlo Zhang - 6 hours 5 minutes ago -
0 Votes
SSIS Package Execution Error - Command Prompt - 2015
Recently we upgraded our SQL Server instances from 2008 R2 to 2014 and Microsoft Visual studio 2008 to Visual studio 2015.While trying to execute the SSIS package from the command prompt we ...Unanswered | 5 Replies | 135 Views | Created by vanik20 - Thursday, August 17, 2017 2:41 AM | Last reply by Pirlo Zhang - 9 hours 3 minutes ago -
0 Votes
preventing ssis from overwriting config settings in config table
Hi we run 2012 enterprise. Recently one of our developers allowed ssis to overwrite config entries in a production config table. I vaguely remember ssis can do this in certain situations but ...Unanswered | 4 Replies | 85 Views | Created by db042190 - Thursday, August 17, 2017 1:39 PM | Last reply by Pirlo Zhang - 9 hours 26 minutes ago -
0 Votes
Problems using Sql Server Agent to run a Package
I've gone through the steps to create a SSISDB folder and deployed my project and package to it. I can execute the package from MSSS, however, when I try to use the SSA to run it, the Agent returns ...Unanswered | 4 Replies | 88 Views | Created by GrifMan - Thursday, August 17, 2017 8:22 PM | Last reply by Vishe - 9 hours 35 minutes ago -
0 Votes
attunity driver
hi I have visual studio 2015 and sql server 2017. what Attunity connector I need to install? and what other settings I need to ...Unanswered | 2 Replies | 95 Views | Created by coool_sweet - Thursday, August 17, 2017 10:33 PM | Last reply by Pirlo Zhang - 10 hours 22 minutes ago -
0 Votes
Running a SSRS Report from an SSIS Package
So my SSIS Package contains all my ETL elements including my data point check edits. If a data touch point fails edit, then we create an [AggregateError] row. My SSIS Package determines if I have data ...Unanswered | 5 Replies | 93 Views | Created by ITBobbyP - Friday, August 18, 2017 7:39 PM | Last reply by Pirlo Zhang - 10 hours 41 minutes ago -
0 Votes
Error Message - "OLE DB Source failed the pre-execute phase"
Dear SSIS Community, I'm running into a pesky error that I'm not sure how to resolve. The Source is connecting to SSAS cube, and I received the following error during ...Unanswered | 2 Replies | 63 Views | Created by LAWSQL - Friday, August 18, 2017 9:03 PM | Last reply by Pirlo Zhang - 11 hours 1 minutes ago -
1 Votes
Property of Custom Connection Mgr not updated when Expression (using variable) evaluated at runtime
I have a custom connection manager component that includes a read write property "Filename". When use a For Each Loop control and assign the index 0 to a variable I can see that my ...Unanswered | 9 Replies | 296 Views | Created by ben (amino software) - Monday, August 07, 2017 7:31 PM | Last reply by ben (amino software) - 14 hours 37 minutes ago -
0 Votes
need logic
hi i have table like this ...Unanswered | 3 Replies | 133 Views | Created by coool_sweet - Saturday, August 19, 2017 2:25 AM | Last reply by RajivKBala - 19 hours 23 minutes ago -
0 Votes
Who will be announced the next Microsoft TechNet Guru? Read more about August 2017 competition
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that ...Discussion | 1 Replies | 67 Views | Created by [Kamlesh Kumar] - Tuesday, August 01, 2017 8:36 PM | Last reply by [Kamlesh Kumar] - Sunday, August 20, 2017 11:35 AM -
0 Votes
Accidentally deleted SSISDB from SSMS Databases
Alright, well, I was going to try to redeploy my package.dtsx to Integration Services Catalog and instead of deleting the SSISDB folder in the Catalog I deleted the SSISDB from Databases. Been looking ...Answered | 4 Replies | 111 Views | Created by GrifMan - Friday, August 18, 2017 8:15 PM | Last reply by GrifMan - Saturday, August 19, 2017 1:21 PM - Items 1 to 20 of 60980 Next ›
No announcements
