It was not consistent as far as having to remap which was a good case because it could have effected thousands of transformations.

I had to remap several and redeploy the...

I don't understand what I'm supposed to connect to.

I have a connection to SQL Server as the Destination, AS400 as the source and another SQL Server Database to for package...

Koen Verbeeck (5/5/2011)

---

This is how I do it:

design your child packages and deploy them to the server.

Design your parent packages, set up the Execute Package Tasks and point to the...

I also had the syntax wrong at the end of the statement.

I did not end the statement with )').

I don't understand the significance of the sequence of characters at the...

Dumb....

Thank you for your help!:-)

I have a situation where I need to include more than one column in the IN or Exists.

I use IN extensively but never with a comparison...

I specified the column as a new column and used an expression by simply dragging and dropping.:blush:

I can get the following JOIN to work:

SELECT *

FROM OPENQUERY(LinkedServerA, 'SELECT * FROM TableA

INNER JOIN CompanyNumbers ON TableA.CompanyNo = CompanyNumbers.CompanyNo')

But I get...

The AS400 is hosted by a Vendor.

I can't wait until it goes away.

I was having trouble with an OpenQuery Statement that referenced two tables with a WHERE EXISTS.

I gave them...

No I have not.

In my last post I did not specify that it was a new question.

Post has been moved to the following thread:

http://www.sqlservercentral.com/Forums/Topic1214273-338-1.aspx?Update=1

I have a new query where both of the tables are on an AS400.

I need to Return all Records from TableA That Have a Record in a Table called CompanyNumbers...

I tried an INNER JOIN and I still get a syntax error.

Any help would be greatly appreciated.:-)

I'm specifying a path for the SSIS Package Configuation and file where I store an AS400 User Name & Password.

I then use the DTUTIL to store the package in msdb.

I...

Interesting.

I would like to know more about how you use your database to store package configurations.

I saw that when you create a job to execute an SSIS Package there is...