I figured out one of my issues -- one of my inserts was going to the wrong table, causing a lock. Will have to work on the other one...

I found that using the script task when using a web service to get data works the best. You will need to reference the web service from your script...

I figured out I can use a parameter in the Source OleDB connection but I am still perplexed as to why the SQL Command is not an option in the...

We have just started using Talend for some Oracle data quality projects and I can't even get it to run. It definately requires some training.

Actually I got a little further but now am getting this error when running dtexec from xp_cmdshell:

Error: 2011-01-26 15:14:52.01

Code: 0xC0047062

Source: Data Flow Task ADO...

Unfortunately I still get the same error: 'C:\program' is not recognized as an internal or external command.

Thanks but that didn't fix the problem.

Yes, I am executing the package as myself. I am sysadmin because it is a development environment, so that is why I am perplexed.

Actually,

I am the user who developed the packages and I also am the user who is executing them. Like I said, they execute from Integration Services but not from...

Since I was unable to resolve this issue, I decided to use the script task to call the web service. I was able to run this successfully! I...

Check out this link.....

http://www.learnitfirst.com/Training/Course/ac/SQL-Server-Training-Videos.aspx?an=GoogleAdWords&rq=PPC&CourseId=153&gclid=CKa9q4m37Z8CFYha2godugLlXQ

I learned SSIS by using training videos from Learnitfirst.com. They were structured from easy to difficult and each lesson built on the next. ...

Instructions for deployment can be found here: http://msdn.microsoft.com/en-us/library/ms140117.aspx

You'll need to run the deployment manefist from the server you want to deploy to.

Karen

Sorry, I didn't complete my thought:

SELECT 0,

'HDR1',

'HDR2'

UNION

SELECT TOP...

I agree, you are naming your nested select h but your on clause is using ppp.

No, that is not what I said. I answered the first question only. Sorry to have confused you or anybody else who read my reply.

Karen