This package had worked in the past but, for whatever reason, hasn't been working as intended recently. The package has a script task that sets a file path variable to the file path for the most recent csv file in a folder and then uses this file path variable in a ConnectionString expression used in the flat file connection. There is a little "massaging" done with the csv file, skipping top x rows (file header info), specifying the delimeter, text qualifier, etc. If I use a hard coded CSV file path and preview, all looks as expected. The flat file connection is specified as the source in the Data Flow Task and a SQL table is specified as the destination. I run the package in VS, and nothing errors. VS reports "Information: 0x4004300B at MyDataFlowTask, SSIS.Pipeline: "Destination - MySQLServer Table" wrote 871 rows." but when I go query the table, none of the rows are there. What might I be missing?
SSIS Data Flow Task indicates it wrote x rows, and reported no errors, but none of the rows appear in destination
155 Views Asked by user3799279 At
1
There are 1 best solutions below
Related Questions in SQL-SERVER
- Dynamic query creation with Array like implementation
- 'pyodbc.Cursor' object has no attribute 'callproc', mssql with django
- Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl, ${SPRING_DATASOURCE_URL}: GitHub Actions
- PHP Laravel SQLServer could not find driver
- Upsert huge amount of data by EFCore.BulkExtensions
- How to locate relevant tables or columns in a SQL Server database
- Cannot delete SQL datafile (.mdf) as its currently in use
- Writing query in CTE returning the wrong output
- Group By Sum and without Group by sum Amount is different
- plan_handle is always different for each query in SQL Server Cache
- Adding a different string to a table fails
- The specified data type in the EF modelBuilder doesn't correspond to the one that is created
- SQL71561: SqlComputedColumn: When column selected
- How to Solve Error Associated with Trusted Authority
- SQL Server Data Model and Insert Performance
Related Questions in SSIS
- Skip null rows in SSIS of excel file
- SSIS error: delimiter for column "X" is not found - started happening after migrating package to newer SSIS
- Copy or Move Data from one Database to other Database and have one more destination option
- Odata source inside ForEach loop
- Extracting data from SAP ERP into SQL Server
- Get the URL from C# script used in ssis
- Write rows on destination even when an error occurs?
- Visual Studio 2022 Task script editor : Impossible to modify
- SSIS package writes empty CSV file
- SSIS flat file destination generating more digits than in the database
- SSIS remove $ format from csv
- Handling inconsistent record delimeters in ssis
- SSIS Data Conversion Error: Overflow Issue in Automated Job Execution
- SSIS to Snowflake connection
- SSIS - OData Connection to Sharepoint List Failed Validation Error 0xC020801F
Related Questions in SCRIPT-TASK
- How to access tables from two databases in one ADF Script?
- Issue with HttpClient.SendAsync("...") in SSIS Script Task
- SSIS Script Task "Object reference not set to an instance of an object" When Executed from SQL Server Agent Job
- XML Edit in SSIS using Script task
- Must declare the scalar variable "@ID" error, C#, SSIS, in Script task
- SSIS Script Task not Executing
- Enable to get bucket location, using default endpoint
- Write a SSIS script task to get oauth2.0 bearer token from a Web API
- SSIS Data Flow Task indicates it wrote x rows, and reported no errors, but none of the rows appear in destination
- Incorrect authentication data C# SSIS
- Why SSIS Script is losing NuGet package and references after I close and reopen the script?
- SSIS - How to write line by line into flat file using ForEach Loop Container
- Script task component is not working without Visual studio
- Visual Studio Will Not Edit Script Task
- SSIS Script Component Does Not Recognize Dts.Variables Namespace
Related Questions in DATAFLOWTASK
- "The selected data source is on remote computer" error when creating an SSIS job
- Getting Avalilable lookup columns in Loookup transformation into Lookup not match output path in ssis?
- How to get Avalilable lookup columns in Loookup transformation into Lookup not match output path in ssis?
- Conditional Split in SSIS - SQL
- How to call a web service with multiple input (in a Script Component) in SSIS?
- Copying multiple tables using SSIS Package
- Can't open excel file with SSIS unless it is manually saved
- SSIS SQL Task with parameters not creating temp table
- SSIS XML Source Error Output resets to fail component after setting to redirect row
- Simple Data Flow not extracting all records in table
- Need to provide dynamic file from azure blob to the any data activitiy in azure data factory, please share some link
- Pagination in ADF Data flow
- I want to define a variable globally but it should be initialized locally and the data should be the same for other classes
- SSIS Package Hangs when trying to insert million of rows from a OLE DB Source
- Redirect error rows only when conversion fails
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
This isn't an answer in as much as a "what I did to move on from the issue." I never did find data actually being written anywhere. I created a new table in the same database and the data was written there as expected. I tried renaming the offending table (it had spaces in the table name) and still had issue (also checked for uncommited transactions and found none). I dumped the data from the offending table to the new table, removed the offending table and renamed the new table name equal to the offending table name and it worked fine. There were no constraints or triggers on the offending table, I didn't end up modifying the SSIS package at all. I just "changed out" the offending table and things then worked as expected. I have no idea where the records were being written "if" they were being written, but removing and recreating the table took care of it.