Personally I use SQL server integration services. If you're using the import/export wizard for SQL that is ssis. When you map the fields in your spreadsheet to...

Do you have the option to dump the data to text and then use SSIS to import from the text file to SQL? Another alternative, is there an oledb...

Have you tried setting the data type on those fields to nvarchar(max)?

Open the SQL Agent job and the step where you call the SSIS Package.

On the "Execution Options" tab...check the box "Use 32 bit Runtime" and see what happens. When...

You rock! Can't believe I didn't think to do that.

Working great now. 😀

I have done something similar to this. Here's how I did.

1.) For each loop through your table sending you e-mails. Storing the EmailID you are working with in...

If you are using an ODBC connection then it will be an ADO.NET Connection Manager and ADO.NET Source in SSIS. I am assuming you were not able to located...

First...i don't work for Red Gate although I like their toys. So I would suggest for minmimal cost just a few hundred dollars they could pick up a SQL...

Are you trying to open the plans via Mgmt studio on the actual server or from another machine?

Typically web site will be connecting to a web service. You configure the SQL connection string which points to you SQL server in the web.config file for the...

There a many different reasons why the data flow tranformation may seem sluggish.

1.) Using Fast load option in the OLEDB Destination should always be used when inserting data to SQL...

If you can show the package execution error that would be helpful. Are you certain the fields you are doing the lookup on will only return 1 matching row?...

The SQL Agent can help alert you when there are problems.

I setup each of our servers to at a minimum to send email alerts when there is a...

First Question:

Is Windows Firewall enabled on the report server? If it is try disabling it temporarily and see if you can deploy from the client machine. If you...

Anytime you upgrade SQL Solutions (RS, SSIS, OLAP) it creates a totally new directory with all the upgraded files in it. Your original solution from the previous version should...