Matt - thanks. The missing "\" (suffix) was exactly my problem.

Appreciate you looking & resolving this for me.

The 2nd paren is valid.. (I tried removing it for the heckuvit -- no difference)

Also, just ran the exact SQL in Embarcadero's DBArtisan against the source DB and...

Here's the situation. I am converting DTS pkg's to SSIS (2008). When I copy this SQL from DTS (which executes just fine in DTS) and paste it into...

perrrrrrfect !!

Thx Ian !!

I have the same warning appear on all my SSIS package executions as well. I am running the packages as local administrator w/ sysadmin on the SQL Server....

I was told by our Sybase DBA that Sybase Clinet 15.3 does not use sql.ini anymore...

Sorry -- still don't understand.. as a DBA, I've coded a proc which is successfully invoked by our developer's front end VB 6.0 GUI... (ADO)

My developer is requesting a...

cool suggestion.. cool beans.. thank you!

Elliott - thx for the quick reply... question -- our "system drive" varies from Dev, to QA, to Prod (in Dev it's C: -- In QA & Prod it's D:...

thank you !

thx.. yep, all I had to do was enclose the underscore in double quotes... and double up the \\ within double quotes.. worked great !!

Elliott - thx. (great minds think alike) it worked...

prior to your feedback, I actually did default the newly created variable 'values' to actual valid values (Dir name, File name,...

yep.. proactively determined & corrected that.. I now have NO paramater mappings. I setup my Result Set to include the Variable Names...

Still -- I receive the Connection Manager...

thx Elliott -- still having an issue & hoping you can help me out:

I used your suggestion to create a couple of pkg variables, populate them indidually via EXEC SQL...

Actually, I am well versed in the use of Package Configurations using a .dtsConfig file housing variables which match my Package variables.

I typically pass hardcoded values (Connections, Provider strings, Directory...