ssis_开发者

Excel cells with date values not importing properly via SSIS

I have an Excel \'97 spreadsheet that is generated by an external automated process that I would like to import into a SQL [2008 R2] table via SSIS.The column I am importing contains text values in so[详细]

2023-04-13 07:13 分类：问答

Executing SSIS Package as SQLAgent Job

I have a SQL Server 2008 SSIS job which executes some Win 32 exe files. This job runs fine when i execute the job through BIDS (On Windows 2008 box). Now i have deployed the package in MSDB database a[详细]

2023-04-13 04:26 分类：问答

Using SSIS 2008 R2 to load only new data into an existing table from an excel (xls) file

I would like to be able to load data from an excel file into a table within SQL server 2008 R2 via SSIS. However if a cell value is not defined within the excel source, then the original table data sh[详细]

2023-04-12 22:28 分类：问答

Reading Data Pump Task in DTS without having source and destination environment

I am working开发者_如何学运维 on migrating a DTS package which contains a oledb source (but we dont have access to the source), a olebd destination (but we have access to the dest.) and a DATA Pump Ta[详细]

2023-04-12 21:31 分类：问答

ssis lookup with derived columns?

I just want to make sure i am doing this correctly. Derived columns: car truck Lookup (after derived column:)[详细]

2023-04-12 20:23 分类：问答

stop Winzip from opening up explorer window

We are testing download an unzip of multiple files. Commands very similar to the ones shows are executed from a batch file (called from SSIS)[详细]

2023-04-12 18:06 分类：问答

SSIS retrieving current folder within a foreach loop traversing subfolders

I use SSIS to read .txt files in input and execute my business logic over them saving the output resul开发者_如何学Cts in a file whose name is the same as the current inpout file (file name dynamicall[详细]

2023-04-12 12:52 分类：问答

only select count value if total row count is equal to row count with special ID

I need to select the the total number of rows with a certain ID IF it equals the total max rows in table.[详细]

2023-04-12 08:57 分类：问答

How can I create a ssis job to export tables to file

Im new to ssis , I have a table like ↓ notablename 1table1 2table2 3table3 what I want use ssisto do is ....[详细]

2023-04-12 04:43 分类：问答

Fill XML file with SSIS

With the help of the following blog: I created a SQL Server Integration Services (SSIS) package. Reading from a .txt f开发者_StackOverflow社区ile I am able to create a relative XML file and save it in[详细]

2023-04-12 03:57 分类：问答