HTH

Rob,

I also was wondering if this was a space issue, and if they were trying to regain space by using non-unicode data types after they 'converted' the Spanish characters...

Hi Mike,

What you want to use is the Deployment Manifest tool to deploy your package to the server.  The "How To: Deploy Packages To SQL Server" help topic in SSIS...

I think it does.  Does this link help answer your question? http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/querying_with_wql.asp

Here's a link that tells you how to do what you are trying to do.  It doesn't contain lots of pretty pictures, but it will definitely help you to get...

I don't think that you can generate a maintenance plan that will appear in the maintenance plan folder except by using SSMS. 

You can generate a package with Maintenance Plan...

"6) Now, we change connection string to point to another database after adding this new OLE DB connection in Connection Manager of each and every package.

7) When we save, build...

I would be careful about trying to convert characters that exist in Spanish but not in English to English.

In fact, logically it's impossible to do because La Niña is not...

"4) Is it enough to set isolation level of master package to READUNCOMMITED and keep TransactionOption as Independent for it and supported for the rest i.e. the method used to...

"Ideally, I would define a set of inputs and a set of outputs and I would be able to hook up fields from my current data flow to these inputs...

I'm not quite sure what you mean by "keys", however if you are talking about referential integrity and determining which columns have a foreign key relationship to that table then...

Hi Jose,

Don't worry about your English - it's still better than my Spanish.

If you were using stored procedures in SQL 2K, you can probably use SSIS to execute those same...

Hi Koneru,

"3) How do we send mail with details of Error/Warning using OnError/OnWarning events?

6) Where are the errors that come during build, deploy, install and execute stored? Is there a...

Hi Jose,

Don't worry about your English - it's still better than my Spanish.

If were using stored procedures in SQL 2K, you can probably use SSIS to execute these same procs and...

I believe that column tells you why your log can't be truncated at this time.

Here's a link that may help you.

http://msdn2.microsoft.com/en-us/library/ms345414.aspx