"4) When we execute this master package, we should be able to dynamically specify different source and connection

strings for all packages.

5) Can we do it with dtexec...

If you are really trying to debug your procedure, then you may also want to try just running a sp_helptext against it.  Then you can take the text returned by...

Can you give more information about exactly what is failing?

For example, are you using a SQL Task where you have a CREATE TABLE #TempTableName statement? Or it is failing when...

This appears to be one of those little tricks in SSIS where you have to use the right control flow item in order to accomplish this task.

The Sequence Container control...

"Thanks abdul,

Yes..It seems to solve my problem.

Actually i am not a db person, but I learned a lot from your mail"

Sometimes I am good for something.

Hi,

My only suggestion is for you to do what sp_password is doing.  In other words, sp_password is just a stored procedure in the Master database that peforms tasks against various tables.  Instead...

Hi Nirmala,

I'm sorry but I don't know what you mean by Import/Export wizards when you talk about SSIS.  The Control Flow tasks and Data Flow components in SSIS are not...

Hi cdun2,

TBH, the best way that I've seen this type of scenario handled is to build an AuditLog in your db for these files.  The AuditLog tbl would contain a...

Good luck!

Omhage,

I'm getting SSIS burnout so this is my next to last post of the day.

Based on what you've described so far,...

Hi Brandie,

I'm curious.  Did you use the .SSISDeploymentManifest utility to deploy the pkg to your development server?

If not, then using that utility may solve your problem.

Just as background, I used...

Hi David,

Lee posted this question in 2 threads, so I answered it in the other thread.  However I was curious about the following statement that you made.

"One of the...

One of the most confusing things for me about SSIS is which data flow task is the most efficient in a particular situation.

I generally use the Execute SQL Task when...

Well, the first most obvious (although it's extremely annoying) question is whether you have fully updated SQL Server 2005 to include the latest version of SP1 and the latest Hotfix? ...

Hi ferigod,

Like most people, I'm new to SSIS, but I've noticed something about the packages.  When you execute a package from BIDS, SSIS likes to perform "validation checks" as part of...