SQL Server 2012 Integration Services (Pre-Release) announcement
-
Link
This is the Forum for SQL Server "Denali" Integration Services questions.
Found 80 threads
-
0 VotesHow to use parameters in Execute T-SQL Task query
I do not find the dialog for mapping package variables to sql parameters in the query. Is this missing from CTP3? Do any know how to do this? There is a Parameterize menu item when ...Proposed | 4 Replies | 27623 Views | Created by Vemund Haga - Friday, July 15, 2011 11:34 AM | Last reply by Koen Verbeeck - Friday, March 23, 2012 7:14 AM
-
0 Votes
Any one try adding the Sharepoint Source/Destination Adapters to the Toolbox of SSIS Denali CTP3 ?
I tried below, got an error... Download and Install the Sharepoint adapters from ...Proposed | 2 Replies | 20285 Views | Created by SQLBI - Tuesday, July 26, 2011 9:57 PM | Last reply by Carla Sabotta - Friday, March 23, 2012 12:07 AM -
0 Votes
Microsoft Connectors Oracle and Teradata by Attunity - Support for SQL Server 2012 Denali
Hi. We would like to test SSIS 2012 connectors for Oracle: however, it seems that there exist supported connectors only for SSIS 2008 (Microsoft Connectors Version 1.1 for Oracle ...Proposed | 3 Replies | 14008 Views | Created by Andrea Franchi - Wednesday, February 29, 2012 11:18 AM | Last reply by Carla Sabotta - Thursday, March 22, 2012 11:42 PM -
0 Votes
Linq to Sql using storeprocedure..
Linq to Sql using storeprocedure in n-tire .. insert,update methods..Unanswered | 2 Replies | 13681 Views | Created by SathishP - Monday, January 30, 2012 6:08 AM | Last reply by Carla Sabotta - Thursday, March 22, 2012 11:38 PM -
0 Votes
Get File Properties in SSIS
How to monitor the properties of dynamically changing flat files in ssis...??Unanswered | 5 Replies | 15685 Views | Created by Sandhya Kacham - Monday, March 12, 2012 10:46 AM | Last reply by Nik - Shahriar Nikkhah - Thursday, March 22, 2012 1:49 PM -
0 Votes
Unable to Connect 2007 Access DB using SSIS OLEDB Connection on Denali
When I tried to Connect tpo MSAccess 2007 got the following Error.. Error : “Unrecognized Database Format”, even I selected the Proper ...Unanswered | 1 Replies | 20379 Views | Created by SQLBI - Tuesday, August 9, 2011 9:36 PM | Last reply by Ke Yang - Wednesday, March 21, 2012 9:02 AM -
0 Votes
Denali CTP3 error with Microsoft Visual Studio
Hi, After installing denali CTP3 I am upgrading SSIS package with Denali CTP3 using Visual Studio 2010. However, I am getting the following error message. Would you ...Unanswered | 9 Replies | 21610 Views | Created by sabina30 - Wednesday, September 7, 2011 3:04 PM | Last reply by ArthurZ - Thursday, March 15, 2012 6:12 PM -
0 Votes
Unable to create SSIS catalog - SSISDBBackup.bak file doesn't exist
I recently set up SQL 2012 RC0 and have not been able to create an SSISDB catalog. I go to Create Catalog and it gives me an error that SSISDBBackup.bak doesn't exist. I have search for ...Unanswered | 5 Replies | 18622 Views | Created by RKilkenny - Thursday, March 1, 2012 10:10 PM | Last reply by ArthurZ - Friday, March 9, 2012 2:52 PM -
0 Votes
Project type .dtproj is not supported by this version of the application
Good morning. I've had an issue getting Sql Server Data Tools to open anything from our existing BI projects. I orignally posted in the SSDT and then the SSIS current release ...Answered | 1 Replies | 18385 Views | Created by Trev0726 - Wednesday, March 7, 2012 3:11 PM | Last reply by Trev0726 - Wednesday, March 7, 2012 11:07 PM -
0 Votes
2012 SQL management Studio Problems writing sql it hangs up.
Anyone else have problems with SQL management studio slow refresh and problems even writing SQL. Its so bad on my computer I can't use it. The program hangs all over the place when ...Unanswered | 2 Replies | 13386 Views | Created by K-Sea - Thursday, February 16, 2012 3:59 PM | Last reply by Mohammed F - Monday, March 5, 2012 9:55 PM -
0 Votes
Can we Import data from SQL 2005 to SQL 2012?
Hi, Can we Import data from SQL 2005 DB to SQL 2012 DB? When I try with Import wizard none of my SQL 2005 servers are listed but have SQL 2008 servers in the ...Discussion | 2 Replies | 13679 Views | Created by DRUDGE - Tuesday, February 28, 2012 7:57 AM | Last reply by Phil Brammer - Saturday, March 3, 2012 1:43 AM -
0 Votes
SQL 2012 RC0: HResult 0x80070057 error with custom task when using MainPipeClass
Hi, We have a C# windows service that creates SSIS packages with custom tasks on the fly to extract and load data. We have migrated our entire SQL code ...Unanswered | 4 Replies | 14593 Views | Created by Shriram_ARS - Tuesday, February 28, 2012 3:18 AM | Last reply by Shriram_ARS - Friday, March 2, 2012 5:37 AM -
0 Votes
How to send Excel filename as Tablename for each time ?
Hi All, How to read multiple Excel files which are having different structures from from ssis. each excel file contains only one sheet. and ...Unanswered | 2 Replies | 13890 Views | Created by anil yaaram - Wednesday, February 8, 2012 11:41 AM | Last reply by Nik - Shahriar Nikkhah - Wednesday, February 29, 2012 8:14 PM -
0 Votes
Oracle CDC...
Hello, all. I've read that SQL 2012/SSIS will have support for Oracle CDC (Change Data Capture). Was wondering if anyone can point me in the right direction on setting up this up, or ...Proposed | 4 Replies | 16525 Views | Created by Roshall - Sunday, December 4, 2011 12:23 PM | Last reply by JasonHowell - Tuesday, February 21, 2012 6:48 PM -
0 Votes
How to get Package Properties Deployed under Catalog in SQL Server 2012(Denali)?
I found two methods to retrieve and load packages deployed to sql server ...Unanswered | 7 Replies | 14839 Views | Created by AmanB - Monday, February 13, 2012 6:09 AM | Last reply by ArthurZ - Tuesday, February 21, 2012 3:46 PM -
0 Votes
Is SSIS supports varchar data ??
Hi, When i tried to transfer the data betweeen two tables using transfersqlserverobjects task, where table has one column varchar data type..i got one error ...Unanswered | 7 Replies | 14306 Views | Created by SUNIL PARISI - Thursday, February 16, 2012 10:38 AM | Last reply by Eileen Zhao - Tuesday, February 21, 2012 8:33 AM -
0 Votes
Detecting Lock on the record .
if a row has lock(exclusive(x)) Lock then How to detect if a record in databse table has a lock? Plz rpl..Proposed | 5 Replies | 13321 Views | Created by Manish Kohale - Monday, February 13, 2012 12:59 PM | Last reply by ArthurZ - Wednesday, February 15, 2012 3:44 PM -
1 Votes
setting exclusive lock
I want to set an exclusive lock on tables row ...how can be done the same..? plz repl.Answered | 7 Replies | 13649 Views | Created by Manish Kohale - Thursday, February 9, 2012 12:31 PM | Last reply by Manish Kohale - Monday, February 13, 2012 11:22 AM -
0 Votes
Denali CTP3 SSIS Configuration table use resulting in 0x80131904 connection error
Problem: When I try to use a configuration for Source A, I encounter an error message: Error: System.Runtime.InteropServices.COMException ...Unanswered | 2 Replies | 15382 Views | Created by Stephanie Locke - Tuesday, January 10, 2012 1:52 PM | Last reply by AmanB - Monday, February 13, 2012 5:58 AM -
0 Votes
SQL Server Integration Services 2012 (RC0) Project Conversion Bugs
Though I'd share a blog post regarding a large number of bugs I've found in the SSIS Conversion Wizards. SQL Server Integration Services 2012 (RC0) Project Conversion ...Discussion | 1 Replies | 13495 Views | Created by Mr. Wharty - Thursday, February 9, 2012 8:52 AM | Last reply by Mr. Wharty - Friday, February 10, 2012 1:26 AM - Items 1 to 20 of 80 Next ›
SQL Server 2012 Integration Services (Pre-Release) announcement
-
Link
This is the Forum for SQL Server "Denali" Integration Services questions.
