Microsoft itself dissuades the use of data sources between different enviroments:

http://msdn.microsoft.com/en-us/library/cc671619

(maybe the answer to your problem is mentioned somewhere in the article)

You could try to refresh the metadata.

Instead of your old SQL statement, put

SELECT a = 1

This will wipe out your existing metadata. Then put pack your original SQL statement with...

That actually made me laugh outloud 😀

My first guess, after reading your chaos question two times (:-P), is that you are trying to convert a date to a string, and it is failing. That is, if...

I think Method 1 only works if you can all your history from the source. If not, this method is flawed as you will lose some of your history each...

This is a very, very, very common problem with SSIS and Excel. It shows up in hundreds of blog and forum posts.

Have you tried Google?

The issue is that Excel guesses...

Great question. Learned two new things today:

* nullif

* how SQL converts an empty string to a numeric datatype.

Nice one!

mvelusamy (4/30/2010)

---

a) Use T-SQL UNION ALL if you source from more than one table

Advantages: It will hit the DB...

Add a derived column after your flat file source.

Use the following expression:

REPLACE([Email_Address], " ", "" )

I think there are two options (since you just can't disable components in the data flow task):

* write a script component that functions as a RAW file source. This script...

We have something like that in the company I work in. There is a competence manager, someone from HR, who follows you through your career. He/she talks with your clients,...

Don't worry Gary, it's just Excel, the rest of SSIS works (practically) fine. 🙂

I have to go with Phil here. Datetime conversions...

I'm not 100% sure, but I think that joining in the OLE DB source will be more performant than using the conditional split. The conditional split has to evaluate each...

marina.x.rotua (4/28/2010)

---

when I insert the data source using the data flow task in control flow tab, then on the data flow tab using OLE DB Destination, how to make its...