OrPresumably due to inconsistent configuration of logging devices, I need to load a collection of csv files via SSIS that will sometimes have a first row with column names and will sometimes not.The f
I am building a SQL Server 2005 Integration Services package to migrate data from a Sybase Adaptive Server Enterprise 12.5.4 database to a SQL Server 2005 Database.The Sybase Database is the backend f
Is there a way to connect to an FTP u开发者_Python百科sing SSL in SSIS. The FTP connect in SSIS is without SSL option, what to do if the option of buying is not an option?I would use a third-party too
I have a web server (no Integration Services installed) and a seperate SQL server. I have created an ASP page to remotely 开发者_StackOverflow中文版execute a SSIS package by firing up an Agent job on
HI now i have id with me but in other table so now i did inner join for matching both security id and taking out companyid...
We are doing a huge Data Migration Project using SSIS packages. We were insisted on not using stored procedures in SSIS packages. Can you please suggest whether we should be using stored procedures in
Is开发者_如何学Python there a quick way to determine where within a package a connection is used?within visual studio you can search for all instances of the connection string with
How can design an ETL that is able to load new recordsin dimension tableand automically primary keys or surrogate keys are assigned to new record开发者_运维问答s in a dimension table. Please helpwith
I have ReSharper 6 installed and integrated with Visual Studio 2008 and Visual Studio 2010. I\'m editing SSIS packages in VS2008 and some of the开发者_如何转开发m contain script tasks. When editing th
I try to improve the performance of a query which updates a coloumn on each row of a table, by comparing the actual row\'s values with all other rows in the same table. Here is the query:
加载中,请稍侯......