The child package ( Error 0xC0012050 while loading package file "R:\Sanctions.dtsx") may have DelayValidation = True set at the package level. Set it to False.

If u need delay validation,...

Did u try connecting from an ODBC source (create one for DB2) withe the credentials u have.

Looks like a connection problem b\w Windows auth and SQL Auth. Your program may be running under windows auth and the user (maybe u) have access on every SQL Server...

1. Create an SSIS Package with Execute SQL Task (Create a SSIS variable of datatype 'object' - call it SQLParam)

2. Add your stored procedure to it (EXEC StoredProcName @Param or...

So if i understand correctly u correctly u want to know if the results of an update statement can be used as the from clause in a select??

My apologies, i may have read the question incorrectly. I thought u wanted an "insert statement - exec proc" method.

I dont think so, but if u find a way i would be delighted to know.

U could do a INSERT INTO TableName EXEC ProcedureName

-----------------

CREATE TABLE #Temp(ID int)

CREATE PROC Test1

AS

SELECT 1

INSERT...

Do u have a password to connect to your sql server? i.e. r u connecting with sql auth or win auth

Did u just right click and selected Edit package for an existing package??... is the package a part of a solution?? Create a blank solution --> Add Existing Item (add...

If u are looking at testking and all those resources for just passing the exam dont they also give u a cheat sheet with answers ??????????????????????:-D

You could write VB.NET script\script task to read from db and update the connection string dynamically.. would this solve your problem?

see if it has any of the reasons in this blog

sqlscape.blogspot.com

if u r not able to solve even after looking at the above options, post back and i will look...

Looks like one of the routine tasks that a dba\dev would do right? i would create a dynamic sql script based on the metadata tables (system tables) that would build...

You need to post this in the SSIS forum. Anyways - lookup running SSIS job with SQL Agent via proxy, you will find the solution to your problem.

I would split the debugging (ps - not talking abt the conditional split). Just test the NULL(DT_DATE) without the other else.

Then try only using your custom function\transformation. I think there...