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
Calling webservice dynamically
Hi, I was given a web service url and documentation. In the documentation they have written that the basic request as below. <soapenv:Envelope ... -
Unanswered0Votes
new to ssis
hi all am new to ssis i created one simple package with lookup table 1 with 2 fields (id and country name) id ... -
Unanswered1Votes
Create dynamic pivot columns using two tables in sql server
0 Begin Select @f1 = idt from @table Where Id = @x Set @Sql = 'If Exists( ... -
Proposed1Votes
Database Connection error when executing the package from .bat file
.\Logs\ABC_log. Today we have promoted the packages to Dev Server which is 2008 server(64 bit) machine. It has SQL server 2008 R2 installed on it along with VS ... -
Proposed0Votes
Extract data in particular date period
Hi, I would want to extract data from 15th of the last month to 17th of the current month. Can anyone tell me how i can achieve this using expression if i have ... -
Answered2Votes
Extract Data From Google analytics to sql server
Hi All, I need to read the data from google analytics to load into sql server data base using ssis. I am sure there is way to do this but i am not sure ... -
Unanswered0Votes
How to load data from Google analytics to SQL SERVER 2005
Hi All, Is there any solution to load data from google analytics (API) to SQL Server 2005. Many ... -
Answered0Votes
Derived Column Experession
Hi, I have this expression ISNULL(geo_subregion) || ISNULL(DWgeo_subregion) ? !(ISNULL(geo_subregion) && ISNULL(DWgeo_subregion)) : UPPER(geo_region) != ... -
Answered0Votes
ErrorColumn value has value as ID of the column not lineageid of the column
Hi There, I have developed a dataflow task in a package, so that when ever i get a error, it has to redirect the row to a different table, also i am mapping errorcolumn to that ... -
Answered0Votes
How to get ErrorColumnName in SSIS 2012
Hi there, Please let me know how to get error column name in SSIS 2012 with out creating any additional ... -
Unanswered0Votes
Transforming Duplicate Data Record
Hello! I am working on a table with a foreign and a Primary Key Constraint. It happened that the primary key field is an nvarchar data type. Now, the issue is that there are so many ... -
Unanswered0Votes
How can I change my Execute SQL task setting to behave like SSMS and continue dispite errors
My insert below in ssis produces 26 rows, vs. 86 in ssms. I assume it timesout but I am not sure? I'd like to get the same behavior. I changed MaximumErrorCount to ... -
Proposed0Votes
SQL server agent SSIS error
I get the following error when I execute my package as a SQL server agent job. It is an SSIS 2008 package running on a SQL Server 2008 instance. My package security is ... -
Unanswered0Votes
LineageId String or Integer
Hi, I'm trying to fetch lineageId of output columns in a SSIS Package. I'm traversing SSIS Package as XML Document in C# code. No issue in traversing and fetching ... -
Answered0Votes
Text Qualifier and Bulk Insert Task
I am trying to understand how the "Text Qualifier" property on a Flat File Connection applies to Bulk Insert Task (which uses a Flat file as the Source connection). It appears that there is ... -
Proposed0Votes
SSIS 2008 R2 - Script task fails when run as job
System.Runtime.InteropServices.COMException (0x800A03EC): Microsoft Excel cannot access the file 'G:\ReadingEggFTP\AU\20130619\readingeggs_3pau_school_marketing_customer_list_20130619.csv'. There are ... -
Proposed0Votes
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 ... -
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 ... -
Discussion0Votes
executing script task in SSIS
I am getting error with "object reference not set to an instance of an object". Can anyone help me with programming error. I am not SSIS experts nor ... -
Unanswered0Votes
Multiple simaltaneous update in custom log table from SSIS package.
Hi, I have a custom log table in sql server database. which recording the SSIS package activities(each task execution time, statuses...) when this table is going to use ... - Items 1 to 20 of 47303 Next ›
