Hassu,

The whole difference that a dynamic SQL makes lies in the fact that it helps you avoid explicit input parameter mapping.

You need to construct the full SQL Statement (with all...

Thank you for a suggestion.

I did check those 2 things.

It is a constraint, and the type of it is "[On] Completion".

Any additional suggestion?

Thanks in advance.

Alex

The method that I use is the most generic one - it works irrespective of whether you use an explicit dynamic SQL (INSERT, UPDATE, or DELETE statement), or you use...

I had this problem some time ago, and I just constructed a User variable containing dynanmic SQL (EXEC statement) in the preceding VB Script Task.

Then I based SQL Script Task...

I would like to thank everybody who was willing to help.

I found the idea of the working solution in one of the postings on MS SSIS message board.

Instead of static...

Thanks, Michael,

I did try your suggestion.

I created a user variable: User::gvExprPN, and

I set the property "EvaluateAsExpression" equal to True,

and I set expression equal to @[System :: PackageName].

Then, I added...

Based on suggestions of Greg and AJ, I am trying to perform the SSIS Package Deployment into the file system on the server. I use the build/deployment option "EncryptSensitiveWithPassword", and...

AJ,

This link is excellent.

Now I need to rethink and reestimate all production setup options.

Thanks and regards,

...

AJ,

I have a couple of extra questions in regard to your deployment and programmatic invocation schema.

Are you talking only about server-side applications?

In my case, I need to run the...

Hi,

Check the following article on this site:

"Error Handling in SSIS" by Jack Corbett, 2008/03/26

Greg and AJ,

I am going to try your ideas and to post a brief report on the results on Monday.

Thanks and regards,

...

Brian,

Thank you for the precise response.

That's just what I was looking for.

Regards,

Alex

I really appreciate Greg's fast and helpful response.

Still, I have some further questions:

1) At this moment, I have just "Development" configuration of my Integration Services Project enabled in BIDS/VS 2005.

Is...

Greg,

Thanks for your response.

Yet, could you further clarify the issue with establishing a connection to SSIS from SQL Server management Studio:

- Could this connection be established at all?

- What are...