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
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
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
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
I just want to make sure i am doing this correctly. Derived columns: car truck Lookup (after derived column:)
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)
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
I need to select the the total number of rows with a certain ID IF it equals the total max rows in table.
Im new to ssis , I have a table like ↓ notablename 1table1 2table2 3table3 what I want use ssisto do is ....
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
加载中,请稍侯......