you only need to back up the .dtsx file, there are no associated files included.

another option is to deploy the packages to the msdb, where the packages will be included...

i think if you are doing it this way you will need to use the datareader to loop through the recordset and populate a text variable with the rows (using...

I don't have access rights to the server to be able to log on, but using the agent I can schedule the child packages to run without any problems, so...

hold the source table or entire source sql along with the destination sheet name in a table

use an execute sql task to get this information into an ADO recordset

use a...

I'm not sure I understand the question, it is a little vague. What do you mean by "top level"?

how have you set the enumerator configuration?

you could change your sql code to the following:

Select C1,C2,C3,C4,C5,C6,C7 from TBL1 where substring(C1, 1, 10) = ?

and change your variable that is evaluated as an expression to just SUBSTRING(@[User::FileName],1,10)

you...

why not use the XML task?

Do the child packages execute in sequence, or do you have them executing in parallel?

although, in the picture provided that scenario wouldn't quite work. you would need to specify the connectors as being "OR" constraints, not "AND" constraints.

That way Process 2 will still...

does the variable for the connection in the parent package have the same name as the variables in the child packages?

if this is the case, then when the child package...

doesn't oracle come with change data capture? can you use that to pull out the incremental data and load that with SSIS?

i think it is more a case of sql server probably not being able to handle complex numbers (the square root of a negative number).

the filepath points to the file. the sheet name is used in the select statement. you may need to build the select statement dynamically using either a script...

you need to parameterise your query. replace the code with:

EXECUTE msdb.dbo.sp_send_dbmail

@profile_name = 'ArchibusProfile',

@recipients= ?,

@subject = ?,

@body = ?

Then go to the parameter mapping section of the task and add...