SQL Server 2012 Integration Services (Pre-Release) announcement
-
Link
This is the Forum for SQL Server "Denali" Integration Services questions.
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Proposed0VotesHow 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 ... -
Proposed0VotesAny 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 ... -
Proposed0VotesMicrosoft 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 ... -
Unanswered0VotesLinq to Sql using storeprocedure..
Linq to Sql using storeprocedure in n-tire .. insert,update methods.. -
Unanswered0VotesGet File Properties in SSIS
How to monitor the properties of dynamically changing flat files in ssis...?? -
Unanswered0VotesUnable 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 ... -
Unanswered0VotesDenali 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 ... -
Unanswered0VotesUnable 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 ... -
Answered0VotesProject 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 ... -
Unanswered0Votes2012 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 ... -
Discussion0VotesCan 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 ... -
Unanswered0VotesSQL 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 ... -
Unanswered0VotesHow 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 ... -
Proposed0VotesOracle 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 ... -
Unanswered0VotesHow 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 ... -
Unanswered0VotesIs 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 ... -
Proposed0VotesDetecting 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.. -
Answered1Votessetting exclusive lock
I want to set an exclusive lock on tables row ...how can be done the same..? plz repl. -
Unanswered0VotesDenali 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 ... -
Discussion0VotesSQL 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 ... - Items 1 to 20 of 81 Next ›


