I am new to SSIS. I have a problem.i get data from two different data sources. I am able to merge them using Merge Component and feed the output to a Script component where i validate data and move it
We had a couple of database in production server. need to restore it on Staging every night for reporting pu开发者_开发问答rpose. I want to know whether I can creat a SSIS package for that.
Using Team Foundation server and BIDS 2008, I receive a screen to check out the dtproj file every time th开发者_StackOverflow社区e Get Latest operation is performed.
How can I have an SSIS data flow create a table tha开发者_运维知识库t doesn\'t exist?Every time I try to run the package, it gives me an error saying that the destination table doesn\'t exist.Since yo
I have an SSIS data flow that uses a lookup.Sometimes the value to be looked up (in my stream, not in the lookup table) is null.
I\'m using MS Business Intelligence Development Studio. This morning, when I open one of my dtsx files, BIDS just sits there, stuck validating one of the tasks in the particular dtsx file that I\'m tr
I\'m new to SSIS and need help on this one. I f开发者_C百科ound an article which describes how to detect rows which exist and which have changed. The part that I\'m missing is how to update rows that
in my foreach loop container, I would like to delete the current processed file. I try as follows, but no file is deleted at the end, any idea??
Is there a way to specify where temp files are created when building SSIS packages using SQL Server Business Intelligence Development Studio? Currently it saves them at C:\\Documents and Settings\\\\L
Any tip开发者_Go百科s for speeding up the import processes?Theres alot of Joins in the db. Also, when a SSIS task is completed, would the best way to handle the next functions by code or using the Em
加载中,请稍侯......