I have taken ownership of a very complex SSIS package with multiple files and routes. Is there an easy method of process mapping the whole process开发者_如何学编程 automagically so I can print it out
I dragged Execute t-sql statement task from toolbox. clicked new and created new connection. when i executed, it executed successfully. there was no db showing in con开发者_Python百科 string.
What\'s the best way to strip out characters from flat files in SSIS? In my case, I need to remove all quotes from the file before processing.
I\'m attempting to use the SSIS 2008 lookup component in full cached mode with a T-SQL Query. Is there any benefit to using a ORDER BY clause in the T-sql.
SSIS is great at handling flat files where all the records are the same, but not so good when there is a little complexity.
I have a DTSX file in a project I\'m taking over. I have Visual Studio 2005 Pro, but it just opens it as an XML file. SQL Server Management Studio 2005 does the same.
I have a table with a list of contract line items in the form of CREATE TABLE contracts_lines ( contract_id integer,
I am copying some user data from one SqlServer to another.Call them Alpha and Beta.The SSIS package runs on Beta and it gets the rows on Alpha that meet a certain condition.The package then adds the r
SSIS package is just importing from txt file to sql database. when we made the package were using old file and its executing fine.the old source file got (10 columns)
How can I declare a package variable in SSIS as int? (nullable int). Ex: if I got variable Var1 as int in SSIS which maps to my db column (nullable).
加载中,请稍侯......