I agree with Jason, without a practical example, it is very difficult to assist.

Assuming that you are not too worried about massaging your data, you may want to try doing...

I am sure it is possible, but I havent really worked with external SMTP credentials in SSIS (4th week and getting more confident as time goes on...).

I would configure as...

Hey,

You may want to read up on this at the following URL:

http://technet.microsoft.com/en-us/library/cc280547(SQL.100).aspx

It talks about Migrating from SQL SSIS 2005 to SQL SSIS 2008, but provides a method...

Within the send mail task, there is a Windows Authentication, or a SQL Server Authentication.

Does your SQL server account have access to sending mails on the external SMTP server?

~PD

Hey,

Maybe consider placing your connections into a SQL server database.

That way you can have your users access these connections through your ASP page, and this will pass to SSIS seamlessly...

I agree with Matt.

Trying to customise stuff when all you are attempting to do is move from Access to SQL sounds like wayyyy too much work to me.

The migration assistant...

Also to consider,

If you right click on the package properties, there is a deployment utility option.

When selecting this, change the CreateDeploymentUtility option to true.

When you rebuild your package, this will...

How about the option where you retain Null values from the source as Null values in the Data Flow?

I see no reason why you couldnt bulk insert within a for each enumerator (please dont lynch me, 3 weeks of SSIS is hardly enough to deliver expert opinion).

I would...

Hey Richard,

The send email task will do this for you. Try the following:

(a) Export the results as text as a dataflow task prior to sending the mail

(b) In the send...

What worked for me is to save the encrypted information with password.

Note that when you create your configuration.xml file, the sensitive information will not be created. Microsoft deems this as...

Hey Karen,

You may want to look at an article published by Microsoft on SSIS performance tuning, which will explain the SSIS architecture in quite a bit of detail

http://www.microsoft.com/technet/prodtechnol/sql/2005/ssisperf.mspx

"...If...

Uhmmmmm,

Nopes.

There are 2 ways you can save your package, to File System (generates a .dtsx file), or to SQL server.

There is a white paper that you may want to look...

The question is, does your SQL server account have access to the file? Because this is what will be accessing the file at runtime.

How to check:

a) Run the SSIS package...

hey,

You may want to have a peek at the following article, which will show you what you get with the express edition:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

The answer is no, you cannot run...