SSIS - Add A New SQL Server Mobile Destination
Nov 14, 2005Hi, I try to add a new SQLMOBILE Connection.
View 6 Replies
ADVERTISEMENT
SSIS Ntext Datatype And SQL Server Destination
Sep 11, 2007
Hi folks,
We have a nice issue here. We are running SQL 2005 Dev edition Service Pack 2 and we are trying to copy the contents of one table in a local sql server database to another table in another database on the same local sql server. We use an oledb source and a sql server destination. The table structure is exactly the same. One column is of the datatype ntext, when we try to load the contents the package will stop with the error:
OnError 11-9-2007 14:38:24 11-9-2007 14:38:24 00:00:00 The attempt to send a row to SQL Server failed with error code 0x80004005.
OnError 11-9-2007 14:38:24 11-9-2007 14:38:24 00:00:00 SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "<TABLE>" (3382) failed with error code 0xC02020C7. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
OnError 11-9-2007 14:38:24 11-9-2007 14:38:24 00:00:00 SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC02020C7. There may be error messages posted before this with more information on why the thread has exited.
OnError 11-9-2007 14:38:26 11-9-2007 14:38:26 00:00:00 SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E07.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E07 Description: "Error converting data type DBTYPE_DBTIMESTAMP to datetime.".
OnError 11-9-2007 14:38:26 11-9-2007 14:38:26 00:00:00 A commit failed.
Removing the column from the sql server destination will result in loading the complete table. Using an oledb destination instead of sql server destination fixes the problem. Is this a bug in the SQL server destination component?
Thanks,
Marc
SQL Server 2014 :: SSIS SharePoint List Destination?
Mar 24, 2015We are just looking to move to SSIS 2014 from 2008R2 however we have a number of packages which write to Sharepoint lists. The SHarepointDestination doesn't seem to work in VS 2013, any solution other than buying a third party connector.
View 1 Replies View RelatedSSIS Web Service To XML Source To SQL Server Destination Problem
Jun 5, 2007Hi,
I have an SSIS package which calls a web service and returns a Dataset object in the form of an xml file (it does this successfully - and stores it successfully).
The Data Flow then picks up the file using an xml source task (in which use inline schema is specified) , and passes it to an SQL Server Destination task - for bulk load.
I've checked the mappings and everything seems to be ok, the package gives no warnings or errors when run.
The destination table is created on the SQL Server without problem, but at that stage the task finishes "successfully", without actually loading any table rows into the destination table.
Also in the SQL Server Destination task - when I select "preview" in the connection manager section - I can see the column definitions, but again - no rows of data.
Thanks to Simon Sabin for pointing me here - I did post on the managed msdn newsgroups in sql server programming but have had no replies as yet.
Below is the beginning of the xml Dataset object which is output as an xml file for information. If you need any more information just let me know.
Not quite sure where i'm going wrong here - thanks in advance
Crispin.
Code Snippet
<?xml version="1.0" encoding="utf-16"?>
<DataSet>
<xs:schema id="callStatisticsDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchemahttp://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</A< A>>" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="callStatisticsDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Table">
<xs:complexType>
<xs:sequence>
<xs:element name="date" type="xs:dateTime" minOccurs="0" />
<xs:element name="callID" type="xs:int" minOccurs="0" />
<xs:element name="cli" type="xs:string" minOccurs="0" />
<xs:element name="itemClosed" type="xs:string" minOccurs="0" />
<xs:element name="custProdId" type="xs:string" minOccurs="0" />
<xs:element name="itemSaleId" type="xs:string" minOccurs="0" />
<xs:element name="phoneNumber" type="xs:string" minOccurs="0" />
<xs:element name="lastXml" type="xs:string" minOccurs="0" />
<xs:element name="followedPath" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
<callStatisticsDataSet>
<Table diffgr:id="Table1" msdata:rowOrder="0">
<date>2007-06-04T08:03:10.02+01:00</date>
<callID>85560695</callID>
<cli>648477292</cli>
<itemClosed />
<custProdId>-1</custProdId>
<itemSaleId />
<phoneNumber />
<lastXml />
<followedPath>Initialize #waitList;|tvShop.CallInitiated;|Is not closed?;|No item on sale;|Store Items;</followedPath>
</Table>
SQL Server Mobile Merge Replication Walkthrough, Cant Find The .NET Framework Data Provider For SQL Server Mobile Edition.
Sep 9, 2005Hi,
View 3 Replies View RelatedSource And Destination Databases On Same Server While Data Transfer Using SSIS
May 9, 2007Hi,
I am having one query regarding data transfer using SSIS. If we use
DTS packages for the data transfer between two databases then the source database and
destination database must be on different db servers or instances.Here, I
am talking about the DTS Packages with Distributed Transactions enabled.
I need to know that whether this constraint has been rectified with SSIS Packages or it still persists.
One more thing is that while transferring the data, can we view/insert/update source database or it is locked if the transfer is in process.
Please reply..........
Thanks and Regards,
Rajesh
SSIS And SQL Server Destination And Invalid Data For Type Numeric.
Oct 11, 2007We have an SSIS package that reads in a tab delimited file and throughs the data into a SQL Server 2005 table. The package worked fine on the test files but when we recieved the production files we are getting the error message:
Invalid data for type "numeric".
Needless to say this is not very discriptive. I ran a trace on the DB durning the call and its doing a bulk insert
BULK INSERT [dbo].[FNIAllAppData]
FROM 'GlobalDTSQLIMPORT 00000000000015b800000000009fbd88'
WITH (DATAFILETYPE = 'DTS_Buffers', CODEPAGE = 'RAW', CHECK_CONSTRAINTS, TABLOCK)
When I changed the Data Flow Destination off to OLE DB Destination the error does not occure and all records are loaded successfully.
Any suggestions or help would be appreciated. Thanks.
SSIS Programmaing - How To Map Flatfile Source Columns To SQL Server Destination?
Dec 7, 2007Hi,
I am new to SSIS programming and trying to export data from a flatfile source to SQL server destination table dynamically. I need to get the table schema info (column length, data type etc.) from SQL server table and then map the source columns from flatfile to destination table columns.
I am referring to one of the programming samples from Microsoft and another excellent article by Moim Hossain. Can someone help me understand how to map the Source columns to destination table columns depending on table schema? Please help.
Thanks
SQL Server 2008 :: SSIS To Import And Update Data If Exist On The Destination?
May 25, 2015I am working on SSIS wehre I need to work on a flat file as a source and needed to import it to database. If the destination table have the record already, I need to update it and if not exist, I just need to import the whole data.
View 9 Replies View RelatedSQL Server Mobile 2005 Merge Replication Problem On Windows Mobile 5.0
Aug 8, 2006
Dear ppl,
I am writing an application for a device (MDA Pro T-Mobile) having Windows Mobile 5.0 using
-MS .NET Compact Framework 2.0 SP-1
-SQL Mobile 2005.
-VS 2005 .NET
The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object.
"SQL Server Mobile encountered problems when opening the database."
repl.AddSubscription(AddOption.CreateDatabase);
repl.Synchronize();
I don't understand why I am having this error. It does create the database on AddSubscription() method but it is failing opening the database on Synchronise(). I have also tried uninstalling and then reinstalling all the SQL Mobile components in the following order.
-sqlce30.wce5.armv4i.cab
-sqlce30.repl.wce5.armv4i.cab
-sqlce30.dev.ENU.wce5.armv4i.cab
However, when i run this application on a device(Dell X50 AXIM) with Pocket PC 2003, it runs fine creating the database and sysnchronising it.
The target platform for the project is Windows Mobile 5.0 Pocket PC SDK.
Does any one have any clue what could be the problem ?
Regards
Nabeel
Problem Using SQL Server Mobile 2005 With Windows Mobile 5 Application
Mar 23, 2006Hello,
I am developping a non-managed C++ application for PocketPC using a SQL Server mobile database.
The application is compiled for PocketPC 2003 and uses SQL Server Mobile v2. I use Visual Studio 2005. But I need to compile the application for Windows Mobile 5.0 devices. So I installed the WM5 SDK and had the WM5 into my project configuration.
The "ssceoledb.h" which I include incluses the "transact.h" file. But my problem is that this file is only provided with the PocketPC 2003 SDK and not in the WM5 SDK.
So I cannot use the WM5 configuration project with SQL Server. I also tried with the last SQL Server Mobile 2005 (ie v3.0) and the "ssceoledb30.h" also includes "transact.h".
Did I miss something to install ?
Do you know how I can resolve the problem ?
By advance, thank you for any answer.
--
Gregoire
Cannot Build SQL Server Mobile Solution For Windows Mobile 5
May 18, 2006Using MS VS 2005 (incl SQL Server Mobile)
MS Pocket PC 2005 SDK
I am working on a project that builds for Pocket PC on both Mobile 2003 and Mobile 5. The project uses/will use SQL Server Mobile to store local data.
Project created from new with support for both platforms. I include required header files ssceerr30.h and ssceoledb30.h.
Project builds fine in WM2003 configuration, release and debug.
When I build for WM5 the compiler cannot find the header file transact.h. This is included from within ssceoledb30.h. Same as under WM2003.
In WM2003 configuration if I highlight the ssceoledb30.h include in Visual Studio and open the header, it takes me to <Visual Studio dir>SmartDevicesSDKSQL ServerMobilev3.0. I then locate the include for transact.h and do the same, which takes me <Visual Studio dir>SDKPocketPC2003include. The file exists.
If I repeat the above 'browsing' under the WM5 configuration, ssceoledb30.h takes me to a different copy in the WM5 SDK directory. There is no diff between the file here and the other copy used by WM2003. If I attempt to open transact.h - file does not exist.
Fix (which I'm not too sure about, i.e. is it OK?) - If I copy transact.h to the WM5 SDK directory, the project builds.
Why has transact.h disappeared from WM5 SDK?
I can find no ref's to this problem anywhere. Is my installation of the WM5 SDK corrupt? What else could I be missing?
Is there a sample for SQL Server mobile (like the NorthwindOLEDB sample) that comes configured to build for WM5?
SQL Server Mobile Tutorial And Getting Proper Mobile DB Installation
Apr 24, 2006Hi folks, I'm new to Windows Mobile progamming, and new to this forum. Apologies in advance if I'm asking a boneheaded question, but I've done searches and can't find anything directly applicable to my problem.
I'm currently walking through the published MS tutorial in setting up an SQL Server 2005 Mobile application that subscribes to a publication on SQL Server 2005 to exchange information.
I've gotten almost all the way through... successfully set up the server components, creating the publication, etc. On the mobile side, I've been able run the cab files to install the SQL Mobile components and to create the project, add the reference to the dll, and instantiate an engine object. It compiles.
The step in the tutorial after that, though, where you specify the data source from the "data" menu, I've got a problem. When I try to use the "new connection" dialog from choosing the data connection, "MS SQL Server Mobile Edition" doesn't show up as a choice. I've tried choosing any of the other combinations, and in teh subsequent "Connection properties" section my database, SQLMobile (as in their sample) is available, but I get an error when I choose it and click OK. Clicking on "Test Connection" gives me a connection successful message.
My guess is that something about the Mobile server side components is not installed correctly on my development machine, but honestly I have no idea how to begin to fix it. Has anyone seen this problem before and know how to resolve it?
Your time and any knowledge sharing is greatly appreciated.
Thank you,
-Dana
SQL Server 2005 Mobile Edition ANd SQL Server CE - SHould I Have Uninstalled Mobile First ?
Sep 16, 2007
Hi:
When I try and connecto to SQL CE I always get an invalid operation exception. I"m afraid that I did not follow the proper install for Orcas Beta 2. I can't remember if I was supposed to uninstall SQL Mobile 2005 first or not.
All I know is when I try and use my SQL CE I can't connecto to a DB / sdf file ?
Any help would be appreciated I"m just starting to use SQL CE.
thanks
mark
Creating A Mobile Application With SQL Server Mobile - FIX
Jul 21, 2006This is a great tutorial and it's a shame one of the more important steps was missed.
In the €œCreate the snapshot user€? section you you find the steps to create the snapshot_agent account. Then in the €œCreate the snapshot folder€? section you find the share and folder permissions. However, at no point do the instructions advise you about adding the snapshot_agent to the SQL Server Logins. The result is that agent cannot perform the initial snapshot but you won't find this out until 50 steps later after Step 10 in the section €œCreate a new subscription".
To get back on track, openthe Object Explorer's Security section and add the snapshot_agent to your logins. Then using the "User Mappings", set an appropriate level for the SQLMobile database role. Once completed you then need to run the agent.
Right-click the SQLMobile publication you created and select "View Snapshot Agent status". From that dialog you can select "Start" to run the agent. When it completes, you can return to the tutorial section "Create a new subscription" and continue with the tutorial.
Creating A Mobile Application With SQL Server Mobile
Nov 3, 2007I am studying the tutorial in SQL Server 2005 Mobile Edition Books Online, and the topic is Creating a Mobile Application with SQL Server Mobile. I have got a problem when creating a new subscription after created a new SQL Server Mobile database. And the problem is shown below:
New Subscription Wizard
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
* Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)
* 無法完æˆ?作æ¥ã€‚
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
Before I have met this problem, I have finished all the task. And I can browse the localhost web site by using anonymous account even I use internet explorer or browse the directly in IIS.
Does anyone can solve it?? Thank you very much~~~
ODBC Destination In SSIS
May 14, 2007I read that Integration Services does not come with built-in support for ODBC destinations, so I tried to write Script component as destination task.
My destination is odbc for oracle, and it failes with the message:
"Null password given, logon denied".
I can't understand it, I used with the same connection with datareader source and it works.
I spent a long time on this problem, please help me.
Thank you in advance
Noam
ODBC Destination In SSIS
Aug 10, 2005Hi!
I have a problem that stops me from using Integration Services as THE ETL tool.
My goal is to load a data warehouse type of a database. The database is MaxDB (former SAP DB), but this is not the point. Let's take ANY ODBC compliant DB and assume all I have is ODBC driver - no OLE DB driver.
I figured out how to read from ODBC source (using Data Reader and ADO.NET provider for ODBC).
Now my question is how do I output/write my data into ODBC source? When I try to use OLE DB Destination it does not give me an option to use .Net Provide for ODBC. I tried other "destinations" with no luck.
I use this version of SQL Server 2005: (Microsoft SQL Server 2005 - 9.00.1187.07 (Intel X86) May 24 2005 18:22:46 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
Please, help!
Dima
Destination Spreadsheets In SSIS
May 16, 2007
Hello -
I am dealing with SSIS in VS 2005... Trying to convert all my DTS packages... So, basically all my packages will extract some information from a database and load the results into a spreadsheet.
To start I am trying to do a TOP 1 returning a string from the db... The first row has column names but mysteriously the package will start to write the expected results in the third row instead of the second one. The second row will remain blank and if I do a preview against the destination spreadsheet within the pkg I will see a NULL value in the second row and then in the third row I will see the string I was expecting.
Tried the following with no success:
Regedit.exe, in Hkey_Local_Machine/Software/Microsoft/Jet/4.0/Engines/Excel/ do TypeGuessRows=8, ImportMixedTypes=Text, AppendBlankRows=0, FirstRowHasNames=Yes
Any help would be really appreciated.
Changing Dynamically The Destination Name In Ssis
Apr 15, 2008i am transfering the table from one database to csv file format..i did it.. again i want to shift that csv files to another databse as tables. how to do this task.. pls help me.. its very urgent..out TL had given me the dead line.. send reply soon....
View 5 Replies View RelatedSSIS - ERROR OUTPUT In OLE DB DESTINATION
May 16, 2008
Am new to SSIS and developing a component which pulls data from a staging table and drops them into another table in the same database.
Am using a
1) OLE DB Source to get the data from the staging table.
2) OLE DB Destination to insert or push the data into another table of the same database.
3) Script component to get the error rows and to update the staging table column with a flg value.
The rows that throw an error like primary key violation, or any other error should be redirected to the script component and the process should get completed.
The Error Output of the OLE DB Destination doesnt show any columns to be selected for Redirect Row option
The script executes without any error and the records are shown in error path but the records are not updated in the DB.
This is what i have in the script
Public Class ScriptMain
Inherits UserComponent
Dim sqlConn As SqlConnection
Dim sqlCmd As SqlCommand
Dim connMgr As IDTSConnectionManager90
Dim txnIdParam As SqlParameter
Dim errorDescParam As SqlParameter
Public Overrides Sub AcquireConnections(ByVal Transaction As Object)
connMgr = Me.Connections.ErrorConnection
sqlConn = CType(connMgr.AcquireConnection(Nothing), SqlConnection)
End Sub
Public Overrides Sub PreExecute()
sqlCmd = New SqlCommand("UPDATE STG_TRANSACTION SET ERROR_FLG='Y' AND ERROR_DESC=@errorDescParam WHERE TXN_ID=@txnIdParam ")
fueltxnIdParam = New SqlParameter("@txnIdParam", SqlDbType.BigInt)
errorDescParam = New SqlParameter("@errorDescParam", SqlDbType.VarChar)
sqlCmd.Parameters.Add(errorDescParam)
sqlCmd.Parameters.Add(txnIdParam)
End Sub
Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
sqlCmd.Parameters("@txnIdParam").Value = Row.TXNID
sqlCmd.Parameters("@errorDescParam").Value = Row.ErrorCode
End Sub
End Class
Pleas let me know the solution and any help will be appreciated.
ODBC Destination Issues With SSIS
Nov 29, 2006Hi All,
In Migrating from DTS to SSIS we have scenario where data from OLE DB (SQL Server) is inserted into ODBC source (transoft driver). In case of DTS, ODBC component was provided. For SSIS we used the Destination Script Component and programmatically used the ODBC related calls to design similar functionality. However we are getting the following error €“
Error[42000][Transoft] [TSODBC][usqld] Name expected@
However the same program pointing to Microsoft Access ODBC driver works fine.
Any help in this direction will be greatly helpful.
Thanks,
S Suresh
SSIS Excel Destination Error
Jul 11, 2006ts my first time trying to set up a SSIS job using the import/export wizard to export the results of a query into an excel file.
i am using sql server 2005, windows XP SP2.
In the last step in the excel destination editor, in the connection manager when i am trying to select the excel file to write into i am getting this error.
'Microsoft.Jet.OLEDB.4.0 ' provider is not registered on the local machine.
I have set up the excel connection manager. i have changed the properties of the project to set
the Run64BitRuntime to false.
i am running the latest version of MDAC 2.8 on the machine too
please let me know if there is anything else i need to do to fix this.
thank you in advance
Is There Any Word Document Destination In Ssis
Nov 28, 2007Hi,
I have a doubt regarding SSIS data destinations. I have a word document which is stored in the sql database table as varbinary(max). I want to fetch that doument and load it into word document through ssis.Is it possible?If so,how to do it?
One more question regarding data destination..I have created an interface to execute the ssis package from asp.net application.The package will be run by sql server agent.The question is is there any way that the package output will be shown on the local machine rather than host machine(which has interface and package).
Thanks..
Have a gr8 day.
SSIS: For Each Loop: Destination Error
Feb 19, 2007Hey Guys.
I am new to using SSIS and need some assistance. I am trying to create a package that will loop through a folder of DBF files and import them into SQL server. Here is what I did so far:
- Created a Foreach Loop Container with a Data Flow Task within
- Created a string variable to store the file names
- Created the OLE DB Source and Destinations
- Created the connection manager with dBASE III Extended Property pointed to the folder where the files are.
When I try to set the OLE Source to use the file name variable, I get an error stating that there is no Destination table defined. I get the same error when I try to setup the OLE Destination. How do I resolve this issue? I want it to import each file into its own table. Is there any way to reuse this file name variable as the destination table name?
Any help would be greatly appreciated.
Thanks!
-Michael
How To Insert SSIS Variable To OLE DB Destination
Nov 29, 2007I am trying to migrate database from old structure to new structure usign SSIS.
The table in new db have extra field that i need to assign it using variable. this is because i have few customer that having different variable value. (meaning for 1 customer, the variable will be fix for all the tables in the database)
my question, without using the Execute Sql Task, can i assign the variable into the the old db destination?
eg my data flow Task is : OLE Db Source - Derived Column - OLE DB Destination.
Example data
Old structure (key = txnID)
---------------------
TxnID
ChequeNo
Bank (chq Bank - Bank in Bank)
Amount
New Structure (key = TxnID & CoCode)
-------------------------
TxnID
ChequeNo
ChqBank
BankInBank
Amount
CoCode
TQ.
SSIS Package Destination Adapter
Jun 6, 2006I would Like to know whether anyone tried to SSIS from SQL to AS400.
I am getting Exception when I set destination adapter ( for As400).
Whats the acceptable value .
Delete Records In The Destination File In SSIS
Apr 9, 2007How do I delete records in the destination file in SSIS using BI Development Studio?
View 1 Replies View RelatedDelete Records In The Destination File In SSIS
Apr 10, 2007How do I delete records in the destination file in SSIS using BI Development
Studio? Thanks.
SSIS Package With Excel Destination Is Not Running From SQL Job.
Apr 11, 2008Hello,
I have created a SSIS package which is getting data from SQL Server table to Excel File.
Step 1 : using Oledb to get records.
Step 2 : created Excel Connection and Excel Destination component
Step 3 : Configured the Excel File Path using variables.
Step 4 : Changed the property 64 bit FALSE
When try to run from BIDS it is running fine.
But
It is not running when try to run from SQL JOB.
The following Error i got:
: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. ::: component "Excel Destination" (588) failed validation and returned error code 0xC020801C. ::: One or more component failed validation. ::: There were errors during task validation. ::
Kindly give solution ASAP.
Thanks
Thiru
SSIS Oledb Destination Not Writing Any Rows
Nov 20, 2007
I have a Dataflow task with oledb source that is using SqlCommand to retrieve data and oledb destination to write the source output to a table. I have access to both the source and destination databases.
The problem is the destination component is not writing any rows to the destination table eventhough the Source component is returning rows (I can see them in the Preview and the source database table as well).
I'm using "Table/View Name from Variable" for destination.
The Package executes without any errors but there is no output.
Any ideas?
Thanks.
Dynamic Destination Address In SSIS Packages
Apr 26, 2007Hi,
I am using VS.net 2003 as a front end and SQL server 2005 backend.
i am creating SSIS packages for Datatransformation programically in .NET.
but the package created is compatible to the previous version of SQL server ie SQL server 2000.
So i need to migrate it in SSIS package compatible to SQL server 2005.
it is migrate also using Data Transformation migration wizard.
But i want to migrate my DTS package programically or by using stored procedure.
Is there any stored procedure or any code is there from which i can migrate DTS into SSIS ?
Thank you
SSIS Logging To Flat File Destination
Jul 24, 2006Hi
I am trying to use a conditional split task so that I can check for specific fields. If the value doesn't exist I am piping the records to a derived field task, where I add an error. I then try to send these records to a flat file destination so that I can keep track of them. However, when I execute the SSIS data flow task I get the following error
[Log Invalid Records [5496]] Warning: The process cannot access the file because it is being used by another process.
This file isn't being used by any other process as far as I can tell, and the only process using it is the SSIS task trying to write to it.
If anyone has any ideas, then I would really really appreciate it
Thanks
Darrell