ssis

相关标签：javascript jquery android 多少钱 iPhone

SSIS: importing files some with column names, some without

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[详细]

2023-04-11 08:08 分类：问答
Sybase ASE OLE DB Connection in SQL Server Integration Services 2005

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[详细]

2023-04-11 07:08 分类：问答
SSIS 2008 r2 how to connect to FTP using SSL

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[详细]

2023-04-11 05:07 分类：问答
Logging information when executing remotely SSIS from ASP.NET

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[详细]

2023-04-11 02:52 分类：问答
Fuzzy lookup transformation in SSIS

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...[详细]

2023-04-10 20:05 分类：问答
Stored procedures in SSIS Packages

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[详细]

2023-04-10 15:46 分类：问答
SSIS - how can I see where a connection is used?

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[详细]

2023-04-10 14:48 分类：问答
tutorials or url on how to design an etl that loads data in Dimension table in sql 2008 r2

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[详细]

2023-04-10 02:01 分类：问答
Can ReSharper be used when editing SSIS script tasks?

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[详细]

2023-04-10 00:04 分类：问答
Long running query on a self joined table

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:[详细]

2023-04-09 20:11 分类：问答