Are you wanting you create a DLL or an SSIS package? If it's the former, you should be able to do this with just a few lines of code...

Start over at JumpStartTV.com and watch the numerous videos on SSIS. I believe Microsoft also has some getting-started videos on their website. I would also recommend the Wrox...

It looks like you're adding the variable name to the Arguments field, which is interpreting it as a literal. You'll need to use an Expression to assign the variable...

No problem. Good luck - it sounds like a fun project.

To do this in parallel, I think you'll need duplicate components. Perhaps you could create a few script tasks/components to do an alpha split (or other selective copy) and...

What's the source of your dynamic file list?

You could make an SP out of the code you have posted below, adding a "SELECT * FROM #tmp" at the end. Call this stored procedure from an OleDb...

Not that I know of. How many files do you have? If it's a small number of files, you could set up a sequence container containing a Filesystem...

You can use the Execute Process task when calling the Winzip command line executable.

Your problem definition says that you need to dynamically create packages, but you didn't specify why you need to do this. Can you provide more detail about the problem...

If you want notification when the entire package fails, it's easiest to create a notification on your SQL Agent job to send an e-mail upon failure.

hth,

Tim

First, you can't do this with the Winzip GUI. You need an add-on to Winzip (available for download on their website) to install the command line tools. You...

Good article. I've found this case to be true in purchase applications and not just in-house development. I've gone to blows with more than one vendor after their...

Jeff Moden (11/22/2008)

---

GilaMonster (11/22/2008)

---

A senior DBA who doesn't know how to do performance monitoring or how to kill a connection? I could accept that of a junior with only a...

You mention that you have 5 lookups in your package... Are these the only transformations you have between your source and destination?

If you are getting an error in a...