I have a table with a column type of xml. I also have a directory that can have 0 to n number of xml documents. For each xml document, i need to insert a new row in the table and throw the xml in开发者
SSIS comes with many tasks that solve data acquisition and intrgration problems, but one task that it lacks is \'HTTP Task\' for downloading files over HTTP.
Here is my situation. I have got Table A in database DB1(sql server) and Table B in database DB2(sql azure) with same table structure. I need to compare the data in table A and Table B and add the m
I have a complex Task flow that in general creates data warehouse content from Prod to a local DW server and then a copy of that to an offsite location.
I have a CSV I\'m trying to import into SQL using SSIS packages through code. A line might look something like this
In my application,开发者_如何学运维 user can specify the format of their file. Based on user input we dynamically create SSIS package.
I am trying to write an SSIS package that connect to an XML feed to download FX rates and import 开发者_C百科them into an SQL table.
I have a folder on the network with files and I\'m moving the files from one folder to another folder. But I only want to move new files, so only copy over files that do not exist in the destination f
I won\'t have access to SSIS until tomorrow so I thought I\'d ask for advice before I start work on this project.
Problem -I have an excel spreadsheet generated a lotus app. It smells and looks like excel but Excel Source data flow source can not recognise it. When trying to select a table(tab) i get the followi
加载中,请稍侯......