ssis
SSIS adding new columns to the Source
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[详细]
2023-04-01 12:34 分类:问答Need help on creating SSIS package for Nightly Backup and Restores of Database
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.[详细]
2023-04-01 11:50 分类:问答Project wants to check out .dtproj in SSIS project every time TFS Get Latest is performed
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.[详细]
2023-04-01 10:10 分类:问答Dynamically create table in SSIS data flow
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[详细]
2023-04-01 09:43 分类:问答SSIS LookUp is not dealing with NULLs like the docs say it should
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.[详细]
2023-04-01 09:21 分类:问答Business Intelligence Development Studio stuck Validating a task in a dtsx file
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[详细]
2023-04-01 07:05 分类:问答SSIS - Delete rows
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[详细]
2023-04-01 03:31 分类:问答SSIS 2008 pb with file system task to delete a file
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??[详细]
2023-04-01 00:56 分类:问答Setting Business Intelligence Development Studio Temp File Location
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[详细]
2023-03-31 16:38 分类:问答Importing Millions of Records with SSIS
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[详细]
2023-03-31 13:32 分类:问答