No announcements
Categories
-
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 OfficeVisual 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
-
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 Machines
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 ...
-
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 ...
-
Unanswered0Votes
Data Flow Tasks Deadlocking each Other
Hi Experts I am using a SSIS package that does the following task - and Retain Same Connection is Set to TRUE A) Execute SQL Tasks - BEGIN ... -
Answered0Votes
Compress Zip File with SSIS
With standard SSIS tools (without having to download/install anything), can some one tell me what steps I need to take to compress/zip an excel file? I want to take this file, ... -
Unanswered0Votes
SSIS DFT Problem
Hello , I am working on SSIS package, environment : BIDS 2008. I am using a data flow task, that contains one excel source component at the ... -
Proposed0Votes
data flow task- task not completing (not changing from Yellow to Green)
I am using data flow to get data from a source and loading that into a destination. There are 6k rows in source, after running the job 6k rows gets loaded ... -
Unanswered0Votes
'BufferManager.GetColumnCount(input.Buffer)'
I'm using SQL Server 2012 and building SSIS package in .NET 4.0. I'm trying to use the code from IDTSBufferManager100 Using the code in the Script ... -
Answered0Votes
One Excel row need to be inserted as two rows in sql server database
Hi All I need to load data from excel to oledb destination using SSIS. But excel was different which looks like as ... -
Unanswered0Votes
SSIS 2008 R2 - Script task fails when run as job
Hi I have a script task which opens a csv file using excel and save it as Excel File. I chose this method after a long struggle to use it as flat file source (too many issues ... -
Unanswered0Votes
msgbox not opening when error found
Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: The element cannot be found in a collection. This error happens when you try to retrieve an element from a collection on a container ... -
Unanswered0Votes
Not able to browse to shared network path
> add a network location) but still that drive doesn't appear. I'm using Windows 7. Any ... -
Unanswered0Votes
SSIS 2008 Oracle 11g On 64 bit Linux
I am completely new to SSIS. I am sorry if I am stupid with questions I am not able to connect to Oracle Database using connection manager in SSIS 2008. I ... -
Unanswered0Votes
SSIS project build hung in VS2012 command line with SSIS BI installed
I installed latest version of SSIS BI package of 6/7/2013 (version 11.0.3369.0). When I try to build a SSIS project in VS2012 command line (with devenv.com), the build process frequently just hung ... -
Answered0Votes
Fail to build SSIS/SSAS projects via VS2012 command line (devenv.exe) with SSDT BI tool installed
Hello, I installed recently released SSDT BI tools for VS2012 and I can work on my existing SSIS/SSAS projects all well in VS2012. But when I try to build my SSIS/SSAS projects ... -
Answered1Votes
call a ssis package
I have a sqlcmd file that is used to load and create a database schemas including tables, view, function etc. At the end of the file, I would like to call to run a SSIS package. ... -
Unanswered0Votes
Populate project level connection manager parameter in SSIS 2012
I have a list of connection string values stored in a table. I want to be able to populate the project level connection string parameter with one of these values from that ... -
Unanswered4Votes
Validate URL format in a column - SSIS
Hi, I have a table with 4 columns. One of them contains URLs. Is there a way to validate the URL format in SSIS and have two outputs, one output will have ... -
Answered2Votes
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 ... -
Unanswered0Votes
Mysql to Ms Sql 2005 - Linked Server query select query
I created Linked server in Sql server 2005 and tried Data Migration from MySql to MS Sql 2005 but some of the data got rejetced and i need to find out that which data got ... -
Unanswered0Votes
Protocol error in TDS stream
I am trying to import this huge table from a different server and regularly getting this error. I checked online for this error dint get any fix for ... -
Unanswered0Votes
For loop inside For Loop (Nested For Loops)
Hi, I have sequence container, in which there are nested loops. When i execute the container it works fine (it loop thru each year and each Year Month), but when execute the ... -
Unanswered0Votes
Renaming the file with File System Task
The below expression is working fine and I am getting the Date with File name. @[User::SourcePath] + (DT_WSTR, 100) (DT_DBDATE) GETDATE() + SUBSTRING( ... - Items 1 to 20 of 47320 Next ›
