September 19, 2008 at 2:22 pm
I am trying to use a DataReader Source to import data from one set of tables to another set of tables. Right now I have going from a DataReader Source > Data Conversion > SQL Server Destination.
For some reason this is showing a completion but the data never goes into the tables I want, it is always empty after the transformation.
This is the query I have written in the DataReader Source:
select distinct emp_id.emp_ssno, emp_demo.emp_lname, emp_demo.emp_fname, emp_demo.emp_mi,
emp_demo.emp_add1, emp_demo.emp_add2, emp_demo.emp_city, emp_demo.emp_state,
emp_demo.emp_zip, emp_demo.emp_gender, emp_demo.emp_doh, emp_demo.emp_dob,
emp_demo.emp_home_phone, emp_deduc.deduc_no_of_deduc, emp_deduc.deduc_payroll_id,
emp_deduc.deduc_amt_per_deduc, emp_deduc.deduc_annual_amt
from emp_id, emp_demo, emp_detail, emp_deduc
where emp_id.pgb_id = emp_demo.pgb_id
and emp_id.pgb_id = emp_detail.pgb_id
and emp_id.pgb_id = emp_deduc.pgb_id
and (emp_deduc.deduc_payroll_id = 'DAYCAR'
or emp_deduc.deduc_payroll_id = 'DCA'
or emp_deduc.deduc_payroll_id = 'MEDR'
or emp_deduc.deduc_payroll_id = 'FLXCD')
Then I do a Data Conversion and then to a SQL Server Destination which goes to 4 different tables, 1 parent, 3 child. None of the data goes into any table.
Can anyone tell me what I am doing wrong?
September 19, 2008 at 3:19 pm
Hi,
Did u try using dataviewer in between source and data convesrsion transformation, jsut make sure its outputting data. double click the green arrow and add data viewer. Now execute the package, now you must see the data in dta viewer, if your source is correct.
VG
September 22, 2008 at 7:12 am
Why are you using a datareader source? Could you use a straight ole db source?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 22, 2008 at 8:13 am
I redid all my tables and tried the Dataviewer and it worked. Now I have to export the data into an excel file so I am currently working on that project now.
Thanks for the replies guys, it helped alot.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply