Hi @Astrid o ,
my problem is that out of the 40+ tables, it doesn't load 2 big tables. The biggest table contains 187,511,514 rows and the other table has 21,444,505 rows (basically it doesn't load the two biggest tables.
May I know which were the largest rows that you can load the tables?
We can use Conditional Split Transformation in Data Flow Task to divide these two big tables into several small tables with proper rows.
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?
I use visual studio 2017, no task is failings, just those two tables are being skipped. No error messages, as everything loads except that. The destination is the sql server and it just needs to run a procedure, not to load data from one place to another.
I get the tables with the amount of rows inserted on a table, then I run a query to get the top 1 table.
after than I have an expression task that takes that table name and run a query.
Deciphering your reply:
Execute SQL Task
SQL Server of unknown version
So far, it seems that SQL Stored Procedure is failing. And it has nothing to do with SSIS.
Sorry it took long to reply. I was not dealing with this issues.
To your questions.
I am using
visual studio 2017, version 15.6.4 with integration services version 14.0.3002.92
nothing fails, and I dont get any error, it just doesnt process those two tables when it is done dynamically.
it is needs to run a query on the sql server, and i am version 2017.
and i use an expression task to run the query. I am not sure what drive it uses. maybe i should try an execute sql task.
Sign in to comment