Hello All,
We are facing a very peculiar issue on our production environment when we use the SQLSvr Bulk loader.
We recently added a new column to an existing table and made relevant changes in our server job. An entry for the new column was made in all the relevant stages. There are around 200,000 records which were loaded.
The jobs worked perfectly alright with no records being dropped, however the new column was only loaded with null values though there is data available in the source table and we can see the same, when you use the View Data option in the Source ODBC stage as well.
Has a similar kind of issue been faced earlier by any?
Your inputs and pointers very much welcome.
SQL Server Bulk Loader Issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Wed Mar 07, 2007 3:12 am
- Location: Birmingham
Re: SQL Server Bulk Loader Issue
Well... the behaviour suggests that this isn't true. I'd suggest you triple-check your job. And this seems like one of those times when getting another pair of eyes to help would be prudent.pavan.nadiger wrote:An entry for the new column was made in all the relevant stages.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 6
- Joined: Wed Mar 07, 2007 3:12 am
- Location: Birmingham
Hi Craig,
We have actually checked the jobs thoroughly and have found no anomalies. We replaced the SQL Bulk Loader Stage with an ODBC Stage and the job loaded the data in a perfect fashion.
Therefore was considering whether there is any specific issue with the SQL Bulk loader stage?
Thanks and Regards,
Pavan Nadiger
We have actually checked the jobs thoroughly and have found no anomalies. We replaced the SQL Bulk Loader Stage with an ODBC Stage and the job loaded the data in a perfect fashion.
Therefore was considering whether there is any specific issue with the SQL Bulk loader stage?
Thanks and Regards,
Pavan Nadiger
Have you compiled all jobs after moving to production? Try once agiain compiling. Checkup for any triggers on table. checkup all the transformers and routines / Transforms, Containers. Check for any scripts that run after job. check for any stored procedures. It is certain that unless we make some mistake, it doesnt happen.
Lakshmi Srinivas
Lakshmi Srinivas