If you change an upstream file source (structure, data type, etc.), your downstream components will likely require need new metadata. Double-click each of the components downstream from the one...

Thanks.... for some reason I went brain dead for a minute and chased this all the way back to the SQL Command task in the Control Flow. The Ole...

Thanks Michael - I'm trying to avoid using this method, I'd rather just process the data inline. You say that there is a way to do this - can...

Good article Brandie. I would add to this that a good place to start "at the bottom" would be at a nonprofit or small government agency. In many...

Brian Knight has a couple of good books on SSIS. There is also Jumpstart TV (http://www.jumpstarttv.com/) that has some good free resources. SqlIS.com is another good site for...

Agree completely with Brandi about Excel and it's quirks (or are they features??). For some of my more difficult ETL, I've resorted to saving the Excel as a CSV...

Yes, there is probably a better way than wrapping your entire SQL call into a variable, but you'll need to provide more information about what exactly you are trying to...

I'll second the shout out for Brian Knight's SSIS book. I've got it and used it extensively while learning SSIS. There is also an advanced SSIS book by...

This is a common problem with Excel. One thing I've found is that if you change the row sample size that Excel uses (by way of the Access Jet...

Can we keep the sponsored content separate from the regular member articles? I don't think it's a bad thing to have sponsored content, but it is my opinion that...

Consider storing the filenames in a database table. You can then check the file name against this table to see if there are any new files that have not...

Project schedules are just like everything else, it's easy to account for the big stuff but it's lots of little stuff that eats you to death. It's easy for...

Apparently I have not been prudent in keeping Visual Studio updated. I applied SP1 - a trivial task requiring just two hours of my time to download and install...

Will do.

At least 10 minutes, off and on (I jumped out on MSDN to verify my solution). It seemed much longer after I lost what I was typing. :w00t: