I tried running that script but it did not work for me...

Threw me an error saying it couldnt convert 'master' to int....

I dont need master...

Yeah that 18 is actually the database id in my Databases table...Why?

I have been using those views...That is what I used to populate the other two tables...But for this table I can do it so easy like I did with the...

Ok guys...First of all, I would like to thank all of you who chimed in with your opinions on how to resolve this issue...

It seems that when I put that...

I am not that familiar with batch files...But the last line on the batch file calls a .dat file and the .dat file ends with BYE on the last line...

I...

Ok here is what I did to narrow down the causes...

I set up a TEST package and disabled the first Execute Process Task...And scheduled the package to run and it...

Yeah no failure, no success...The job is scheduled to run at 8 am...And if it fails, I get notified via email...This was the first day it was scheduled to run...So...

Yep

Yes...I created the package on Server A and created the job to point to the package on Server A...

Yes...and it has administrative privileges...

I got it...

I had to enter a 0 in the Parameter name field in the Parameter Mapping and then in the query where I call that variable, instead of using...

Well I got past the parameter is unrecognizable error...I had to put a 0 in the Parameter name in the Parameter Mapping tab...However now I am getting the error, Must...

Ok that query works great...Now to implement that into SSIS is the hard part...

I know you can put Execute SQL Task in my package...And I can put that query into...

Thanks

Please explain...