I have i开发者_运维知识库nherited a SSIS package which contains a bulk import task. The bulk import tasks uses the following format file:
This is quite a strange problem, wasn\'t quite sure how to title it. The issue I have is some data rows in an SSIS task which need to be modified depending on other rows.
I have a synchronous transformation script compon开发者_如何转开发ent, with some input columns, and an extra defined Output column \"ID\". ID outputs an integer (DT_I4) type. Under certain circumstanc
I have updated my SQL Server 2008 R2 Evaluation Edition to Enterprise Edition a couple of weeks ago. Service Pack 1 is also installed. Things were going good for a开发者_开发技巧 while . But when I ru
I have a Data Flow task with an XMLSource that references an XML Variable. The DataFlow task does recognize that there are x number of rows in the variable, but it only sees null values in every row:
I get an input CSV file that I have to upload to my oracle database. Here is some sample data ContractId, Date, HourEnding, ReconciledAmount
I am executing a SQL Server 2000 DTS package using C# by following the code from this article http://support.microsoft.com/kb/319985. once the package is executed I am looping through each step to fin
I\'m stuck trying to get SSIS 2008 to read an Excel file. Yesterday, I migrated our SSIS project from 2005 to 2008, and though the upgrade said it worked, I cannot get it to read an Excel file.I read
Is there a way to \"cascade\" new column information down through the subsequent data flow transformations when I add a new column?My curre开发者_如何学Gont practice is to open each tranformation in s
In a Flat File Source in SSIS I am trying to u开发者_高级运维se the FileNameColumnName property (from Advanced Properties) to populate a field in a database.It seems quite straightforward - I simply g
加载中,请稍侯......