Tips, Tricks, Pitfalls & Best Practice please: in other words e.g. Do use this connection Don\'t use this datatype
I have an oracle DB i need to talk to so i installed the drivers and added it to the system DSN Data Sources.IM ON SQL SERVER 2008 R2 64bit
I have a single Sybase user account that accesses many db/tables.I created a config file f开发者_如何学编程or each server/db connection I use in my ssis packages.What i would like to do is store the p
I have an XSD schema definition file that I \"crafted\" using Access 2007 on my flatfile with fixed-width columns/fields. Using an SSIS package, I would like to bulk insert the data from the flat file
I just want to create aconnnection 开发者_如何学JAVAto a linked server i created to an oracle db.
I have added a linked server through MS SQL Server Management开发者_如何学Go Studio successfully.It\'s name is SQL2_Link.
First the generalized problem: I need to make an ETL solution that users will be able to launch from a cloud application. I would like to make a solution where they do some simple mapping and my progr
All I want is SSIS designer, but the best option I see is \"Add features to an existing instance of SQL Server 2008\".Is it possible to just insta开发者_如何学Cll the designer if I don\'t have an inst
Environment: SQL Server 2008 R2 with SSIS and SSAS. Short question: Is there anyway to get SSIS to send the data row from a failed lookup to a trace event?
Recently when I created a SQL Server Agent(2008) job to execute a SSIS package with proxy account, it f开发者_StackOverflow中文版ailed with the below error message.What is this exception about? What c
加载中,请稍侯......