There is - it's called the Import/Export Wizard...

Use the Import/Export Wizard to get your package started, then edit it in BIDS.

You won't necessarily have 1000 Data Flows, but you probably should. (You can put more than...

The piece you're missing is to place a property expression on the File Connection Manager.

Select the File Connection Manager, then open the Properties pane (F4). You'll see a "ConnectionString"...

If I understand what you've described, you're a little confused on how to set up the task.

If you have your file paths already specified in SSIS variables (specifically, in "sourcepath"...

Yes, you can do this through the "back door" of property expressions. In this case (inside the Data Flow) it isn't particularly pretty, but it works.

Open your Data Flow,...

Jason Lees-299789 (6/14/2010)

---

...a better option would be a custom ssis task that allows you to select all the columns you want to be Hashed, and attach the hashed column on...

Do a simple text search on the DTSXs. There really is no other way for the SSIS packages. DTS and other objects, dunno.

You need to investigate the SCD Component.

Great article, Brett. I have a half completed one in my pipe similar to this - but directed solely at how to use a hash to speed up my...

So to be clear - you have this working in 32-bit mode through BIDS? If so, what's your connection string look like there? It doesn't have the "12"...

Despite the fact that you thought you were using the 2010 driver - you weren't. Check your error message and you'll see it naming the 2007 driver... unless you've...

Contrary to your experience, I haven't had any "backwards compatibility" problems using Excel with SSIS in an x64 environment - be it 2003 server, 2008 server, Vista, or Windows 7.

To...

It's the code page to use for interpreting the internal binary representations of the characters. Since you're speaking English, it's a sure bet that 1252 (the default) is fine...

The easier and more efficient way to accomplish what you want isn't by using a separate Data Conversion component. Just change the expression a little in the Derived Column...

When you post a question, especially one where you can't get something to work the way you expect, please post complete information. In this case, post the expression you...