I set up an Ole DB connection to run several SQL tasks across an SSIS package. It also runs well.
I utilized SQLBulkCopy for a job where I needed to put data into a database since my tables and columns are dynamic and depending on files I acquire from various sources.
Because SQLConnection is required for SQLBulkCopy to function, I opened SqlConnection and ran SQLBulkCopy. This is also effective.
After finishing with SqlBulkCopy, I constructed a SQL Task that changes the metadata of inserted rows in various tables, such as the count, minimum and maximum dates, and so on. If I run a stored procedure using SQL Management Studio, it operates as normal but this table is not being updated.
So, based on my guess, Ole DB connection is unable to access the most recent data that was entered through SQL Connection.
I might be wrong, but I'm not clear why a successful SQL execution job results in a table that hasn't been changed.
Am I overlooking anything here?
I was sending the data type as Varchar rather than as long (int in SQL).
As soon as I ask a question here after searching for a few hours, the thought occurs to me to verify the data type.
I hope someone will benefit.