I am new to SSIS in data warehouse. I am using Microsoft business intelligence studio. I have 5 Dimensions each having some PK.
I am looking for a way to pull XML from a SQL database and shred the XML via SSIS in bulk. I currently have a package that can pull XML from the database and pass the XML to a stored procedure, via va
I have an execute sql task that executes within the package level onerror event.The task will run just fine if it\'s not within the开发者_C百科 onerror event, however, if it\'s sitting in the flow for
I\'m in a QA department of an internal development group. Our production database programmers have been building an SSIS package to create a load file from various database bits for import into a thir
I have build a开发者_JAVA技巧n SSIS package to update Oracle database from the data which is coming in Flat Files.This file contains 4 columns part of which shown below:
I\'m working in SSIS and Visual Studio 2008. When executed, I need to have the SSIS package perform the following tasks:
Could someone guide me on how to convert 开发者_运维问答MM/DD/YYYY HH:MM that comes from a flat file source as a string to a datetime to a ole db destination using the derived column.
How many excel files can an SSIS package able to open and insert if 开发者_运维百科the data in my excel files are less than 500KB?Here it was tested for XML connection test - there is no known limitat
I am trying to import data from a utf-8 enc开发者_运维百科oded flat file into SQL Server 2008 using SSIS. This is what the end of the row data looks like in Notepad++:
Is there a standard messaging protocol(s) / API(s) available to keep databases in syn开发者_开发问答c. Or alternatively API(s) for creating and parsing messages.
加载中,请稍侯......