No announcements
Forums [ view all ]
-
Select allSQL Server Integration ServicesData MiningSQL Server Reporting Services, Power ViewSQL Server Analysis ServicesSQL Server ToolsTransact-SQL.NET Framework inside SQL ServerSQL Server Data AccessSQL Server SMO/DMOSQL Server XMLSQL Server ReplicationSQL Service BrokerSQL Server SecuritySQL Server Database EngineSQL Server DocumentationSQL Server Setup & UpgradeSQL Server High Availability and Disaster RecoverySQL Server Notification ServicesSQL Server CompactGetting started with SQL ServerDatabase MirroringSQL Server ExpressMicrosoft Drivers for PHP for SQL ServerSQL Server Data WarehousingSQL Server SearchSQL Server SpatialSQL Server Samples and Community ProjectsMicrosoft StreamInsightDatabase DesignSQL Server MigrationSQL Server Master Data ServicesSQL Server Application and Multi-Server ManagementSQL Server PowerPivot for ExcelSQL Server PowerPivot for SharePointSQL Server ManageabilitySQL Server Distributed ReplaySQL Server Data Quality ServicesMicrosoft HDInsight (Windows and Windows Azure)SQL Server Data Tools
-
Select allAnnouncements for all ForumsForums Redesign - Q&A / DiscussionsWhere is the Forum For…?Forums Issues (not product support)Suggestions and Feedback for the ForumsOff-Topic Posts (Do Not Post Here)MSDN and TechNet Profile and Recognition System Discussions
-
Select allVisual C#Visual BasicVisual C++C++ Standards, Extensions, and InteropParallel Computing in C++ and Native CodeVisual F#Microsoft "Roslyn" CTP
-
Select allVisual Studio General QuestionsVisual Studio Setup and InstallationVisual Studio ExtensibilityVisual Studio Tools for Office (VSTO)Visual Studio EditorMSBuildVisual Studio LightSwitch ExtensibilityVisual Studio LightSwitch - General QuestionsLightSwitch HTML Client PreviewVisual Studio Visualization & Modeling ToolsTesting with Visual Studio Test Manager (MTM)Test Tools in Visual Studio 2010 and 2012Visual Studio Unit TestingVisual Studio Diagnostics (Debugger, Profiler, IntelliTrace)Visual Studio Tools for Applications (VSTA)
-
Select allUI Design for Windows Store appsTailoring your Windows Store app for hardware and devicesBuilding Windows Store apps with HTML5/JavaScriptBuilding Windows Store apps with C++Building Windows Store apps with C# or VBBuilding Windows Store games with DirectXTools for Windows Store appsPublishing Windows Store apps
-
Select allApplication Compatibility for Windows Desktop DevelopmentDeveloping Windows Desktop Applications with Power ManagementWindows Desktop Development for Accessibility and AutomationDirectShow DevelopmentGeneral Windows Desktop Development IssuesWindows Desktop Development for Ink, Touch, and Tablet PCMedia Foundation Development for Windows DesktopMicrosoft Message Queuing (MSMQ)Network MonitorWindows Desktop Optical Platform DiscussionPeer-to-Peer Networking for Windows DesktopApplication Security for Windows DesktopWindows Desktop Sidebar Gadget DevelopmentUser Interface development for Windows DesktopVisual C++Windows Desktop DebuggingWindows Desktop Search DevelopmentWindows Desktop Search HelpWindows Filtering Platform (WFP)Windows Imaging Component (WIC)Windows Desktop Perfmon and Diagnostic toolsWindows Desktop Pro-Audio Application DevelopmentWindows Desktop SDKWindows Desktop Web Services API (webservices.dll)Windows Desktop Winsock Kernel (WSK)Windows Hardware WDK and Driver DevelopmentDevelopment with the Windows Sensor and Location PlatformWindows Desktop Ribbon DevelopmentWindows Hardware Testing and CertificationC++ Standards, Extensions, and InteropMessage Analyzer
-
Select allDeveloping for Windows PhoneTools for Windows Phone developmentShare your "How To" samplesPush NotificationsIn-App AdvertisingMango Update (Archived)Expression Blend for Windows Phone
-
Select allDeveloping Apps for Office 2013General Office DevelopmentAccess for DevelopersExcel for DevelopersOutlook for DevelopersWord for DevelopersOpen XML Format SDKVisual Studio Tools for Office (VSTO)
-
Select allWindows Azure DevelopmentWindows Azure Troubleshooting, Diagnostics & LoggingWindows Azure Storage, CDN and CachingWindows Azure SQL DatabaseConnectivity and Messaging - Windows AzureManaging Services on Windows AzureSecurity for Windows AzureWindows Azure Purchasing, Pricing & BillingWorkflow Manager 1.0Service Bus 1.0Windows Azure Active DirectoryWindows Azure Active AuthenticationWindows Azure Media ServicesWindows Azure BizTalk ServicesWindows Azure Virtual NetworkWindows Azure Virtual MachinesWindows Azure Pack
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky1VotesAre you a technology guru? Show us your solutions and become the Integration Services Guru for June 2013!!
TechNet Wiki is looking for and celebrating the best of the best! Is that you? Do you consider yourself an expert or authority on SQL Server Integration ...0 Replies | 564 Views | Ed Price - MSFT - Monday, June 03, 2013 6:49 AM
-
Sticky40Votes
FAQ - 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 ...38 Replies | 80224 Views | Phil Brammer - Monday, November 26, 2007 5:55 PM | Last Reply Zoltán Horváth - Monday, March 18, 2013 11:08 AM
-
Answered0Votes
SSIS Debug Host has stopped working
Hi, I'm trying to update columns in my SQL Server Compact Edition 3.5 DB through OLE DB COMMAND in SSIS 2012. When I update a column with NTEXT datatype my SSIS ...2 Replies | 62 Views | Denesh Kumar Mani - 19 hours 37 minutes ago | Last Reply Denesh Kumar Mani - 35 minutes ago -
Unanswered0Votes
Failure inserting into the read-only column "ID"
Hi, I have simple table without any references or constraints. It just have primary key column "ID", which is not even IDENTITY column. I'm trying to ...11 Replies | 89 Views | Denesh Kumar Mani - Tuesday, June 25, 2013 5:52 AM | Last Reply Denesh Kumar Mani - 48 minutes ago -
Unanswered0Votes
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done
I am passing variable value as input parameter to a script in execute sql task. Its a string variable in package having value C:/Archive The input parameter data type is varchar in ...1 Replies | 68 Views | JoJo_1 - 6 hours 32 minutes ago | Last Reply Bhawesh Vithalani - 1 hour 51 minutes ago -
Proposed0Votes
Run stored procedure using catalog views SSIS with SQL USER or Windows authentication user with minimum rigths!
Hi everybody I have created a stored procedure for run one SSIS package wich receive 2 into parameters value, for create my stored procedure I used the EXEC ...1 Replies | 68 Views | Armando Cervantes - 5 hours 12 minutes ago | Last Reply Bhawesh Vithalani - 1 hour 58 minutes ago -
Unanswered0Votes
Writing SSIS package to load data in new excel file every time it runs
Hi, I have a requirement in which I am writing an SSIS 2005 package, for which Excel file is a destination. Now I am scheduling this package to run every 2 hours. ...14 Replies | 233 Views | UltraDev - Tuesday, June 25, 2013 6:12 AM | Last Reply UltraDev - 2 hours 2 minutes ago -
Unanswered0Votes
How to create Excel file with parameters with SSIS
I would like to create Excel files with SQL Server 2008 R2 SSIS. Excel would consists of 10 columns of data. Is it possible to automatically define filters ...4 Replies | 84 Views | Kenny_I - Monday, June 24, 2013 9:29 AM | Last Reply Leo N - 2 hours 38 minutes ago -
Unanswered0Votes
Slowly Changing Dimension 242 error: FailOnFixedAttributeChange
TK463 Chapter 7 Lesson 1 Did anyone having trouble to execute the package DimCustomerSCD? I error I have got with Slowly Changing Dimesion ...0 Replies | 39 Views | Pei Wai - 2 hours 51 minutes ago -
Proposed0Votes
Can't pass parameter in SSIS Data Flow Task
I am working on SSIS and try to import the data from Oracle DB I am using the OLEDB Connector for Oracle with paramters to run the SQL Query, however i found it cant to pass the ...7 Replies | 100 Views | wailun3 - 22 hours 40 minutes ago | Last Reply wailun3 - 3 hours 21 minutes ago -
Answered0Votes
SSIS 2012 - System::ServerExecutionID always 0
Hello, I am writing a SQL Server 2012 data warehousing solution. I need to use the ServerExecutionID to return some information from the Catalog. I have a T-SQL which simply asks ...2 Replies | 76 Views | Mikah J Trent - Monday, June 24, 2013 8:54 PM | Last Reply Mike Yin - 4 hours 54 minutes ago -
Unanswered4Votes
How to import data from Microsoft Access 2010 to SQL 2008 through SQL Server Business Intelligence Development Studio
Hello team, I am new to SSIS package and I am trying to learn I am going to export data from Microsoft Access 2010 to Microsoft SQL Server 2008 ...15 Replies | 190 Views | GGGGGNNNNN - Saturday, June 22, 2013 5:46 AM | Last Reply GGGGGNNNNN - 6 hours 11 minutes ago -
Answered0Votes
SSIS logging sysdtslog90 Table
Hi All, I have enabled logging from SSIS under BIDS with Provider Name as "SSIS log provider for SQL Server", Description as "Writes log entries for events to a SQL ...23 Replies | 6563 Views | _Kumar - Thursday, March 25, 2010 7:01 PM | Last Reply Mauricio.Rodriguez.R - 7 hours 43 minutes ago -
Unanswered0Votes
Running on desktop but running differently in server machine
Hi, i have developed SSIS package to check data, if mismatch with text file data and db data send email notifiction. Its running correctly in my desktop (connecting to production ...5 Replies | 62 Views | neel24 - 11 hours 39 minutes ago | Last Reply Tom Phillips - 7 hours 56 minutes ago -
Proposed0Votes
SSIS and the FOREACH LOOP and no Connection String Property
Hello! I am tryng to set up a Foreach Loop. I have everything configured properly but the Expression Property does not have Connection String in it as is shown in several examples. ...11 Replies | 94 Views | EMKISER - Monday, June 24, 2013 9:10 PM | Last Reply EMKISER - 9 hours 43 minutes ago -
Unanswered0Votes
Error importing SharePoint 2010 list into SQL Server 2008 R2 database through SSIS
System.ServiceModel.FaultException: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Server stack trace: ...10 Replies | 114 Views | PShah109 - Sunday, June 23, 2013 4:09 AM | Last Reply COZYROC - 9 hours 45 minutes ago -
Unanswered0Votes
Send file using SSIS to a FTPS Site
Hi Friends, I am given a task where I will be creating flat files and will be sending them over to a different network using FTPS site. I have tried everything(May Be not), But ...5 Replies | 67 Views | Gopal425 - 12 hours 54 minutes ago | Last Reply Gopal425 - 10 hours 4 minutes ago -
Unanswered0Votes
Can tables in destination be dynamically created?
Hello all, I am grabbing everything from one table (select * from an access table) as a source in an SSIS package. I am doing it this ...4 Replies | 66 Views | newyorkfonzie - 13 hours 7 minutes ago | Last Reply ArthurZ - 10 hours 23 minutes ago -
Answered3Votes
DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
All, I’ve come across an issue with a newly created package. Several error messages are receved relating to the package's connection ...11 Replies | 22261 Views | Orlanzo - Thursday, December 20, 2007 8:36 PM | Last Reply Alberto Ortoll - 10 hours 49 minutes ago -
Unanswered0Votes
CANNOT downgrade the package from SSIS 2008 R2 to SSIS 2008
Hi, I have created a package using SSIS 2008 R2. The package has mulitple passwords that are used to connect to different DB sources to fetch the data.I have set ... -
Unanswered0Votes
Strange issue with SSIS 2005 designer - sequence container moves all but one task
I have a number of data flow tasks in a sequence container. A few minutes ago, I moved it in the designer, and all but one of the data flow tasks moved along with the others. Anyone ever ...1 Replies | 60 Views | shiftbit - Monday, June 24, 2013 7:03 PM | Last Reply ArthurZ - 11 hours 55 minutes ago -
Unanswered0Votes
Connect SSIS to IBM MessageQueues
Hello All, I want to connect SSIS to IBM Message Queues in order to submitte FCR (cobol records) to message queue and also want to read FCR from message queues But have never ...1 Replies | 56 Views | banty1 - 15 hours 26 minutes ago | Last Reply ArthurZ - 11 hours 59 minutes ago - Items 1 to 20 of 47386 Next ›
