No announcements
Found 20 threads
-
0 VotesVariety of Similar Files In Different Tables
Hi friends, New to SSIS and haven't got any idea how to have around 400-500 simple similar flat files all with names in the ...
-
0 Votes
tabledifff
Hola La utilidad tablediff al generar el script con las diferencias entre ambas tablas, los campos datetime los exporta con este formato '2015-05-15 ... -
0 Votes
tablediff exporta datetime como texto
Hola La utilidad tablediff al generar el script con las diferencias entre ambas tablas, los campos datetime los exporta con este formato '2015-05-15 ... -
0 Votes
Compatible SSIS Environment for SQL Server 2014????
Hi All, We are in the process of migrating SSIS packages from SQL Server 2008R2 to SQL Server 2014.I am very excited to work in SQL 2014 In-memory technologies.However,we are in ...Unanswered | 1 Replies | 1664 Views | Created by VigneshNair03 - Monday, June 1, 2015 10:09 AM | Last reply by AV111 - Monday, June 1, 2015 10:57 AM -
0 Votes
Microsoft.LogProviderSQLServer is not installed correctly
I am getting Microsoft.LogProviderSQLServer is not installed correctly error box after I setup my event log on SSIS. Any idea how to resolve this ...Unanswered | 2 Replies | 2520 Views | Created by ethio - Monday, May 18, 2015 6:48 PM | Last reply by ethio - Monday, May 18, 2015 10:34 PM -
0 Votes
How do I import Informatica mappings into SSIS
I have a client that is upgrading from SS 2012 to 2014 and wants to drop Informatica ver 9.6 in favor of SSIS. Toprevent the cost and labor of creating the SSIS packages rom scratch, they want me to ...Unanswered | 1 Replies | 2494 Views | Created by Paul Lemmen - Thursday, May 7, 2015 1:20 AM | Last reply by AV111 - Thursday, May 7, 2015 3:13 AM -
0 Votes
SQL 2014 SSIS Performance Slow
Hi, We migrated a few ssis package from SQL 2008 R2 to SQL 2014. Backup the database from SQL 2008 R2 to SQL 2014, converted the ssis package file to the compatible version of the ...Unanswered | 1 Replies | 2423 Views | Created by Patt - Monday, December 22, 2014 2:18 AM | Last reply by AV111 - Wednesday, May 6, 2015 7:07 PM -
0 Votes
Deploy a package end with error "Access to the path 'C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config' is denied"
Hi all, I get the error in the title when I try to deploy a package to my new SQL Server 2014 Integration Service instance.Proposed | 1 Replies | 2349 Views | Created by Andrea Caldarone - Wednesday, July 30, 2014 11:15 AM | Last reply by AV111 - Tuesday, May 5, 2015 1:09 PM -
0 Votes
Is Balanced Data Distributor Transformation available for SQL Server 2014?
If not, does anyone know when it would come out? I'm trying to find transformations that will make my data flow tasks faster.Proposed | 1 Replies | 1857 Views | Created by Devin Hamai - Friday, March 13, 2015 12:30 AM | Last reply by AV111 - Tuesday, May 5, 2015 11:43 AM -
0 Votes
Scheduling without using SQL Server Agent
Can I have a scheduling job that run a group of packages on SSIS in a specific time? I can't use SQL Agent Job...Answered | 1 Replies | 1836 Views | Created by sw125 - Thursday, April 2, 2015 12:30 PM | Last reply by Vaibhav.Chaudhari - Thursday, April 2, 2015 12:44 PM -
0 Votes
High Volume Datawarehouse
Hello experts, I am expecting some valuable suggestions from you all. I am planning to architect a datawarehouse in SQLServer 2014 whose data volume will be huge ... -
0 Votes
Script task using in SSIS to delete database table row matching record with excel source
Hi All, i have one excel source and one destination table in oracle data base. i need to design one ETL package in SSIS in that i have to delete data from table if data is ... -
0 Votes
There is no Project to Reference
In Visual Studio 2013 Shell, I have an SSIS package named BIR_ETL_RPT_StageCatalogPrice.dtsx. I have another package named 'RunAllStagePackages.dtsx' that contains an Execute Package Task. That task ... -
3 Votes
Problem when clicking on Edit Script in a Script Task in SSDT-BI for Visual Studio 2013
When clicking on the Edit Script button in a Script Task nothing happens. I'm using SSDT-BI for Visual Studio 2013. This version has currently been removed by ...Unanswered | 3 Replies | 2258 Views | Created by Daniel Linderholm - Tuesday, April 29, 2014 1:19 PM | Last reply by jonathan.mooney - Monday, October 27, 2014 10:57 AM -
0 Votes
Package Variable Properties Do Not Appear in Configuration Wizard
In VS 2013 Shell, I have an SSIS package that includes a Package configuration to a SQL Server 2014 table. If I set up the configuration, and then later add a package variable, the properties of that ... -
0 Votes
SSIS Package Template Location in VS 2013
I am using VS 2013 Shell to create an SSIS Package. I want to turn the package into a template. It used to be that a package could be placed ...Answered | 1 Replies | 1990 Views | Created by cdun2 - Tuesday, September 23, 2014 3:47 PM | Last reply by cdun2 - Tuesday, September 23, 2014 4:00 PM -
0 Votes
Redirect all bad/error records in one flat file from different SSIS 2014 packages
I would like to put all my error records in one flat file/ SQL table from various packages. I may have a table like ID, ErrorRecord, ErrorColumn. ID can be just the identity column. ErrorRecord can be ...Unanswered | 1 Replies | 1957 Views | Created by Palash Aich - Thursday, August 28, 2014 10:56 AM | Last reply by Palash Aich - Monday, September 1, 2014 8:59 AM -
0 Votes
How do I import a SQL server 2008 SSI package into the 2014 SSDT for Visual Studio 2013
Are the data tools for SQL server 2014 that install into the Visual Studio 2013 IDE supposed to be able to upgrade a 2008 SSIS package. I keep getting an error with the solution file. I also don't see ... -
0 Votes
SSIS: Problem with parameter mapping in a stored procedure in a OLE DB command task
Hi, I got a problem running a stored procedure (SP) in a OLE DB command with the parameter mapping. The thing is that I have the same SP in two servers, my test environment running ... -
0 Votes
SSIS task and multiple database connection usage in single task
Hi Team, Could you please help me to understand and implement below use case in SSIS package. I have one table present in Database, let's say DB1 with ...
No announcements
