It is available as the "Vertical Bar" Column delimiter in the Columns panel of the Flat File Connection Manager.

You may try to use...

If these are Sybase Advantage DB files then maybe this link will help you:

http://www.sybase.com/products/databasemanagement/advantagedatabaseserver/odbc-driver

You would install this on your dev machine as well as the SSIS server and set up...

Both. I'm not sure what the current licensing model is, it's changed a few times over the past years. It used to be that you got 5 concurrent...

I think we may be talking about 2 different things here - client-based reporting vs. server based reporting. Two different paradigms.

With MS Access even though you pull the mdb...

SSRS is available for all editions of SQL, it's just that with the free Express version you may have to download some additional files to get add on features like...

I...

Bill Boyer-284226 (5/13/2010)

---

James - Thank you. We're just looking at transitioning from SQL2000 DTS to 2005 SSIS and this helped me understand. Since you work a lot with...

Alen, if the dtsx files are stored in the file system, they are...

Excellent article James. I also have to identify SSIS and SSRS code that might be affected by schema changes introduced by vendor updates to our core system. Your...

Yes, I have an SSRS report that displays the history table. So for a particular day the report said that we should have, say, $1,000 in transactions. However,...

It looks like you're doing this properly, except a couple things have caught my eye and may be causing your issue (I wouldn't know without testing myself).

1. The error message...

Here is the expression I use in a report that has date range parameters:

="Transaction Report For Period "

& Parameters!BeginDate.Value & " - " & Parameters!EndDate.Value

The HR system we have accomplishses this by way of triggers on the tables that are to be audited. It copies updates (before and after) as well as...

Also, just remembered one more thing - if you decide to use PSExec, you will need to execute it one time interactively to answer a one-time licensing dialog. ...